Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Optimizing Get Excel Records, Compare Unique Values Against Existing SharePoint List, Collecting Value ID if Value Found, and Creating New Record in Another SharePoint List

What would be the best route to go if I want to get over 1,000 excel records (excel online), compare all the unique values from two specific columns to two different SharePoint lists, collect the ID number if those values found in the two SharePoint list, and then create all the records from the excel table under another SharePoint list, using the ID number found from the other lists, in under a minute? Right now, I have my flow setup to accomplish the desired outcome but it takes about 22 minutes for a little over a 1,000 records.

Community Support
Community Support



Without seeing your flow its hard to make suggestions on how to optimize it. However given that you are grabbing over 1000 records and then writing all of those values to Sharepoint I doubt that it will be possible to make it that much shorter. You could always try turning on parallelism, but thats only doable on certain actions in the flow.








Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,367)