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