Power Apps Search and Filter Functions on Large SharePoint Lists

In this video, you will learn how to use the PowerApps Search Function, Filter Function & combine both. 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 Lists) & 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 and Filter functions combined
✅ Search on multiple columns
✅ StartsWith & IN Functions
✅ Delegable Filter Query & Search (Non-Delegable) on filtered result set

My PowerApps Delegation Playlist:

Power Apps Filter Gallery:

#PowerApps #Search #Filter #Delegation #SharePoint

Table of Contents:
00:00 - Intro
00:31 - Power Apps connected to SharePoint List
00:54 - PowerApps Delegation - Working with Large Data Sources
03:55 - Search box in Power Apps (Search function delegation challenge)
07:28 - Search function limitations with Large SharePoint Lists
07:51 - StartsWith function supports delegation
09:32 - StartsWith Search on multiple columns
10:24 - Search & filter on Power Apps Galleries
12:15 - Filter & Search SharePoint List in Power Apps with delegation
19:34 - Subscribe to Reza Dorrani channel

[DanielChristian]

The varDataCount with the slider control was my personal favorite. Well done Reza.

[andreawatkins]

Love how you explain in such detail. This is one of the most helpful tutorials I've found.

[facun_OK]

You are a true gem for our community. Many thanks for this great video!

[garywhittaker]

Have been banging my head on this one for 3 days, THANK YOU

[simonball]

Ingenious solution to a common and annoying share point problem. Thank you again Reza.

[bhainsley]

Wow. This is just excellent. This resolves so many 'issues' with apps that work with large Sharepoint lists. Thanks for your patient, methodical teaching.

[catap]

Works great with combo boxes as well. Thanks Reza, you saved us again!

[Gacnty]

Best is entrance of every film ;) . But to the point. Thank You Reza for all movies. Very helpful

[Voltzz]

Thank you so much Reza. You and Shane Young are my heroes for complicated Power Apps issues! :)

[simonhart]

Best explainers of delegation around. Excellent work Reza.

[Deadpool]

Reza ur the best bro, understanding the pulse of the audience and knowing their needs is the next level u pushed to.

[wolenbergsilva]

Amazing video !! You help the entire comunity bring this videos for us Reza, i just only to say THANK YOU !

[sophiegoldstein]

It's exactly what I needed, had a problem with delegation on a large list and search with cascading filtering components. Thank you for the great lesson!!!!

[TheChugnut]

Reza, you never fail to produce informative and beautifully explained concepts!

[juancamilopesca]

Whatever I need, find a solution from you.
Again thank you, amazing contribution!

[ramolestoreinc.]

Reza you done it again you're the best PowerApps guru I ever seen bottom of my heart as you make impossible possible thank you for you help and teaching us ♥, I hope one day you will show us a loan app calculation or sales ordering app please put it in dairy for future thanks

[moserbua]

Dear Reza, Your chanel as well as Daniel's are so incredible in terms of knowledge. I'm so impressed and thankful for your work. Thanks a million times !🤗

[pierregoffin]

Dear Reza, You are exceptional. You make very interesting videos on power apps and associated tools. Your explanations are extremely clear and well structured, I have never seen so good videos on the net than yours. You exactly explain what I am looking for without useless comments or parasites like most others do. You do a very good job and you are a very pleasant person. Congratulations, best regards. Greatings from Belgium ! All the best for the new year.

[andrewcassells]

Hi Reza, this is absolutely fantastic. I had been banging my head against a brick wall trying to achieve this but your tutorial was explained and covered in depth and has solved my issue. Keep up the good work.

[RoseDing-jcfl]

This is in all ways superb. Thank you ❣For the search reset button I had to use '+' instad of ', ' - only then I was able to combine the reset functions. Now its working 😁