Approval process with multiple person field (array) - All must respond

[niema]

Hi all, 

I am struggling to create a flow for approval process. The flow is triggered by status change of the item and then it's sending an e-mail to 1st level approvers (the number of the approvers vary depending on the item), where all must respond as only then the second mail should be sent to the final approver. 

The challenge here is that the 1st level approvers are in multiple person column. 

as you will see on the screenshots, I have extracted the e-mails and joined them with ';' to create a string. 

However I added the step 'start and wait for the approver', and when tested the flow the error occurred. 

Could you please advise how I can fix this? 

[Sundeep_Malik]

Hey @niema 

Check if this helps:

https://www.youtube.com/watch?v=R18_qYVPWl4

[v-liwei-msft]

Hi @niema 

Is your flow triggered when an item in SharePoint is changed? 

If so, I don't think you need to use get items. You can create a string variable to hold the approver email. 

I made a test for your reference:

Best Regards,

Levi

[niema]

Hi Sundeep, thank you for your reply! I did watch this but the challenge is that initialize variable (if I am right) this action requires from me adding the email addresses in a string with ';' between them. Correct me if I am wrong as I still learn Power Automate 😄 

[niema]

Hi Levi, thank you for your message! Yes, the flow is triggered once the status of the item changes. 

could you let me know where the "1st level" is coming from? 

thank you!

[niema]

Hi Levi, 

I tried your idea, but it seems the step "start and wait for the approval" doesn't like the input. 

[v-liwei-msft · Accepted solution]

Hi @niema 

Add a semicolon after dynamic content in append to array. 

Remove the semicolon after the variable in the approval.

Best Regards,

Levi

[niema]

Hi Levi, 

thank you so much for this! It helped 🙂 

Could you advise with one more thing? As this step is the first level of approval process. The next step in this flow would be sending the e-mail/request to the final approvers. Am I ok just to add second step "start and wait for the approval" to get the final approval?

[v-liwei-msft]

Hi @niema 

If the second-level approval needs to be initiated after the first-level approval is approved, you may need a condition to determine whether the result is approved.

Best Regards,

Levi