cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bluphoto7
Frequent Visitor

Recursive Triggering on ApprovalStatus Control

Really struggling with this one, and could use a bit of help I think.

 

I want to trigger a custom approval flow when the user clicks on "Send for Approval". Only way I can think of doing this is by a change event trigger on the library file.

I have a condition which allows the flow to progress if the approval status is "pending".

So I got that bit working, but as part of the approval, I also need to reset the new expiry date to a year from now.

If I do that after the approval, the approval status immediately reverts from Approved back to Draft (because I changed something), so I do it before the approval....

Of course, then I get into a world of recursion, because the approval status is still "Pending".

 

I can set a helper column - "ChangedByFlow" or something like that, so I can set that at the same time I do the date, but of course i have to reset it back to false at some point, and in doing so, my Approved status reverts to Draft.

 

Kind of stuck here... This is my first day of working with Power Automate and Sharepoint, so really any help is very much appreciated.

 

G

 

edit:

Should I maybe  set the approval status to Approved, then set the Date, and then set the approval status back to approved again? That might work I guess...?

 

edit2: No, that didn't work either.

1 REPLY 1
annajhaveri
Community Champion
Community Champion

@bluphoto7  yes you can set the date and then set the approval status to approved.

 

Also to avoid infinite loop in flow, you can use a service account in the connections of actions in  the flow and then in the trigger you can put a trigger condition as below

@not(equals(triggerOutputs()?['body/Editor/Email'],'user@domain.com'))

Replace "user@domain.com" with your service account email address. 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,416)