Power Apps Search Vs StartsWith in SharePoint Lists | Delegable Function Selection for Search

In this Power Apps tutorial video, we will delve into the topic of efficiently searching within SharePoint lists using delegable functions. We'll take a closer look at the PowerApps Search function, along with StartsWith and IN functions, to determine the optimal approach for searching through large amounts of data (more than delegable limits of 500 or 2000 items).

We will build a Power Apps search box experience to Filter our SharePoint list data, while also emphasizing the importance of delegation when dealing with large data sources. We will create a ONE search box experience while searching across multiple SharePoint columns such as Text, Lookup, Choice, and Person.

Power Apps Search* in SharePoint list video covers:
✅ Search function
✅ StartsWith function
✅ Search and IN delegable with SharePoint?
✅ Search on multiple SharePoint columns in Power Apps
✅ Search in Text, Choice, Lookup and Person type columns in SharePoint Lists

My PowerApps Delegation Playlist:

#PowerApps #Search #SharePoint #Delegation

Table of Contents:
00:00 - Introduction to PowerApps Search Vs Filter using Starts With in SharePoint Lists
00:44 - Scenario: Power Apps & SharePoint
01:30 - Create a Search Box in Canvas Power Apps
02:05- What is delegation in Power Apps? Delegation warning limit 500 or 2000 rows
02:36 - Why handling delegation in Power Apps is important?
02:56 - Is Power Apps Search function delegable with SharePoint?
03:53 - Power Apps Search vs Filter using StartsWith function
04:35 - PowerApps Search in SharePoint Choice Column
08:03 - Reset PowerApps search text box
08:43 - Show Search text for on demand Power Apps searching scenarios
09:05 - Search in SharePoint Lookup type column
10:57 - Search in SharePoint Person type column (Search using Office 365 Users)
13:40 - Clear search on Power Apps screen visible
14:13 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[mspowerassist]

As usual - simple, clear and insightful. Thank you @RezaDorrani

[NKBobcat]

This is great! I have customers that do not like the multiple filter scenario and this simplifies the screen. Thank you again Reza!

[atehaa]

Non-Delegable functions are pain in the *** in PP.

Your solution is a really good workaround.

Also, i noticed that i had a wrong idea about how filter function works.

Thanks again Reza :)

[ravisuryawanshi]

I really appreciate your efforts Reza, Everytime I watch videos I learn something new, the way you teach is also very clear and simple to learn 😊,

[AshutoshDubeyCivil]

Nicely done... A much more precise searching rather than the old video... But the old one helps in understanding delegations in depth.. was very helpful.. Great..!
AD

[yohannesteklu]

Mr. Reza, Again, Thank you very much for this amazing video. This solution was among my major priorities.

[SauloOliveira]

Excellent query strategy, thanks Reza. For some reason I remembered the queries I made in CAML, where I only added the parameter to the main query if it was filled in.

[akshaynm]

Thanks a Lot Reza for Making this video...! Actually, after seeing your earlier video on Search Functionality on Dataverse, I was about to request you to please create a similar video on SP Data Source as well. But today I got that. :) Thanks again...!!

[oluwatobipaul]

Thanks for this refresher video between search and In function. Thanks Reza

[kv]

Very Useful one and the explained trick is very helpful 😀

[CemeteryLarry]

Awesome! Also, that thumbnail is fire!

[Cybermatik]

Thanks for sharing this awesome manipulation. Waiting for Microsoft to simplify delegation and/or search features for Power Apps gallery. By then i could use your tips for choices/person/lookup columns ;)

[akiibenji]

Hi R. I was looking for something like this. Thank you soo much🎉

[AakashDhawanKash]

Thanks a lot.. .amazing idea.. cant wait to implement this..

[isaiaguillon]

This is Raza, great information! Thank you so much for sharing, is there a way to search in the entire Title (not just the first words) with no delegation?

Thanks

[venkatvarun]

Awesome Reza. Can I get this project for my future work.

[paulstrickberger]

Great Video! I'm sure this is very simple, but can you show quickly how to Search within a text field? Also can this be adapted for multi select people pickers and choice fields? Thank you so much Reza!

[anuradhakrishnamoorthy]

Thank you so much @Reza, for all your tutorials. You are awesome and help me so much at my work. I was trying to implement the same as in the video for one of my use cases. I encountered this issue when the choices column had similar data like 1. Hello world 2. Hello Universe 3. Hello Team. My lookup on the choices only return 1 item and when searched with text Hello, doesn't give proper result. Any idea on how to fix this???

[ShyamSundar-xurx]

This very useful for me. Thanks very much for the detailed video. I have applied for many fields. Any Idea how to search if 'Assigned To' is multi select? Also, I could not control the filter data refresh, before clicking on search button. I tried to set the delayoutput to true. thanks

[vinnu_yt]

This is great 👍 Reza.
can you explain how to switch camera control in mobile