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

Like (0) Share

Report

Posted on 25 Apr 2023 18:24:52 by johnjohn123

3,502

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

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (3)

Answers (1)

Verified answer

Pstork1 67,693 Most Valuable Professional on 25 Apr 2023 at 20:45:26

Like (0)

Report

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

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
johnjohn123 3,502 on 25 Apr 2023 at 20:42:33

Like (0)

Report

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

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

Was this reply helpful? Yes No
Pstork1 67,693 Most Valuable Professional on 25 Apr 2023 at 18:38:39

Like (0)

Report

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

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