Forum Discussion
My update item flow is working but is very slow.
Hello everyone, I have just started using SharePoint and Power Automate as I am building an equipment rental management tool for my work. I currently have two lists; the Equipment list stores info...
Is the equipment list very large? If so, maybe you could use oData filters to reduce the number of items your flow needs to loop through: https://www.spguides.com/power-automate-odata-filter-query/
The equipment list only has 4 items so far while testing, and once fully populated it will have around 60 items, I have Top Count set at 500.
In my test, one of the items in the Hire Manager sheet has 3 x Equipment items selected, which means it goes through the 4 equipment items 3 times each, and this step is the only one that takes any significant time (around 6 seconds, see the flow below).
In any case, the time of the flow (6 seconds) is not significant compared to the delay of 1 - 3 minutes, which seems to be caused by delays between the event and trigger.
- Do you have a premium license for Power Automate? Sounds like it can take up to 5 minutes for those of us that rely on the licensing that comes standard: https://powerusers.microsoft.com/t5/Using-Flows/Latency-or-lag-between-flow-and-sharepoint/m-p/545281
- Thanks Kelly, that might be the problem - I'll look into a premium license.