web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : wUFmALgX2uFcxWyiFUqjfX
Power Platform Community / Forums / Power Automate - Building Flows / Collect multi-person c...
Power Automate - Building Flows
Answered

Collect multi-person column in collection or array

Like (0) ShareShare
ReportReport
Posted on 17 May 2021 10:27:06 by kyon84 41

Hello,

 

My flow triggers "When item is created in SP list". One column - "Approver" is multi-choice person type column. I want to store persons in this column to collection or Array and assign  "Start and wait for an approval" task.

When I want to create task it switch to "Apply to each", which is something I want to avoid. 

 

I'm trying to create Array first but same problem.

 

Thank you for any advice.

 

I have the same question (0)
  • kmw1130 Profile Picture
    kmw1130 972 on 22 Sep 2022 at 11:52:36
    Re: Collect multi-person column in collection or array

    @annajhaveri I ended up doing it this way (after watching a video):

    kmw1130_0-1663847395524.pngkmw1130_1-1663847426310.png

    which ended up working, but the problem is I have another field called Hiring Team, which is of the same type and I would have to add the send email into that group of actions and it would send out two separate emails.  I would want to be able to concatenate the Hiring Managers and Hiring Team (both multiple SharePoint Person field) and send one email.  Right now, I'm sending 1 email to the Hiring Managers.

     

  • annajhaveri Profile Picture
    annajhaveri 8,531 Most Valuable Professional on 22 Sep 2022 at 06:10:50
    Re: Collect multi-person column in collection or array

    @kmw1130  can you please share screenshot of your flow's dynamic content, search for approver field in it.

  • kmw1130 Profile Picture
    kmw1130 972 on 21 Sep 2022 at 14:31:27
    Re: Collect multi-person column in collection or array

    @annajhaveri It is a multiple person field

  • annajhaveri Profile Picture
    annajhaveri 8,531 Most Valuable Professional on 21 Sep 2022 at 14:28:20
    Re: Collect multi-person column in collection or array

    @kmw1130  what is the data type of Approver field in SharePoint list?

  • kmw1130 Profile Picture
    kmw1130 972 on 21 Sep 2022 at 13:42:23
    Re: Collect multi-person column in collection or array

    I've done this before and it has worked, but my current flow, which is a Recurrence flow and Get Items, when I append to string I don't have the option to select the Approver's email I only see the Approver.

  • Verified answer
    annajhaveri Profile Picture
    annajhaveri 8,531 Most Valuable Professional on 17 May 2021 at 11:17:53
    Re: Collect multi-person column in collection or array

    @kyon84  to get the approvers in one string, do following:

     

    1. Add Initialize variable action and name the variable as Approvers, and select type as string

    2. Then add apply to each action, select the approvers field in the input of action

    3. Add Append to string variable action inside apply to each action and select the approver variable, and select approver email field with , (comma) in the value, see screenshot below)

    4. Now use the approvers variable in the start approval action

     

    annajhaveri_0-1621250262237.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 854 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 525 Moderator

#3
trice602 Profile Picture

trice602 318 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans