Unanswered

Display empty gallery when text box has no value

(0) Share

Report

Posted on by sdnd2000

173

Hi, I have a gallery tied with textbox and am looking to display empty gallery, when the textbox is blank. I have the below formula, but it gives me error, please advise.

Filter(Search(Contacts,TextInput2.Text,"lastname"),!IsBlank(TextInput2.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @sdnd2000

With( {item: Contacts}, If( IsBlank(TextInput2.Text), Blank(), Search( item, TextInput2.Text, "lastname" ) ) )

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @sdnd2000

I have tested and correctly the above code. This is also similar.

With( {item: Contacts}, If( !IsBlank(TextInput2.Text), Search( item, TextInput2.Text, "lastname" ) ) )

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
sdnd2000 173 on at

Like (0)

Report

Hi, @StalinPonnusamy , thanks for the help, it doesn't work as expected, since there is only on result returned, is it limiting the number of result set?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @sdnd2000

Shouldn't be. Our requirement is
Gallery will be empty when no text on the Search
Gallery display based on search
Case #1

Case #2

Code
With( {item: IssueTracker}, If( !IsBlank(TextSearchBox1.Text), Search( item, TextSearchBox1.Text, "Title" ) ) )

Please share your data source if this not works

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Hi @StalinPonnusamy - potentially delegation issue with 'search'?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
It shouldn't be. I tested with Dataverse data as well

With( {item: [@Contacts]}, If( !IsBlank(TextSearchBox1.Text), Search( item, TextSearchBox1.Text, "lastname" ) ) )

Was this reply helpful? Yes No
sdnd2000 173 on at

Like (0)

Report
@StalinPonnusamy
I tested with the below code, and the result is different, not sure why,
Filter(Search(Contacts,Tx_SearchBx.Text,"lastname"),!IsBlank(Tx_SearchBx.Text))
And your code just returns one result,

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

That's really surprising. Both queries are the same and give the same results for me. That is expected.

Only the difference is no delegation issue when using With Statement.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

Hi,
In my case I have two text input fields(number type) in a form. When both text boxes has value the above Billability calculates the value. I have a requirement of when both text boxes is empty the formula should not calculate and should be blank like this( Billability : %). As of now when both text boxes is empty it displays in this way.( Billability : 0 %).
Any help would be greatly appreciated

Screenshot (17).png

Was this reply helpful? Yes No