Build a semicolon separated string for a People/Group sharepoint field which allow multiple selection from GetItems action

Question

We have this Capital Request Setting SharePoint custom list >> which contain a Tile field and a People/Group field (which allow multiple selection named Person):

and inside our Power Automate we are getting all items from this list >> then we need to build a semicolon string for all the user emails for the item which have it's title = "Board of Directors". Is this possible using union and select?

I do not want to define an "Apply To each" if I can do it directly using Select & Union? Any advice?

Answer 1

You can use Power automate flow like this:

Expressions used:

Select Action:

• From: @{first(body('Filter_array'))?['Person']}
• Map: @item()?['Email'] - Switch map to text mode before adding this expression

Where Person is internal name of your person or group column. You can get the exact internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Compose Action:

@{join(body('Select'),';')}

List data:

Output: