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

Copper Contributor

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!!

 

Power App1.JPG

2 Replies
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!??

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