Handle parallel approval in powerapps

(1) Share

Report

Posted on by Iantaylor2050

531

I have built a canvas app with parallel approval in place. I am using Power Automate to just send email notifications.

Rest all approval actions and status update i am handling via powerapps. The approval diagram looks similar to below.

I have handled 1st two sequential actions without any issues. While handling parallel actions, I have sent out email notifications to all Owners (i.e. Sandra, Chris, Peter) successfully via flow.

The status at step 3 is Pending Owner Approval and at step 4 is Pending Vendor Approval.

May i know how to determine whether all 3 owners have approved so that i can amend the status to Pending Vendor Approval? Since its parallel actions, any owner can approve first.

Step 3 i.e. Owner approval is a gallery with Items property as the choice column (multiselect)

Gallery Items Property

ThisItem.'List of data distributed (Choice)'

Gallery Label

LookUp('Approver List',Title=ThisItem.Value,Approver.DisplayName)

Approve Button OnSelect

If(
    LookUp(
        DS,
        ID = varapproveID,
        'Status of request'
    ) = "Pending Level2 Approval",
    Patch(
        DS,
        LookUp(
            DS,
            ID = varapproveID
        ),
        {
            'Status of request': "Pending Approval from Owner",
            APPROVED_DATE: Now()
        }
    )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi Iantaylor2050
This may be a bit basic, but if you had three fields Approver1/2/3 and write back to each with the parallel branches, you could test if all are completed. If you just want a count, you could have a numeric field Approvers set at Default zero and increment by 1 each time a branch is approved - you would then test for 3 approvers.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Iantaylor2050 531 on at

Like (0)

Report

Hi @WarrenBelz,

The number of approver is dynamic. I can have even 5 approvers as it depends on the combobox selection. If i select 5 options from combobox, it will be routed to 5 users for parallel approval.

May i know how to handle that on the Approve button OnSelect? The status should be updated from "Pending Approval from Owner" to "Pending review from implementer" only when all 5 has approved in this case.

Also, at each parallel approval step, I need to update the timestamp on when it was approved and show it in the below diagram.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

I cannot see your model or data, but if the number of approvers are dynamic, then maybe go the second option I mentioned and set the numeric field to that number, decrease by one on each branch of the Flow as it is approved, then test for a value of zero to set the status and send for vendor approval.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No