There has to be a better way here.
I have an excel spreadsheet with a table that I am pulling rows for.
The spreadsheet is kept on our SPO Site.
I am comparing this sheet to a list we have on our SPO site.
I am them updating fields in the SPO site from the spreadsheet.
So everyday at 5am, this starts and I have a do until for it to run every 10 minutes till 9pm.
So it gets the excel
Gets the SPO List
If an item from the spreadsheet is equal to an item in SPO List, we then update that part in the list with the info from Excel.
There are only around 55 rows total for both, so it is NOT huge.
I got to around row 37 in the SPO List, at around 30 minutes. This is not working as I intended.
Can someone take a look at this and tell me what I am doing wrong, and how I can improve the performance?
The only thing i can think of is to loop on the Excel Rows and on the Get Items add a filter ODATA expression to get the Item you want to update instead of navigating all items on your sharepoint list.
Ok, I figured this out. I did put a filter, but I don’t think that is what my issue was.
I started messing with the source data, and found that the flow is looping non stop. So it is running through the process all over again.
I have the recurrence set to run every 10 minutes, with a start time each day of about 5am.
I have the whole process in a Do Until, with it stopping the flow around 10pm each night.
Do I have this set wrong?
How do i start this each day at a certain time, run on an interval, and then stop at a certain time?
I want it to start at 5am and run until 10pm.
It is just looping through though.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.