Mar 11 2024 10:37 AM
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!!
Mar 18 2024 04:06 AM
Mar 18 2024 04:35 AM
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)
Jul 08 2024 08:57 AM
@Rob_Elliott Thank you, will try this!
Jul 10 2024 03:31 AM
Mar 18 2024 04:35 AM
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)