CC Person/Email without looping

Like (1) Share

Report

Posted on 16 Jul 2024 12:42:13 by serviceflow2

I have an flow that gets items from a SharePoint list, creates HTML table and emails it. We have a column in our SP list that is a person column where Sales Person is associated to the record in the list. I want to add the Sales Person Email to the CC field in the Outlook Email V2 action which emails a single HTML table. There may be 20 records or less in the email table and need to CC any unique person/email where someone is assigned to the record. Am I able to do this without the Apply to each? I only want a single email to go out so looking for some code that can get all unique Sales Person emails in the list of records in the table and add them to the CC in the outgoing email.

Thanks!

All responses (1)

Answers (1)

Verified answer

serviceflow2 49 on 16 Jul 2024 at 13:44:32

Like (0)

Report

Re: CC Person/Email without looping

Resolved
Used Select function to select the sales person email
Then Compose with a union "union(body('Select'),body('Select'))"
Then join function from outputs of Compose and Join with ";"

Used the output of the join to get a distinct list of emails to use in the CC

Reference post here:
https://elliskarim.com/2022/10/10/how-to-remove-duplicate-email-addresses-from-a-set-of-data-using-power-automate/