Filter Gallery by Dropdown

[CodyO]

Hey friends,
I am filtering a gallery by dropdowns. The code isn't showing any errors, however nothing is showing in the gallery. I can confirm that the needed info is there, why won't it show up?
The three dropdowns are -

1 - Employee Name

Distinct(TimeTracker, Title)

2 - Job Number

Distinct(TimeTracker, JobNumber)

3 - Date

Distinct(TimeTracker, UpdatedActivityDateTime)

Filter(
    TimeTracker,
    Title = Dropdown4.Selected.Value,
    UpdatedActivityDateTime = Dropdown4_1.Selected.Value,
    JobNumber = Dropdown4_3.Selected.Value
)

 Any ideas? TIA 

[ANB]

Hi @CodyO , Try this:

Filter(
    TimeTracker,
    Title = Dropdown4.Selected.Value || IsBlank(Dropdown4.Selected.Value) || IsEmpty(Dropdown4.Selected.Value),
    UpdatedActivityDateTime = Dropdown4_1.Selected.Value || IsBlank(Dropdown4_1.Selected.Value) || IsEmpty(Dropdown4_1.Selected.Value),
    JobNumber = Dropdown4_3.Selected.Value || IsBlank(Dropdown4_3.Selected.Value) || IsEmpty(Dropdown4_3.Selected.Value)
)

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

[IamnotBob]

Would this work?
   
Filter(

        TimeTracker ,

        And(

            Or(

                IsBlank(Dropdown4.Selected.Value),

                Title = Dropdown4.Selected.Value

            ),

            Or(

                IsBlank(Dropdown4_1.Selected.Value),

                UpdatedActivityDateTime = Dropdown4_1.Selected.Value

            ),

            Or(

                IsBlank(Dropdown4_3.Selected.Value),

                JobNumber = Dropdown4_3.Selected.Value

            )     

        )

    )

[CodyO]

Hey @ANB Thank you for the quick reply! 
I get confused about the "type" part of powerapps. The code you provided is all showing as no errors with the exception of the "IsEmpty" parts. PowerApps says it wants a table and is receiving a record. Do you know of any good guides that help show how to make a record or text, into a table? 

[ANB]

Hi @CodyO I believe you are using dropdown not combo box then try this:

Filter(
    TimeTracker,
    Title = Dropdown4.Selected.Value || IsBlank(Dropdown4.Selected.Value),
    UpdatedActivityDateTime = Dropdown4_1.Selected.Value || IsBlank(Dropdown4_1.Selected.Value),
    JobNumber = Dropdown4_3.Selected.Value || IsBlank(Dropdown4_3.Selected.Value) 
)

https://www.matthewdevaney.com/power-apps-filter-gallery-with-multiple-dropdowns/

https://www.youtube.com/watch?v=Wr42PeW6_wU

https://www.youtube.com/watch?v=zxZGaXQlZqo

Basically, ifyou have combo box as control with multi select to true then IsEmpty function can be used.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

[IamnotBob · Accepted solution]

Shane Young and Reza Dorrani have good videos on this subject

[CodyO]

@ANB I am still not seeing anything in the gallery, I also tried changing the date from a dropdown to a date picker. What's weird is I have this almost identical on another page and it's working just fine! Maybe I need to start from scratch.

I am going to check out Shane Youngs video and see what he says and report back shortly what I learn! Thank you for the recommendation @IamnotBob 

[ANB · Accepted solution]

@CodyO I have added few links in my above response. Please check those.

Thanks,

ANB

[IamnotBob]

Shane is good and has several videos on this. I gleaned a lot from the videos. 

Reza's video that helped me: (18) Power Apps Sort and Filter on Multiple Columns - YouTube

I used the above code for my dropdowns and one text field. Works well. 

I am always open to better. Even to the point of using AddColumns() with Choice fields from DataVerse.

[CodyO]

@IamnotBob @ANB Weirdly enough, I followed a video from Shane Young (One of my favorite powerapp youtubers) and type the same code a second time, and it worked. I often have that experience when watching his videos! I think he might just be a wizard. It is working fully! Here is my code for anyone that might need it

Sort(
    Filter(
        TimeTracker,
        Title = Dropdown4_3.Selected.Value Or IsBlank(Dropdown4_3.Selected.Value),
        JobNumber = Dropdown4.Selected.Value Or IsBlank(Dropdown4.Selected.Value),
        UpdatedActivityDateTime = DatePicker2.SelectedDate Or IsBlank(DatePicker2.SelectedDate)
    ),
    JobNumber,
    SortOrder.Descending
)