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
- contato@vicotreinamentos.com.br
📚 FREE study group
- Telegram: https://vicotreinamentos.com.br/TelegramGroupPowerPlatform
🔽 Connect with me
- Instagram: https://www.instagram.com/ronanvico/
- LinkedIn: https://www.linkedin.com/in/ronan-vico/
🙌 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!
https://youtube.com/c/RonanVico