Unanswered

Gallery shows as blank until combo box choice has been selected.

(0) Share

Report

Posted on by Jv1605

Hi everyone, I have the following code, which works, but the gallery shows as blank until a choice in Combobox1 is selected.

I want the gallery to show all items until a filter is selected.

Can anyone suggest a solution?

Search(
 If(
 !IsEmpty(ComboBox1.SelectedItems) Or !IsBlank(ComboBox1.SelectedItems),
 Filter(
 'LAD Stakeholder List',
 Stakeholder_x0020_Group.Value = Dropdown1_1.Selected.Value Or Dropdown1_1.Selected.Value = "All",
 Concat(ComboBox1.SelectedItems,Value) in Concat(ProjectPhases,Value)

 ),
 'LAD Stakeholder List'
 ),
 TextSearchBox1.Text,
 "Title",
 "Project_x0020_Lead_x0020_Name"
)

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jv1605 ,

You would need to check if combox is empty or blank.

Check https://youtu.be/5dSk5iOgT68

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Jv1605 14 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Reza,

Thanks for your help! your youtube videos have been a massive help so far, I've actually watched quite a few and didn't realise you were active on here 😊. I've changed the code as suggested in your video, but it still only shows all items in the gallery when an choice in the combobox has been selected.

Any idea where I'm going wrong?
Search( Filter( 'LAD Stakeholder List', !IsEmpty(ComboBox1.SelectedItems) || !IsBlank(ComboBox1.SelectedItems) || Stakeholder_x0020_Group.Value = Dropdown1_1.Selected.Value || Dropdown1_1.Selected.Value = "All", Concat(ComboBox1.SelectedItems,Value) in Concat(ProjectPhases,Value) ), TextSearchBox1.Text, "Title", "Project_x0020_Lead_x0020_Name"