Unanswered

Dynamically update approval status - dynamic approval workflow

(0) Share

Report

Posted on by TO3

Hi Power Automate Community,

I'm new to PA, I've managed to build a few apps and flow, but learning as I go. I am stuck on a problem on how to dynamically update the approval status. I have an approver matrix on SP list as it requires to be dynamic.

One of the columns have a few approvers, separated by ';', I've managed to add filters on get items to return the approvers based on limit range and split out the approvers to approve with 'everyone to approve', but am stuck on how to dynamically update the status of approval on the 2nd SP list (record of applicant's data).

Researching on this problem, it seems the approach to take is to count incrementally to index, but can't seem to update the penultimate approver to 'penultimate approval' status on the 2nd SP list.

What would be the best way to approach this problem, would love everyone's advice on this.

@Pstork1

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can yu explain a bit more what you mean by "dynamically update the status of approval on the 2nd SP list."
TO3 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thanks for your response.
2nd SP list has a column of status updates.

My flow is built, 1st stage approval (review and approve irrespective of amount) before flowing to 2nd stage approval. The 2nd stage approval is based on approval matrix (1st SP list). Using everyone to approve at 2nd stage approval I am unable to update the status accordingly.

ie: 2nd stage has 2 approvers that meet conditions, I would like the first approver updating 'penultimate' with the final approver as 'final approval' updated on the status column of the 2nd SP list.
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

To do that you need to put the 2nd stage approvers in an array and run a for Each loop on that array. Set the Apply to Each loop to run with concurrency on in the settings and send the approvals out as first to approve, one for each approver. When the approval returns you can update the status by checking whether everyone else has approved or not.