Using 'when an Item or a file is modified' in Flow leading to slow performance warnings

[Paul_Dillon]

Hi all, I have a SharePoint folder where documents are saved while an admin process is being followed; there are 7 steps to this process (request received, acknowledgement sent, document submitted, etc) which are determined by a drop-down list in the folder column.

When a process stage is selected, the 'due date' column populates with a specific date, dependent on the process stage selected - I've written the flow for this using the 'When an Item or a file is modified' command.

However, the flow seems to run by continually checking back to SharePoint at recurring intervals, rather than being triggered by the SharePoint column change, resulting in 'slow performance and exceeding Power Platform Request limit' warnings.

Is there another action I could use to enable the trigger only when the column is updated, replacing the 'When an Item or a file is modified' action?

Many thanks in advance for any help!!

[#2]

How can I have 76 views but no responses- I wonder if I haven't phrased my issue correctly, or there isn't a solution!??

[#3 · Accepted solution]

@Paul_Dillon in the new designer the when an item or a file is modified has that parameter for how frequently to check for changes. I suggest you switch back to the classic designer where the trigger doesn't have that parameter. It should then only run when the specific column has been changed.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

[#4]

@Rob_Elliott Thank you, will try this!

[#5]

Hi Rob, I couldn't get this to work - I re-did the flow on classic but I still got the throttling warnings, and any time I tried to reconfigure, it would open up in the new designer. I also tried multiple times to reset the frequency of the check to 1 time per hour, but it keeps defaulting back to 5 minutes - I just can't get this to work and it seems so simple. Very frustrating and a very bad user experience!!