top of page

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

Key timestamps:

  • 0:00 Intro

  • 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.

Additional learning:

5,658 views0 comments


bottom of page