Problem Pulling Email Address from People/Group List

[mrmonteith]

 I just started learning Power Automate.  I've got a flow working to send approval emails.  But it would be nice that the email could be pulled from a maintainable list.  So I created a list with 2 entries, Quality and Review.  The 2nd column is a people/group list of email addresses.  That way they are confirmed when you edit the list.  The first step of getting which row using Get Items and Title eq 'Quality' to select the Quality row worked.  I did some searches on the internet and here.  Of course nothing I could find comes close enough to help.

  The problem is from there, a clean way to pull out the email address for a TO: field in an email.   There has to be a shorter version than mine.   Playing with it the past day all day with selects and join, select, and join.... then a 'for each' to send an email.  I'm at about 8 steps, other than the manual trigger flow.  I did that to make it easy to test with.   I know using a text field would be easier.   But need that people/group field for verification reasons, etc.  But of course that people/group pulls back a lot of information.

[creativeopinion]

@mrmonteith Can you share a screenshot of your flow? If you are using the New Designer, please toggle it off and click on each action to expand it.

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[mrmonteith]

  Looking at it this morning I could probably move the email portion under the first for each.  But sure it could be made simple still.   Thanks

[mrmonteith]

I played around with it some more.  I've got it down to fewer steps.  Unless you have an even better way. 

[mrmonteith · Accepted solution]

This is some better images hopefully.

[creativeopinion · Accepted solution]

@mrmonteith Not sure why but it looks like you've already marked this post solved? Maybe by mistake? Anyway, the second apply to each action isn't necessary. You need to use a select action to pull the email addresses out into a string. Reference this section of my YT Tutorial: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate

In a previous YouTube tutorial I covered how to build a Power Automate flow that sends a single email to each user with the tasks assigned to them.

However, that tutorial only covered a scenario where each task is assigned to a single user. What if your task is assigned to more than one user?

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!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram