Power Apps Search Function Tutorial

Power Apps Search Function Tutorial

Power Apps provides powerful functionality for building dynamic applications with custom search capabilities. One of the key features for making your apps more interactive and user-friendly is the Search function.

With it, users can filter records based on partial matches or specific keywords, enabling them to quickly locate relevant data.

In this blog, we’ll explore how to use the Search function in Power Apps, showcasing practical examples to help you understand its syntax and functionality.

What is the Search Function?

The Search function in Power Apps is useful for filtering records based on partial matches or keywords. The function runs against a Table type and filters to specific records which can then be used in your application.

Syntax of the Search Function

The syntax of the Search function is as follows:

• Search(Table, SearchString, Column1 [, Column2, …])
• Table: The data source where the records will be searched.
• SearchString: The string to search for within the specified columns, if this is empty then all records are returned.
• Columns: The columns to search against, requires at least one column to be provided.

• How to Use the Search Function

  For our examples using the search function, we will be working off this sample data set:

Example 1: Basic Usage

If you have a table named Employees and you want to find records where the Name contains the value “Smith”, run this function:

Formula:

Search(Employees, “Smith”, “Name”)
Output:

Example 2: Searching Multiple Columns

You can also search within multiple columns. For example, to find records where the Position or Department contains the string “IT” as a partial or full match:

Formula:

Search(Employees, “IT”, “Position”, “Department”)
Output:

Practical Applications

Some use cases for the Search function are:

Dynamic Search Bars: Implement search bars that filter data in real-time based on user input.

Data Filtering: Quickly filter large datasets to find relevant records.

User-Friendly Interfaces: Enhance user experience by allowing partial matches and keyword searches.

Tips for Using Search Function

Performance: As the Search function evaluates each record, this can be a expensive function to use with large datasets.

Delegation: Understand delegation limits of your data and how this may impact behavior of your system when using the search function. Use the inbuilt tooling to help identify these issues when they arise.

Trusted by Leading Brands

“We work with organisations across many sectors of different shapes and sizes from 10 to 100,000 employees.”

Contact Form

Contact our team today!