web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps When user selects noth...

Power Apps

Answered

When user selects nothing in a combobox the gallery should display all the records but it gets blank.

(0) Share

Report

Report

Posted on by codeworks

321

I am filtering my gallery based on combo box selection, but when user did not select anything, the gallery remains blank.

On my Combo Box List Item i have this formula

Distinct('Auc List',Manufacturer)

On my Gallery Items properties i have this formula

Filter('Auc List', Manufacturer = CboBrowse.Selected.Value)

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @codeworks

You can achieve this:

Filter( 'Auc List', Manufacturer = CboBrowse.Selected.Value || IsBlank(CboBrowse.Selected.Value) )

My example:

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
dukatz 165 on at

Like
a
(1)

Report
Copy link

Link copied!
Filter('Auc List',IsBlank(CboBrowse.Selected.Value) || Manufacturer = CboBrowse.Selected.Value)

Only Filter if a value is selected. Currently you're filtering for Manufacturer = Blank which results in zero matches
Yogesh Murugan 451 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this :
If(IsBlank(CboBrowse.Selected.Value), 'Auc List', Filter('Auc List',Manufacturer = CboBrowse.Selected.Value))

Join the conversation