Answered

Gallery to only showing results that match the search

(0) Share

Report

Posted on by BenGillard

Hi,

I currently have a search Function that works well with my data.

However i would like to add another function if possible where the gallery is empty until the search criteria is met. As currently it shows all results to start with and then filters the list down when you begin searching.

I currently have this:

SortByColumns(Search(AllResources,SearchMain.Text,"KeyWords","Title","Description"),"{Name}",Ascending)

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

OneThing 393 on at

Like (1)

Report
Copy link

Link copied!
Hi @BenGillard

You can use the IsBlank Function to deal with this.
Basically:
If(!IsBlank(TextSearchBox.Text),Query)
This will check if the text searchbox is not blank, Search with the results if it has a value, else it will do nothing.

Full code should be something along these lines.
If(!IsBlank(SearchMain.Text), SortByColumns(Search(AllResources,SearchMain.Text,"KeyWords","Title","Description"),"{Name}",Ascending) )

Thanks,
Nicky

Was this reply helpful? Yes No
BenGillard on at

Like (0)

Report
Copy link

Link copied!

Just for my own sanity! When i copy and paste yours it works great so thankyou very much.

However when i tried to edit mine as shown below it doesnt work:
If(!IsBlank(SearchMain.Text),SortByColumns(Search(AllResources,SearchMain.Text,"KeyWords","Title","Description","{Name}",Ascending)

If you could tell me what i am doing wrong in the above so i know for next time that would be great.

Also what does the function of the ! do infront of IsBlank as thta doesnt seem to be part of the IsBlank forumula.

Thanks in advance

Was this reply helpful? Yes No
Sofie_D 260 on at

Like (2)

Report
Copy link

Link copied!

the '!' means 'Not'. So '!IsBlank(SearchMain.Text)' returns true if searchmain.text is not blank.

About your formula, you need another ')' at the end.

Was this reply helpful? Yes No
BenGillard on at

Like (1)

Report
Copy link

Link copied!

Sorry, I discovered i was missing a ) after "Description".

If(!IsBlank(SearchMain.Text),SortByColumns(Search(AllResources,SearchMain.Text,"KeyWords","Title","Description"),"{Name}",Ascending)

Thanks ofr your help. If anyone could let me know about the ! infront of IsBlank that would be greatly appreicate.

Apologies i am still very new to this 🙂

Was this reply helpful? Yes No
BenGillard on at

Like (0)

Report
Copy link

Link copied!

Great thanks

Was this reply helpful? Yes No
OneThing 393 on at

Like (0)

Report
Copy link

Link copied!
Hi @BenGillard,

@Sofie_D mentioned before that ! is a quick way to do the Not function, but you might have missed it.

You can also do it this way if you prefer:
If(Not(IsBlank(TextSearchBox.Text)),Query)
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-logicals contains more information on Not, And and Or

Thanks,
Nicky

Was this reply helpful? Yes No