Get items per user in multiple people picker field (Power Automate)


The article discusses how to split emails from a multiple people picker field in Power Automate. When the column allows selection of multiple users, you may want to send only one email per user, even if they share the item with others. To achieve this, you need to use a loop and multiple 'Select' actions. First, select all the users from the items and loop through them to select their email addresses. Then, use a 'Compose' action to join the email addresses into a single string. After the loop, split the string to convert it into an array of email addresses. Finally, use the union expression to keep only the unique email addresses. The article also explains how to filter the items for each user and provides a summary of the process.


Article 17m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time