Power Apps Filter and Search Functions on Large SharePoint List (including Delegation)

In this video, you will learn how to use the Power Apps Filter Function, Search Function and the concept of Delegation. These functions are useful to allow users to search through all items in your data source and/or filter your data. We will build a search box, look at delegation (working with large data sources e.g. SharePoint List) & understand why Search function may not return all items with SharePoint as a data source. We will explore delegable functions like StartsWith & look at a technique of performing search against a filtered (delegable) result set.
Video covers the following:
✅ What is Delegation? Key concept to understand
✅ Search Function
✅ Filter Function
✅ Search on multiple columns
✅ StartsWith Function
✅ Delegable Filter Query & Search (Non-Delegable) on filtered result set
Understanding Delegation in Power Apps (Canvas App) -
learn.microsof...
Power Apps delegable functions and operations for SharePoint -
learn.microsof...
🚩 Connect with me on social:
- LinkedIn: / vipul0309
- Twitter: / jainvipulcs
- Facebook: / vipuljain0309
🔔 Subscribe to my UA-cam channel
/ vipuljaineducation
#powerapps #SharePoint #SharePointOnline #PowerApps #PowerPlatform #Microsoft365 #sharepoint
#filter #search #delegation #largelist

[@aducaale328]

Thank you amazing content

[@VipulJainEducation]

Thanks for watching!

[@thelearninglife5023]

Very Clear Vipul. Best of luck

[@VipulJainEducation]

Thanks. Keep watching the videos.

[@codebychetan]

Very well explained Vipul. Keep it up.

[@VipulJainEducation]

Thanks Chetan.

[@stevehope9143]

Thank you for the excellent explanation. It was much appreciated.

[@VipulJainEducation]

Thanks Steve. Glad it was helpful !

[@faisalomari7111]

Dear Vipul, my data source is an Excel sheet, i have used your formula to filter e.g. by Case Focal point name, when i put the name nothing appears, so nothing is filtering, i have 900 rows in my excel, do you know why nothing is shown in my gallery, when i remove the name all list as 100 count shows, but when i put the first letter of the person name, nothing is shown...? kindly advise and help..

[@mallikachakraborty8471]

Hi Vipul,
If I want to create a form where multiple input sections (varying input types- text, choice and numbe) are there and whenever user wants to search for a certain record, he/she can input any of the mentioned sections and my application should be able to retrieve the record from the Sharepoint list (data source).
Please guide on how that can be made possible.

[@VipulJainEducation]

@mallikachakraborty8471 - It seems to be a very straight forward requirement. You can use the Power Apps in-built search capabilities to implement this scenario. If its a document search, then you can use Search REST API's to get the document and its metadata. May be I will create a video on this very soon.

[@mallikachakraborty8471]

@@VipulJainEducation Thank you for your response, Vipul.