Power Apps: 🔍 Search SharePoint Lists without Delegation Issues 💪

In this Power Apps Tutorial Video, we tackle the challenge of performing Search queries against large SharePoint Lists, WITHOUT running into delegation issues which limits searches by 500 or 2000 item limits. If you've been struggling with these limitations, look no further! This comprehensive tutorial will guide you through the process of leveraging the power of the Microsoft Graph API, directly from Power Apps as a standard licensed connector, to search within large SharePoint Lists. Throughout the video, I'll walk you through the steps of building a search box, understanding PowerApps delegation when working with data sources like large SharePoint Lists. You'll gain a clear understanding of why the Search function often fails to deliver accurate results when querying SharePoint as a data source. We'll uncover the magic of the Graph API 🚀 and demonstrate how you can directly query the SharePoint Search API, which deals with crawled content. By doing so, we'll retrieve precise search results and seamlessly integrate them into Power Apps. That's not all! We'll also delve into paginated results, search query size considerations, and other essential aspects to optimize your search experience. 💡 If you're ready to overcome delegation challenges, expand the search capabilities of your Power Apps, and harness the Graph API's potential, this video is a must-watch 🔍💪🔥 Video covers the following: ✅ What is Delegation? Key concept to understand! ✅ Search Function limitations with SharePoint from delegation perspective ✅ Microsoft Search API ✅ Search for SharePoint List items using Graph API ✅ Apply Search filters ✅ Get custom columns in Search results (Managed Properties) ✅ Call Search API directly from Power Apps ✅ Traverse through Search API JSON Response in Power Apps ⬇️ Download SharePoint Search without delegation App is available for Channel Members (Silver Club 🥈 or higher). Download link in Community Tab for Members. To become a member ➡️ https://www.youtube.com/rezadorrani/join Overview of the Microsoft Search API in Microsoft Graph https://learn.microsoft.com/en-us/graph/search-concept-overview Microsoft Graph Explorer https://developer.microsoft.com/graph/graph-explorer Hiro's Blog - Encode plain text to Base64 https://mofumofupower.hatenablog.com/entry/encode_decode Line update for Base64 code shown in video: AddColumns(ForAll(Split(InputText,""), {Result: ThisRecord.Value}),"dec",LookUp(AsciiTable,char=Result).Value) My PowerApps Delegation Playlist: https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD #PowerApps #Search #SharePoint #Delegation Table of Contents: 00:00 - Introduction to Search SharePoint Lists in Power Apps with NO Delegation Warnings 00:56 - Delegation issues with Search function in Power Apps on SharePoint Lists 01:40 - What is delegation in PowerApps? 02:15 - Non-delegable query limits of 500 or 200 items 03:34 - Demo - Search without delegation limits in Power Apps 05:21 - Microsoft Graph Search API call directly from PowerApps 08:14 - How to call Microsoft Search API from Power Apps? 16:11 - Get custom columns in Search JSON Response results in Power Apps 19:29 - Traverse through Search API Response results in Power Apps 23:17 - Power Apps Search result size + Pagination 24:53 - Subscribe to Reza Dorrani channel 🤝 Let’s connect on social: 🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/ 🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani