Answered

Multi Level Approval with null conditions to terminate flow

(0) Share

Report

Posted on by SCoutier

Good Morning @Reza,

I have built the flow that you outlined in your YouTube video: Power Automate Multi Level Approval Workflow | Serial Approval | Multiple Approvers. The change that I made was in the Approvers list. I used the dynamic content from the SharePoint list to assign the sequential approvers in the array.

The problem that I am having: When there are only two approvers needed and listed in the SharePoint Columns the flow fails because the array lists three dynamic approvers. A null value in the third approver stalls the flow and makes it fail at the last condition.

Ideally: If the last approver approves, and the next value is null then the flow would mark the SharePoint item approved.

Any suggestions would be amazing! Your flow is so elegant... I'm hoping that I can work it into our situation.

Thanks,

Shawnna

Flow 1.PNG Flow 2.PNG

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

dbro 194 on at

Like (1)

Report
@SCoutier ,

This is how I check for an empty item in an array variable.
Initialize your Approver Array Variable
Initialize another Array Variable (call it actual approvers or something)
build an apply to each (Approver Array)
Condition - Current item is not equal to "" (leave it blank with no quotes)
In yes branch append item() to Actual Approver array.
(optional) - you can try setting the value of actual approver array to your original approver array.

Was this reply helpful? Yes No
SCoutier 7 on at

Like (0)

Report

This worked like a charm! I had to change the second apply to each to varActualApprovals, and it ran like a dream. Thank you so much!!

Was this reply helpful? Yes No