How to Retrieve More Than 2000 Items from SharePoint in Power Apps – Fix Delegation Issue Best Way!

Описание: Learn Power Platform faster at Pragmatic Works with this special discount!
Click here https://prag.works/PWT-affiliate-Vico...
Or use our Promo Code (VicoPWTODL)

Are you struggling to retrieve more than 2000 rows from a SharePoint List in Power Apps due to delegation limits? In this step-by-step tutorial, I will show you how to overcome this limitation and load large datasets efficiently.

What You Will Learn in This Video:
✅ How delegation works in Power Apps
✅ Why the 2000-item limit exists and how it affects SharePoint lists
✅ Step-by-step solutions to bypass the delegation issue
✅ Alternative methods like collections, pagination, and splitting queries

Power Apps has a delegation limit that prevents large datasets from loading directly when using non-delegable queries. However, by implementing proper delegation techniques and workarounds, you can effectively retrieve more than 2000 records.

In this video, I demonstrate multiple best practices and solutions, ensuring your Power Apps application works smoothly while handling large datasets from SharePoint.

💡 If this video helped you, don’t forget to like, comment, and subscribe for more Power Apps & Power Automate tutorials! 🚀

00:00 Issue Delegation warning. The data source might not be able to process the formula
02:40 What is and what isn't delegable
04:01 Delegation meaning of the word and changing 500 rows to 2000 rows
07:17 Creating an autonumber id in power apps canvas mirroing ID from sharepoint list
14:50 Using Microsoft Access to Update an Column from sharepoint list with SQL commands
17:32 Collecting all the data from sharepoint list in a collection without delegation issues! .
----
🎲 Consulting and Partnerships - Contact me
[email protected]

📚 FREE study group
Telegram: https://vicotreinamentos.com.br/Teleg...

🔽 Connect with me
Instagram:   / ronanvico  
LinkedIn:   / ronan-vico  


💵 Support the channel by checking out our partners:
-Master Power Platform with exclusive discounts at Pragmatic Works: https://prag.works/PWT-affiliate-Vico
-Reliable and affordable VPS hosting: https://www.hostg.xyz/SHHTG
-Level up your skills with courses from DataCamp: https://datacamp.pxf.io/oqjkGn

🙌 HELP THE CHANNEL!
Press the THANKS button in my Videos.
Become a member of the channel, buy us a coffee☕ per month!
Share the channel!

📹 Fala português? meu canal Brasileiro!
   / ronanvico