How to Search Multiple SharePoint List Fields in Power Apps
Question details
The user wants to configure a Power Apps application connected to a SharePoint list to search across multiple columns instead of being limited to only the first field.
- Product
- Microsoft Power Apps
- Device & OS
- not provided
- Scenario
- Modifying a Power Apps application created from a SharePoint list to improve search functionality across different field types.
- Observed behavior
- By default, the automatically generated app only searches the primary text field, ignoring other columns like Choice or Created By.
Ensure you have edit permissions for the Power Apps application and are familiar with the basic Power Fx formula syntax used in the gallery's Items property.
Modify the Search Formula in Power Apps Studio
Update the Gallery's Items property to include additional SharePoint column internal names in the search criteria.
The functionality to search multiple fields is configured directly within Power Apps using the Search() or Filter() functions, rather than in the standard SharePoint list settings. If you are querying basic text columns, expanding the Search() function is straightforward. However, for complex columns such as Choice or Created By, you may need to use advanced Filter() functions or seek guidance on formatting.
Navigate to the Power Apps portal, locate your app, and select 'Edit' to open it in Power Apps Studio.
Click on the Gallery control in the screen that displays your SharePoint list data.
In the property dropdown menu at the top left of the formula bar, ensure 'Items' is selected.
Modify the default formula to include additional column names. For example, change it to: Search(SharePointList, SearchInput.Text, "Title", "Field2", "Field3"). Make sure to use the exact internal names of your SharePoint columns.
If you are trying to search Choice, Lookup, or Person fields, the standard Search function may not work due to delegation limits. For advanced formulas, it is highly recommended to post your specific scenario in the Microsoft Power Apps Community forum.
Need a Lightweight Alternative for Document Management? Try WPS Office
While Power Apps is excellent for building custom front-ends for SharePoint lists, managing your daily documents, spreadsheets, and presentations is easier with a unified, lightweight office suite. WPS Office offers a completely free, highly compatible alternative to Microsoft Office for all your everyday workflow needs.
- 1. Download the WPS Office Installer: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the application: Run the downloaded installer and follow the quick on-screen instructions to set up the software.
- 3. Open your existing files: Launch WPS Office and directly open your Microsoft Office files without any format conversion required.
Frequently Asked Questions
Why does Power Apps only search the first field of my SharePoint list by default?
When you generate an app automatically from a SharePoint list, Power Apps creates a basic Search formula for the gallery's Items property that defaults to the primary text column (usually the 'Title' field). You must manually configure the formula to include other columns.
Can I search a Choice or Lookup column in Power Apps?
Yes, but the standard Search() function does not support complex SharePoint columns like Choice or Lookup directly. You will need to use the Filter() function combined with the 'in' operator, or add a calculated column to your collection to enable searching.
Where can I get advanced help for Power Apps formulas?
The Microsoft Power Apps Community is the best resource for troubleshooting complex Search and Filter formulas, especially when dealing with nested SharePoint lists, specific field types like 'Created By', or overcoming data delegation limits.
