Hi, just about done with my first Workflow. I query some interesting data from a database using the SQL plugin, iterate through it and pull in metadata for each element using another database and another plugin (haveibeenpwned).
The final step in my loop is using the CSV plugin to combine the data into one CSV so the results can be emailed to my team. The loop has an array-type output variable that holds the CSV for each iteration [“make_member_list”].[list]
After the loop, I have a step to email with the “Microsoft Office 365 Email” plugin. The body of the email contains a reference to the CSV like this:
The data is correct, but the open and close square brackets around the CSV are present, and there is no line break between CSV elements. Is there a way to iterate through the [“make_member_list”].[list] array within the email step and put each element on its own line? Or some other way to prepare the data for the email step?
If that’s not clear…