
Hello everybody,
I am trying to make a flow when all approvals are OK, it send an new approval.
In my list I am using a calculated item. If 5 approvals are "approved", it calculates it as "1" otherwise "0" in "APPROVAL CHECK" column.
My problem is even I am using "float" function and "APPROVAL CHECK" column format is "number" it doesn't work.
How can I proceed?
As an alternative to a calculated column, why don't you set a variable at the start of your flow, approval check=1.
In each of your 5 approvals, if anyone rejects, set the approval check variable=0 and upon completing your flow, set the outcome of approval check back to your item column "Approval Check".
You can then setup a new flow that triggers on the item being updated and specify a trigger condition under settings where @equals(triggerBody()?['Approval Check'],"1")