Resend request for approval after item list is modified

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone!

I have a flow of two successive approvals. Here have a summary of my flow.

When new answer is submitted from MS Form a Sharepoint list is created

⬇️

Triggers Approver 1 for approval request

⬇️

If yes Send to Approver 2 approval request

If Approver approves : approval status updated + mail sent to requester
If Approver rejects : approval status updated + mail sent to requester

I would like add an "Request to Edit" option for Approver 2, in case the Approver 2 want the requester to add more information and then have an approval resent to Approver 2.

I wanted to add a "When an existing SharePoint list item is modified" then trigger approval, but it is not an available option.

Any ideas of how I could achieve this result?

Thank you in advance! Let me know if you need more clarifications.

All responses (3)

Answers (1)

Pstork1 66,015 Most Valuable Professional on at

Like (1)

Report
Re: Resend request for approval after item list is modified

To keep it from looping add a Trigger condition to the settings of the Trigger. Check the original run and look for Moderation Status. That's the field that has the content approval in it. That is usually set to "Pending" when an item is edited directly. So the following Trigger condition will normally keep the flow from firing when you update the approval status to Approved.

@equals(triggerOutputs()?['body/{ModerationStatus}'],'Pending')
Community Power Pla... on at

Like (0)

Report

Re: Resend request for approval after item list is modified

Hi @Pstork1 ,

Thank you for your help, I have made the flow as below and it works, however once approval is approved or rejected the flow is going on a loop. Would you have any advice on how to stop that?

Thank you in advance! 🙂
Verified answer

Pstork1 66,015 Most Valuable Professional on at

Like (1)

Report

Re: Resend request for approval after item list is modified

A couple problems to overcome.

1) You can't have two triggers in a single flow other than very special circumstances. In this case you can't add a second trigger.

2) You can't resend an existing approval. But you can send a new approval.

So here's a workaround. Add a column to the SharePoint list for Request Edit (Yes/No). Save the existing flow under a different name to make a copy and change trigger to when an item is modified. Check to see if the Request Edit field is Yes. If it is proceed with sending the approvals. If its not exit the flow.