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