Power Platform Community Forum Thread Details

Get Items, select Email address from people column that allows multiple

I've researched several threads on this topic and I can't get the syntax correct, nor the flow to work properly. I thought I understood how to select values from an array, but I can't get it to work.

Scenario

I'm using Get items to retrieve from a SharePoint list. The items I'm retrieving contain a text field called 'Agenda_x0020_item' and a person field that allows multiple people, column name 'Assigned_x0020_to', contains the field 'Email' and 'DisplayName' I want to select
The 'Assigned_x0020_to' field is blank in some cases
I want to create an HTML table that I can send via email to a distribution list

HTML table should contain

Agenda item	Name
Agenda item 1
Agenda item 2	Person A DisplayName
Agenda item 3	Person A DisplayName, Person B DisplayName

Email needs to go to the distribution list, with a CC to the Person A Email and Person B Email.

Any help is much appreciated. Thank you.

@allan_t I recently uploaded a YT Tutorial that you might find helpful: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate

In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams.

Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.

IN THIS VIDEO:

✅ How to trigger a flow from a selected file

✅ How the multi-person column data outputs

✅ How to use the Select action to get all assigned to users of a SharePoint item

✅ How to use the Join action to convert an array of email addresses into a string

✅ How to send a single email to all assigned to users of a SharePoint item

✅ How to send an email to each assigned to user of a SharePoint item

✅ How to send a Teams message to each user assigned to a SharePoint item

✅ How to return a list of unique users from the multi-person column in a SharePoint list

✅ How to use a Filter Array action to return all SharePoint list items assigned to each user

✅ How to group Power Automate actions together with the Scope action

✅ How to edit a previous flow

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Quick Links

Leaderboard > Power Automate