Hello,
I'm trying to capture the email addresses from a SharePoint List Lookup multi-person column in order to send emails and/or Approval actions to the recipients in Power Automate. My Flow is works until I get to the Select statement where I'm trying to extract just the email addresses.
Flow Triggered when Item is created
Actions Include:
Initialize Array variable named "varApprovalGroup"
Get Items from the Source List which has a Filter Query that only returns the item I need
Get Items from the Lookup List which includes a Filter Query that limits the action to the ID of the Lookup Column named "Approval Group"
Append to Array Variable sets "varApprovalGroup" with the Value from "Approval Group" field
Select Action. From: "varApprovalGroup". Maps to item / Approval Group. The output of that contains all sorts of properties of the multi-person lookup field, including "Email".
This is where I'm stuck trying to get just the email addresses which I then thought I could put in a 'Join' statement to populate the Approval Email To field. My thought was that I need another Select action that outputs the emails, but I'm not sure what to enter as the Map values and nothing I've tried has worked. For instance, choosing the Approval Group Email value results in another apply to each of the Current item and ends up failing because it's not an Array.
Thoughts?
------------------------------
Beth Beck
O365 Business Analyst
Fort Myers FL
------------------------------