Answered

Search for Multiple Criteria

(0) Share

Report

Posted on by SH-23070720-0

Hello,

I did try to word this once but I felt it was too confusing, so I will try a different way!

I have a Microsoft List, called Asset Manager. In my app, I have a gallery that filters based on a search. There are two columns in the Microsoft List I have that I want to connect to a search box. These are 'Asset Tag' and 'Room'.

I want the search box to filter for either a room or an individual asset tag.

For example, if I type in a room name, I want it to show me all of the assets connected to that room name in the gallery.

On the other hand, if I just wanted to find one individual asset, I could type that in and find it.

If there's nothing in the search box, I want all of the assets to show in the gallery.

Thank you in advance.

Categories:

Using Apps Using Formulas

General Questions

All responses (4)

Answers (1)

SH-23070720-0 on at

Like (0)

Report

Re: Search for Multiple Criteria

Brilliant @StalinPonnusamy,
It works flawlessly, thank you for your input!
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Re: Search for Multiple Criteria

Hi @HeronS98

Please verify the updated code above. I forgot to update on another place.
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Re: Search for Multiple Criteria

Hi @HeronS98

Please try this.

With({SourceItem:'Asset Manager'}, Sort( If( IsBlank(TextSearchBox1.Text), SourceItem, Search( SourceItem, TextSearchBox1.Text, "Location", "Title" ) ), "Title" ) )

Thanks,
Stalin - Learn To Illuminate
SH-23070720-0 on at

Like (0)

Report
Re: Search for Multiple Criteria

I believe I may have found a solution, but it also comes with a delegation warning. The application still works but claims it may not like large data sets with the code I have used

Sort( If( IsBlank(TextSearchBox1.Text), 'Asset Manager', Search( 'Asset Manager', TextSearchBox1.Text, "Location", "Title" ) ), "Title" )
Is there any way to remove the warning?