How to Use a Power Apps Search Formula to Find Text Anywhere
Question details
The user needs a way to search for a specific text string located anywhere within a field in Power Apps, as the default function only searches the beginning of the text.
- Product
- Microsoft Power Apps
- Device & OS
- not provided
- Scenario
- Filtering records in a gallery or data table based on user text input, aiming to match the query against any part of a specific column's data.
- Observed behavior
- The currently used StartsWith function restricts search results to records where the text only appears at the very beginning of the field.
Verify the exact internal name of the column you wish to search within your data source, as Power Apps formulas require the exact system column name rather than the display name.
Use the Search Function for Partial Text Matching
Replace the StartsWith function with the Search function to locate text anywhere within a specified column without the need for manual wildcards.
The Search function in Power Apps evaluates a string to see if it contains another string. Unlike StartsWith, which only looks at the beginning of a text field, Search will find your specified text regardless of its position in the column. Wildcards are inherently built into its behavior, meaning you do not need to manually add asterisks or special characters to your query.
In your Power Apps canvas app, click on the gallery or data table that you want to filter based on the search input.
Navigate to the formula bar for the 'Items' property of your selected control.
Replace your existing formula with the Search syntax. For example, enter: Search(CheckRelationA, SearchBox2.Text, "NameEmp").
Ensure that 'CheckRelationA' matches your actual data source name, 'SearchBox2.Text' matches the name of your text input control, and '"NameEmp"' is enclosed in quotes representing the exact column name you are searching.
Manage Your Exported App Data with WPS Office
While Power Apps handles application building and record filtering, you often need to analyze the underlying exported datasets. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for managing spreadsheets, analyzing databases, and creating offline reports.
- 1. Download and install: Get WPS Office for free from the official website and install it on your device.
- 2. Open exported data: Launch WPS Spreadsheets and open the .xlsx or .csv file exported from your Power Apps data source.
- 3. Analyze your records: Use built-in Find & Replace, AutoFilter, and advanced spreadsheet formulas to search and manage your dataset efficiently.
Frequently Asked Questions
Can I search multiple columns at once with the Search function?
Yes, you can search multiple columns simultaneously by adding more column names to the end of the formula. For example: Search(DataSource, TextInput.Text, "Column1", "Column2").
Do I need to use wildcard characters like asterisks (*) in Power Apps Search?
No, the Search function automatically acts as a 'contains' operator, matching the text string anywhere within the specified column without needing manual wildcard characters.
What is the difference between Filter and Search in Power Apps?
The Filter function is typically used for exact matches or evaluating specific logical conditions (like numbers and dates) and is usually delegable. The Search function is explicitly designed to find partial text matches within string columns.
Why does my Power Apps Search function show a blue or yellow warning line?
This indicates a delegation warning. It means the specific data source cannot process the Search function on the server side, so Power Apps will only search the records currently loaded into the app's local memory (typically limited to 500 - 2,000 records).
