Search Text In Powerapps
About the Author: Manish Luhana
Microsoft business applications specialist and certified trainer.
Categories: Power Apps, Power Platform0 CommentsPublished On: 1 December 2021


Through the PowerApps community, we came over several requests to search several columns in PowerApps with a single search query. In the example below, we are searching for Title and Description using a single search control.

Simply said, it is possible to search by numerous columns, as seen below.


BUT, as seen below, this blog searches a different column with a different keyword.


Test it.

  • Display a gallery on the screen.
  • Add a Search text control (Name : TextSearchBox)


  • Search by + Search term using Start With to narrow down the results.
  • To prevent delegation, use With Statement.
  • Set the gallery’s Items property to

With( {item: [@IssueTracker]}, Filter( item, StartsWith( Title, Last( FirstN( Split( TextSearchBox.Text, “+” ).Result, 1 ).Result ).Result ) || StartsWith( ‘Issue description’, Last( FirstN( Split( TextSearchBox.Text, “+” ).Result, 2 ).Result ).Result ) ) )

Property of Gallery Items (Screenshot) for easier referencing


the end result (Power keyword search the Title column and Support keyword search the Description Column)



We may search data sources in PowerApps utilising several columns with a single search box and various keywords.

tech mentor sidebanner
  • Continue reading
  • Continue reading
  • Continue reading
  • Continue reading
  • Continue reading

Leave A Comment