I have a form that has a lot of fields. I've added a Complete Y/N field, so when it is marked as complete the Flow will kick off and go to 3 approvers. I don't want the flow to run every time the item is modified, but I want to capture the dates the approvers completed their approval. Do I have to use the Update within the flow to set those fields and also reset a flag to not run the flow again and if I do what fields within my list do I have to include in the Update action?
Hi @kmw1130 ,
Could you please share more details about your scenario? If you would like to prevent infinite loop of updating the list, you will need to add another column say "Approved" with values like Y/N, which could be updated to "Yes" by the flow when all the three approvers have this item approved. So the trigger condition will be set to Complete equals true AND Approved equals false, update item action could update this item with the three approve dates and the Approval status.
@equals(triggerBody()?['Complete'],true)
@equals(triggerBody()?['Approved'],false)
Hope this helps.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
I have a field called "runflow" to update to Yes with the form is marked Completed. But my concern would be when I update the form with the 3 Approvers Completed Date and Comments would it retrigger the flow if I don't some how switch the flag field runflow back to now. Also after each approver approves and I added the Update Item action, there are a lot of fields to update, do I need to re-add all those or just the Title and ID fields?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
74 | |
27 | |
22 | |
15 | |
14 |
User | Count |
---|---|
143 | |
43 | |
42 | |
34 | |
30 |