cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OsmandFernando
Post Prodigy
Post Prodigy

Filter a gallery with multiple dropboxes

Hi, 

 

I have a Gallery and 3 drobboxes as follows, 

 

  1. Item
  2. Year
  3. Month

At the moment the behaviour is,

  • If the Item box is blank I see the entire collection
  • If I select and Item, then I need to select the year and month to see the Item and Total qty in the Gallery

What I want is, 

  • When the Item box is blank I should see all the items with total qty (like I have now)
  • Then Item, Year and month (above 2nd bullet) 
  • Also the I select the year I want to see the Items and Total qty for the selected year, then when I select the Year and Month I want to see the Items and total Qty for the selected year and month

 

Following is the current formula I have, 

 

If(IsBlank(ComboBox3.Selected),SumIssuesbyItemSpec,Filter(
SumIssuesbyItemSpec,
IsEmpty(ComboBox3.Selected)=true Or Itemspec = ComboBox3.Selected.'Item and Spec',
IsEmpty(ComboBox3_1.Selected)=true Or Issued_x0020_Month = ComboBox3_1.Selected.Value,
IsEmpty(ComboBox3_2.Selected)=true Or Text(Value(Issued_x0020_Year),"[$-en-US]###") = Text(ComboBox3_2.Selected.Value)))

 

Screenshot, 

 

Capture.JPG

 

Osmand

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

Hi @OsmandFernando 

Check out @Shanescows video https://www.youtube.com/watch?v=kLGglidmPxg .  It will show you how to do it.

View solution in original post

3 REPLIES 3
Drrickryp
Super User
Super User

Hi @OsmandFernando 

Check out @Shanescows video https://www.youtube.com/watch?v=kLGglidmPxg .  It will show you how to do it.

eka24
Super User
Super User

Try:

Filter(
SumIssuesbyItemSpec,
'Item and Spec'= ComboBox3_1.Selected Or

 Issued_x0020_Month = ComboBox3_2.Selected Or,
Issued_x0020_Year = ComboBox3_2.Selected)

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Thank you @Drrickryp  @eka24 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,140)