Search Text Input

(0) Share

Report

Posted on by PriscillaB

Can you filter a Galley via text search input by multiple columns?

I have a gallery that has data from 3 columns I want to search Community, Marker ID, Damage Observed.

Current code: Filter('Maintenance Issues',StartsWith(Community,TextSearchBox1_1.Text))

This searches the Community column successfully, but I also would like to search by Damage Observed. Can anyone provide me the modified code? Or is there a simple way to text input search all data?

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@PriscillaB - assuming you want to search multiple columns from the same Text Input control, you can use the non-delegable Search function:

Search( 'Maintenance Issues', TextSearchBox1_1.Text, "Community", "DamageObserved", "MarkerID" )

For a delegable search, use separate Text Input controls with the StartsWith function:

Filter( 'Maintenance Issues', Len(TextSearchBox1_1.Text) = 0 || StartsWith( Community, TextSearchBox1_1.Text ), Len(TextSearchBox1_2.Text) = 0 || StartsWith( 'Marker ID', TextSearchBox1_2.Text ), Len(TextSearchBox1_3.Text) = 0 || StartsWith( 'Damage Observed', TextSearchBox1_3.Text ) )
PriscillaB 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I'd like it to be a delegable search, and I'd like to avoid multiple text input searches
PriscillaB 52 on at

Like
a
(0)

Report
Copy link

Link copied!

If I use the code provide on one search text box, and do a search the gallery filters to empty
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@PriscillaB - assuming your data source is SharePoint, you can also use:

Filter( 'Maintenance Issues', Len(TextSearchBox1_1.Text) = 0 || StartsWith( Community, TextSearchBox1_1.Text ) || StartsWith( 'Marker ID', TextSearchBox1_1.Text ) || StartsWith( 'Damage Observed', TextSearchBox1_1.Text ) )
PriscillaB 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Using this code, leaves only 1 result in the gallery before even doing a search

Here is a screenshot of the fully populated gallery & one showcasing search result with just searching "Community"
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriscillaB please confirm the data types for your search fields (Single Line Text, Single Choice, Date, Multi-Select Choice, Number etc)
PriscillaB 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you referring the data type of the Columns?
Community - Single Line
Damage Observed -Multi Line
Marker - Look up (this search isn't as important)
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriscillaB - single line text columns which allow multiple lines of text, and complex column types such as LookUp columns are not delegable column types.
PriscillaB 52 on at

Like
a
(0)

Report
Copy link

Link copied!

So I am not able to search the Damage Observed Column?

I don't recall the code that I had in previously, but I was in fact able to search any word contained with the Damage Observed field and it would filter the list
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriscillaB - you can certainly search on that column using the StartsWith function, but you will only be able to search on the first 500 (maximum of 2000) rows in your data source.

I have just run the suggested code in my environment and the Gallery is correctly populating. Could you share screenshot of the code you have in the Items property in your Gallery?