Power Apps Search Vs StartsWith in SharePoint Lists
Power Apps
Jun 19, 2023 7:00 PM

Power Apps Search Vs StartsWith in SharePoint Lists

by HubSite 365 about Reza Dorrani

Principal Program Manager at Microsoft Power CAT Team | Power Platform Content Creator

External YouTube Channel
Citizen Developer

Power AppsPower SelectionLearning Selection

Delegable Function Selection for Search - In this Power Apps tutorial video, we will delve into the topic of efficiently searching

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
 
Power Apps supports a concept called "delegation" that optimizes how the app works with large data sources. Delegable functions, or delegable queries, are operations that can be performed on the data source side rather than pulling the entire data into the app for processing.
The advantage of delegable functions is that they allow Power Apps to work with very large data sources. This is because these functions can be processed directly on the server, meaning only the relevant data is sent back to the app, not the entire data source.
 
  • An example of delegable functions in Power Apps might include:
  • Comparison operations like "=" and "<>"
  • Arithmetic operations like "+" and "-"
  • Text functions like "Upper" and "Trim"
However, it's important to note that not all functions and data sources support delegation, and there might be delegation limits as well. This can restrict how much data can be processed by the server at a time.
 

Efficiently Searching in SharePoint Lists Using Power Apps

When using Power Apps to search through SharePoint lists, it's essential to choose the right delegable functions that allow for optimal performance, even with large data sources exceeding the standard delegable limits. By building a powerful search box experience and understanding the capabilities of Search, StartsWith, and IN functions, you can create efficient and comprehensive searches across multiple SharePoint columns. Utilize delegation strategies and the PowerApps Delegation Playlist to maximize the functionality and user experience of your Power Apps searches.

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

In this Power Apps tutorial video, we will explore the different methods for efficiently searching through large amounts of data within SharePoint lists. We will look at the PowerApps Search function, along with StartsWith and IN functions, to determine the optimal approach for searching data that exceeds the delegable limits of 500 or 2000 items. We will build a Power Apps search box experience to filter our SharePoint list data and discuss the importance of delegation when dealing with large data sources. We will create a single search box experience that searches across multiple SharePoint columns, such as Text, Lookup, Choice, and Person. In addition, we will discuss how to use the Search, StartsWith, and IN functions in Power Apps and how to search on multiple SharePoint columns. Finally, we will look at how to search in Text, Choice, Lookup, and Person type columns in SharePoint Lists.

 

More links on about Power Apps Search Vs StartsWith in SharePoint Lists | Delegable Function Selection for Search

23 Power Apps Filter Function Examples For SharePoint
Mar 26, 2023 — The Power Apps Filter function checks a table for any records matching a set of logical criteria. Then it extracts the results into a new ...

Keywords

PowerApps, StartsWith, IN, Filter, Delegable, Search Box