Answered

Collect multi-person column in collection or array

(0) Share

Report

Posted on by kyon84

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.

All responses (6)

Answers (1)

kmw1130 950 on at

Like (0)

Report

Re: Collect multi-person column in collection or array

@annajhaveri I ended up doing it this way (after watching a video):
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 8,531 Most Valuable Professional on at

Like (0)

Report

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 950 on at

Like (0)

Report

Re: Collect multi-person column in collection or array

@annajhaveri It is a multiple person field
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Collect multi-person column in collection or array

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

Like (0)

Report

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 8,531 Most Valuable Professional on at

Like (0)

Report

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