Optimiser Power Automate pour traiter 100 000+ lignes SharePoint
Are you struggling with very large SharePoint lists in Power Automate? This video will be a game-changer. You'll discover how to overcome the default limits and optimize your flows to retrieve tens of thousands of items without hitting performance like crazy. I'll show you how to properly configure the SharePoint action for retrieving items, how to intelligently use the sample limit, and how to enable pagination to push the API to its limits. 🚀 We'll analyze the JSON response together to understand how SharePoint structures the data and how to leverage this to reduce the response size. You'll then see a fully optimized flow that can handle over 100,000 items while remaining stable and fast. 💡 If you work with large databases, this tutorial will become essential. Power Automate skill level: Intermediate Let me know what you think in the comments. My email address for any questions: [email protected] Join this channel to get access to exclusive benefits: / @cybermatik Need help? I'm available to help you through the following two methods: Freelancing via Malt: https://www.malt.fr/profile/dimitrigo... On-demand services: https://outlook.office365.com/owa/cal... Connect with me on social media: LinkedIn: / cybermatik2 Facebook: / cybermatik-104905521710703 Twitter: / cybermatik_ Episode 210 of Cybermatik - Optimizing Power Automate to Process 100,000+ SharePoint Rows Chapters 00:00 Introduction 00:42 Overview of Work Lists 01:14 Basic Power Automate Configuration 02:19 Verifying the Information Retrieved by the Data flow 02:38 Count the number of records retrieved by the action 04:22 By default, only 100 items are retrieved... 04:53 Increase the sample limit 07:08 The 5000 record limit 07:55 Enable pagination 09:27 The 100,000 item limit 11:33 Filter the retrieved item list 11:41 Video - OData Filters 15:33 The optimized data flow, SharePoint HTTP call 18:04 Conclusion Presenter: Ton geek Dimitri on office software: Excel, Power BI, Power Automate, Power Apps, Office, Windows, Word, PowerPoint, and VBA for applications.


