json - MS Flow send an email, add addresses from SharePoint list

Question

Here is what I have thus far:

1. Set a schedule to run
2. Connect to the SharePoint list
3. Select from that list
4. Join the email addresses separated by a ;
5. Send an email to those addresses

I probably need to parse or extract the email addresses from that output before the join right? I need to figure out what action to use to do that.

question from:https://stackoverflow.com/questions/65942113/ms-flow-send-an-email-add-addresses-from-sharepoint-list

Answer 1

When you use select, you're creating an object array. You can use the compose feature inside a Apply to Each loop to do what you're trying to do. When you use a compose inside an Apply to Each control, you're essentially creating an array.

After the Apply to Each, create a Compose action that joins the output of Compose with a semicolon

join(outputs('Compose'),';')