2 step dynamic approval workflow

[andjelamiha97]

Hi everyone. I am trying to build a flow with a 2 step dynamic approval. I was looking at @RezaDorrani videos and he has awesome content, but i just can't seem to figure out how to do this. I will include my flow below and the lists from which the flow is pulling out the information from. 

As i said this would be a 2 step approval, but both approval steps to be dynamic in nature. We have a list of applications as one column, asset owners as a second column, and access provisioning as a third column. The flow would work like this: So, we have a SharePoint Site>end user goes there to submit a request for app access>chooses the app from the dropdown menu >we want the asset owner to approve it first (to dynamicaly pull it from the second column), once it is approved>it goes to the second person to create the account (to dynamically pull the person from the third column). So, basically to pull the approvers 2 times from different columns. My approval matrix has : application, asset owner approver, access provisioner. I have made the flow work where only the first part is dynamic. It goes to the appropriate asset owner (pulling it from the second column)>and then the second part of the flow start another approval, but i couldn't make it dynamic (to pull the access provisioners from the third column.)

This is where the user submits a request - when they choose the application it goes to the appropriate asset owner, and then it should go to the appropriate access provisioner(column named provisioning), (still trying to figure that part out).

This is the list and the columns from which the flow is pulling the info from.

My flow:

This is the approval that i would like to be dynamic. Basically like the first one. I would want the second approval to choose the right people from the "Provisioning" column and send it to the assigned people

This is where i would want the approval to be dynamic in nature as well. I would like for the flow to pull the people from the "Provisioning" column and send the approval to the assigned people based on each application.

Can someone please help me? @MarconettiMarco @Pstork1 @RezaDorrani 

[TO3]

Hello Pstork1,

I am a new to PA but have built a few flows and apps, learning along the way. I am stuck on a problem and hoping you or the community can assist. I have a SP list approver matrix, designed this way so it is dynamic. The multiple approvers in the list are separated by ';', I have managed to split it out and used everyone must approve, but I am having issues how to be able to update the status dynamically.

so if the first person approves in that email, the status is 'approved' with the last person on the list 'final approve'

Would appreciate some guidance on this. Tara

[Pstork1]

Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later. If you send me a link I'll try to help there.

[andjelamiha97]

Hi Chad! I am following up on this. Do you maybe have a video for a situation like this? Or a flow i could follow? Thanks!

[ChadVKealey]

If you could be more specific about "this", that would be great. I see a reply from you on 9/23/2022 to which I never replied (sorry, that was an extremely busy time for me) asking what to do when there was no "provisioner 2". There is a "Terminate" action in Power Automate, so you could have a condition check to see if "provisioner 2" is equal to "null" (the word null, with no quotes or anything, and not the expression null) and, if so, terminate the flow.

[andjelamiha97]

No problem. So, i have a multi-step approval flow. I used your video: Working with multi-select person fields in Get items output. But, I have 3 approvers (if you have time to read above for more details). The first approver is pulled from a drop-down menu (they select the application, once selected it will go to a specific person). Is there any way to advance the flow for the user to be able to choose multiple applications from the dropdown menu, but for the flow to work in the same way. So, let’s say i want to submit the request and i want to select 5 applications from the dropdown menu, but for the flow to send the approval to 5 different people (approvers) assigned to those selected applications and then to send them to 5 different provisioners?

[ChadVKealey]

Yes. As @Pstork1 mentioned in this post, you would put all of the existing actions inside an apply to each operating on the array returned from the "Applications" column value.