Solved: Re: How often does SharePoint File Modification Tr...

kyleb350 · ‎02-04-2021

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!

CFernandes · ‎02-04-2021

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!

View solution in original post

CFernandes · ‎02-04-2021

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!

kyleb350 · ‎02-04-2021

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

CFernandes · ‎02-04-2021

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.

kyleb350 · ‎02-04-2021

@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.