Answered

How often does SharePoint File Modification Trigger listen? Possible Infinite Loop

(0) Share

Report

Posted on by kyleb350

Not sure if this is bad practice, but I am trying to simplify the end user process as much as possible. If I have a trigger to initiate a flow on a modified spreadsheet then proceed to make corrections to the data input by the user, will Power Automate recognize that as a new modification to the file and initiate another flow?

My intention is to have the user save the spreadsheet as a CSV copy after that. If Power Automate does indeed recognize each modification as a trigger, I will create a new file with the corrected data.

Thanks!

Categories:

Process mining

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @kyleb350

If you click on the (...) ellipses of your SharePoint Trigger and click on Peek code you can find the Trigger recurrence.

An ‘Infinite Loop’ occurs with SharePoint based triggers ‘When an file is created or modified’ where the Power Automate itself updates the Files or creates the file in the same library where the Trigger is associate. If you are saving the spreadsheet in a different Library then the infinite loop should not occur.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
kyleb350 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you @CFernandes ! It's good to know I can modify the trigger recurrence interval too!

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @kyleb350 ,

Just to clarify, you cannot modify the trigger recurrence value using Peek code, you can just view it.

That being said you can use Trigger condition which should help you avoid the infinite loop.

Have a look at @RezaDorrani video https://www.youtube.com/watch?v=oKN4_5o2NUA where he explains how to tackle infinite loop.

Was this reply helpful? Yes No
kyleb350 15 on at

Like (1)

Report
Copy link

Link copied!

@CFernandes . Ah, switching a boolean value to disable the trigger condition while the flow is currently running (then enabling it when the flow is done) sounds like a great idea. I will do that!

Thanks again.

Was this reply helpful? Yes No