cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
babzi_naaz
Frequent Visitor

Filter List items stored in a collection

Hi,

 

I have a requirement to export an excel sheet having 2100 records to SharePoint list. I've implemented this by checking Get Items Action with Filter condition, If the item exists in Get items action, Flow will update the item, otherwise it will create a new item. But the problem is the flow is taking more than 2 hours to complete to update/create 2100 items in SharePoint list. So I need to optimize the flow by avoiding the consuming of Get Items action with Filter for each and every excel sheet record. Can we avoid this SharePoint list list item search by getting all the items in a collection? Can anybody help me on this. Thanks in advance..

1 REPLY 1
sudharsan1985
Solution Sage
Solution Sage

Hi @babzi_naaz 

Try to use batch process to get or update the items in batch. Please refer the below video

https://www.youtube.com/watch?v=7f7DThyWmsk

 

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,822)