![]() I noticed the screenshot is missing a trigger, but it’s a ‘Recurrence’ trigger as in all reminder flows. string(item()?)įrom that point on you can continue with the original flow – build an HTML table and send the email. The easiest way is to convert the array into a string with the string(…) expression, which will allow you to use the ‘contains’ operator. You must check the whole array of objects if one of them contains the email address. Therefore, you can’t simply filter by the user email. As already said, the people picker column in each item will contain an array of users. The other difference from the original flow is in the ‘Filter array’ action. union(variables('var_emailsArray'),variables('var_emailsArray')) Filter the items for each user Process it with the union(…) expression to keep only the unique values = unique emails. ![]() Note: my column is called ‘SendTo’, your column will have most probably a different name.Īt the end of the loop you’ll have a variable that’ll contain all the email addresses as separate items. And in that loop place the ‘Append to array variable’ to store their email address. In that loop add another ‘Apply to each’ to loop through users in the people picker field. Once you initialise the variable, add ‘Apply to each’ to loop through all the items provided by the ‘Get items’. In that variable you’ll store each email separately. You’ll have to use a less efficient way with double loops.īut first, initialise a new array variable, e.g. And as such you can’t get the email addresses as easily using the ‘Select’ action. It won’t be an object with the user anymore, now it’ll be an array of objects (=users). Once you switch the people picker column to multiple selection, its structure will change. “Is there a way in Power Automate to split emails from a multiple people picker field to have a single email per user for all of the items in which they are included as an owner?”įollowing a question from the original article to Send one email per user with multiple SharePoint items, what if the column is not a single people picker? What if the column allows selection of multiple users? If you have more than 1 user assigned per item? You probably still want to send only one email per user, even if they share the item with others.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |