OVERVIEW

This guide will teach you how to send an HTML email with data from a table in Okta Workflows.

SOLUTION

You want to send the following data in an HTML email (in a table format):

Workflows table.

The automation will use the List—Reduce card to collect all data into HTML table rows. 

Guides and examples about using the List—Reduce card to format a data list into a single value.

This is the main flow:

Send HTML email flow.

The flow has the following steps:

1. The Table—Search Rows card returns rows from the table.
2. The List—Reduce card sends the list data to a helper flow, which converts each record into an HTML table row. The Reduce card returns a single text with the data in HTML table format.
3. The Text—Compose card closes the table HTML tag.
4. The Gmail—Send Email card sends an HTML email. The card sets the Body is HTML field in Options to Yes.

The helper flow:

Create an HTML table row.

The flow has the following steps:

1. The List—Reduce card from the main flow passes the Fruit and Color fields to this helper flow.
2. The Text—Compose card creates an HTML table row and appends it to the memo field, which holds previous HTML table rows.

The email you will receive after running the flow:

Data from a Workflows table in an HTML email.

Download the flows

Download and try this flow automation.

RELATED REFERENCES

• Search Okta System Log and Email the Results in Okta Workflows.
• Save Deactivated Users, Export as CSV, and Email in Okta Workflows.
• How to Export Group Membership to a CSV File and Email the File in Okta Workflows.
• How to Send HTML Email with Gmail and Office 365 Email in Workflows.