Solved! Go to Solution.
Hi @AKB_2K19,
You could click Filter array-Edit in advanced mode, then configure and() function.
https://docs.microsoft.com/en-us/flow/use-expressions-in-conditions
Adding additional decision conditions is what I mentioned in my previous post.
As for the Update row action, you could configure it above the Start an approve action, which is the first action of that branch.
Please take a try.
Best Regards,
Hi @AKB_2K19,
What you mean is that if Approver does not perform the approval, the value of the corresponding field will not be updated. So The next day Flow will get the corresponding row, and then send the execution of the Start approval action again?
Could you share the details of your Excel table and Flow configuration? It is best to take a screenshot.
The suggestion I have given currently is that you could consider adding an additional column, configure Update row action on the "Start approval action", and change the status of this column to a value such as “approval that has been sent”.
In addition, when checking the row that needs to send the approval, it is necessary to check the status value of this column additionally. If it is empty, it needs to be sent to approve.
You could add additional conditions via the and() function.
I don't know the specific configuration of your Flow. I cannot provide a good example. I hope the above suggestions can help you a little.
Please take a try.
Best Regards,
Barry
This is flow I have created.
In case of Approval taking more than 1 day to approve the change, next day flow again triggers them with the same email because it sees that Sent For Approval column has been marked with Yes. This is creating duplicate records in the approver's Received tab. Even if he approves that request, there are other requests with same title pending in his/her queue.
@v-bacao-msft you mentioned about adding additional column where Flow will update the table with “approval that has been sent” and using and() function. Can you let me know where do I insert this and() function and during which step I should update that the "Approval has been sent" to excel table?
Hi @AKB_2K19,
You could click Filter array-Edit in advanced mode, then configure and() function.
https://docs.microsoft.com/en-us/flow/use-expressions-in-conditions
Adding additional decision conditions is what I mentioned in my previous post.
As for the Update row action, you could configure it above the Start an approve action, which is the first action of that branch.
Please take a try.
Best Regards,
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
36 | |
36 | |
23 |
User | Count |
---|---|
41 | |
31 | |
29 | |
28 | |
26 |