I am interested in creating a Flow similar to the attached image.
When a list item in sharepoint is ready to be submitted (submit for approval field = yes), an approval email is sent to Approver #1.
If approver 1 approves, a field in the sharepoint list changes to "approved by approver 1" and an email is sent to approver #2.
Once Approver #2 approves, the same field in the sharepoint list changes to "approved by approver 2" and the workflow stops.
The flow should also stop whenever approver 1 or approver 2 clicks reject in the approval email.
Lastly, once the workflow is stopped, when the list item is submitted again, the workflow should start over.
Hi @Anonymous,
The logic should work under Microsoft Flow, issue here is how would you like to get the corresponding list item?
Please take a note that the Send an Approval Email can't be used within an Apply to Each.
So the available trigger that could be used here should be:
When a new ite mis created, or When an existing item is modified
For the Approval Email, use nested condition:
For example:
1. First condition to check the Approve field status, if equals to Yes, then check condition 2,
2. Condition 2 is used fto check Approved by field, if this field is empty, send Approval Email to first approver,
3. Condition 3 is used to check if hte Approved by field is equal to string "Approved by Approver1"
4. Condition 4 is used to check the Selected option of Approver1, if yes, update Approved by field to "Approved by Approver1", if no, update the Approve field to "No".
5. Within Condition 3, if yes, Send Approval email to Approval2, then condition 5 to check SelectedOption,
6, similar to step 4, if yes, update Approved by field to "Approved by Approver2", if no, update the Approve field to "No".
Regards,
Michael
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2