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