Power Platform Community Forum Thread Details

Hi,

I have created a flow which is linked to PowerApps. Once the end-user fills in the request form in PowerApp, a new SharePoint list item is added. Once this item is assigned to someone in the team, the requestor gets an e-mail that their request has been assigned to the allocated person.

This all worked well until the item got assigned to multiple people. Now the requestor receives two the same e-mails with different allocated persons. How can I ensure that both assigned people get added in one e-mail?

Thanks for your help in advance.

Cheers

Categories:

General topics

Hello,

You may need to use this solution:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-convert-Array-variable-to-string-to-use-in-send-email/td-p/382120

---

Flow details:

I suppose you have a list in sharepoint where people can add items there and there is a column with type Person where you can define if you allow multiple entries or not;

The result would be something like this:

Demo/test

1) Initialize variable

Trigger: when an item is created or modified (you can verify if a specific column has changed to check if someone was assigned - but this is just a detail for your flow);

Initialize variable: created a string "emails" to hold all the e-mails in a specific column called "Person" with type "Person or Group"

2) Loop with "Apply to each" for every Person's email and append the result to the variable

Apply to each: used the below expression to check the column "Person" for details; it will loop for all the People added here.

triggerOutputs()?['body/Person']

Append to a string variable: used the below expression to add to my variable "emails" all the results from my loop - only the e-mail part; Then added ";" because outlook requires ";" between emails.

items('Apply_to_each')?['Email'];