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:
https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

#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:
🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani