Answered

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

(0) Share

Report

Posted on by johnjohn123

3,514

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;s emails for the item which have its 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?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Here's a screenshot of a sample that does that with a field called "Supervisor"

Use a Select Action to create an array of the Email values for the multiselect field and then a Join() to turn that array into a semicolon delimited list.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 so i have to use Apply To each, i thought i can do it without it

Was this reply helpful? Yes No
Verified answer

Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

In this case the apply to each is to process each SharePoint record returned by Get Items. Once you have the multiselect value all you need is the Select action and the Join. Each loop will create a string for the multiselect field from that record.

Was this reply helpful? Yes No