Power Apps Search Function
Updated: May 21, 2021
An introduction to the Power Apps Search function and how to use it to create a search box. Lots of good little details to get you off and running with the Search function.
In this video you will learn about:
The Search function
The ShowColumns function
Link to the video on YouTube: Power Apps Search Function
Link to the video for Curated Library subscribers: Power Apps Search Function
1:06 Create the solution in Power Apps and insert a gallery to build the search box
The search box is composed of a gallery and a text input. The Search function is added to the gallery to reference what users type in the text input against the Employee Details
4:54 Nuances of the Search function
The search box uses text and performs a case insensitive search. Multiple columns can be searched at once.
6:36 Explanation of what the blue circles mean and an overview of delegation
The blue circles appear within the app due to delegation. The SharePoint data connection does not fully support the Search function, and instead Power Apps only returns 500 items at a time.
9:36 Explanation of what the Search function returns
The Search function returns a table, and not text.
10:21 Utilize the Search function and ShowColumns function with a Drop down control
The ShowColumns function is needed in addition to the Search function when working with a Drop down control.
12:10 Troubleshooting error messages
The blue wavy lines only appears on the first item.
14:43 Demo of an app from a SharePoint list & how to fix it
The Filter function must be modified in order for the search functionality to work with the SharePoint list.
Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library.