You’re offline. This is a read only version of the page.
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.
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.
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
