Request Approval- Sharepoint List runs on error if more then one approver is entered

[Mischa2710]

Hello, the user has the possibility to assign the workflow to one or more users and the sharepoint list should enter the assigned in column (Person or Group ). Unfortunately it only works if only one user has been assigned. 

Show raw inputs

Show raw output

Any idea? Thanks in advance.

Michael

[eric-cheng]

Hi @Mischa2710 ,

For multi people field, you will need to pass in array.  Please see this link for an example.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Mischa2710]

Sorry, but I don´t think that this works for a flow which starts with "For a selected item". I would like to enter the name of the person, the flow has been sent to, in sharepoint list . This could be single or multiple persons be.

[eric-cheng]

Hi @Mischa2710 ,

Just to confirm, you will specify one or more approvers in the manual trigger and then you want to update the approver column for that list item right?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Mischa2710]

Yes, that´s correct ... to make it more clear, let me show the steps:

1. Item will be activated, Approvers will be entered and flow will be executed

2. Status,Start Date and Approver will be entered in respective columns

3. Everything works, but as soon I enter multi Approver it runs on error and I don´t know how to create an array therefore.

[eric-cheng · Accepted solution]

Hi @Mischa2710 ,

The concept for the previous post is still the same.  Anyways, try the below:

1) Init 2 arrays.  For NewApprovers, split your email field based on ;

@split(triggerBody()['email'],';')

2) Loop through your NewApprovers array and append to the Claims array in the below JSON format.  Pass the Claims array as the approvers in your SharePoint list.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Mischa2710]

Thank´s for your help

Greetings from Munich