Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter gallery with dropdown boxes using collections

(0) ShareShare
ReportReport
Posted on by 158

Hello,

 

I have 3 dropdown boxes that are filtering my gallery. Each of dropdown box is using collection of elements from the gallery (data source is excel). I could filter through All parts and distinct parts on 1st one, all months and distinct months on 2nd one and on 3rd one I wanted to filter through: All, value above 50 and value below 50. How do I do that, please? 

This is my code on screen: (OnVisible)

ClearCollect(colPartNumberP, {Result:"All"}, Distinct(Table5, 'PART NUMBER'));
ClearCollect(colMonthP, {Result:"All"}, Distinct(Table5, month));
ClearCollect(colValueP, {Result:"All"}, {Result:"Above £50"}, {Result:"Below £50"})

 

This is my code on dropdown boxes: 

colPartNumberP

colMonthP

colValueP

 

This is my code on gallery: 

If(
Dropdown_Part_P.Selected.Result = "All" && Dropdown_Month_P.Selected.Result = "All" && Dropdown_Value_P.Selected.Result = "All",
Table5,
If(
Dropdown_Part_P.Selected.Result <> "All" && Dropdown_Month_P.Selected.Result = "All" && Dropdown_Value_P.Selected.Result = "All",
Filter( Table5, 'PART NUMBER' = Dropdown_Part_P.Selected.Result ),
If(
Dropdown_Part_P.Selected.Result <> "All" && Dropdown_Month_P.Selected.Result <> "All" && Dropdown_Value_P.Selected.Result = "All",
Filter( Table5, 'PART NUMBER' = Dropdown_Part_P.Selected.Result && month = Dropdown_Month_P.Selected.Result),
Filter( Table5, month = Dropdown_Month_P.Selected.Result )
)
)
)

 

All collections are working fine except of collection for value as nothing is assigned to these and in gallery I have not included them as I am not sure how to filter them.

 

Regards 

Categories:
  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: Filter gallery with dropdown boxes using collections

    You're genius! 😄 Thanks!

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    Re: Filter gallery with dropdown boxes using collections

    @marcy_pi ,

    I cannot test it but it should work - I was trying to keep it Delegable with that structure. There is a "long way" that will work, but the top filter needs to return less than your Delegation limit to get the full results

    With(
     {
     wList:
     Filter(
     Table5,
     (
     Dropdown_Part_P.Selected.Result = "All" ||
     'PART NUMBER' = Dropdown_Part_P.Selected.Result
     ) &&
     ( 
     Dropdown_Month_P.Selected.Result = "All" ||
     month = Dropdown_Month_P.Selected.Result
     ) 
     )
     },
     If(
     Dropdown_Value_P.Selected.Result = "All",
     wList,
     Filter(
     wList,
     If(
     Dropdown_Value_P.Selected.Result = "Above £50",
     ValueField >= 50,
     ValueField < 50 
     )
     )
     )
    ) 

     

    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.

    Visit my blog Practical Power Apps

  • MP-13011217-0 Profile Picture
    MP-13011217-0 158 on at
    Re: Filter gallery with dropdown boxes using collections

    Thank You,

     

    It is working for option "All" and for "Below £50" but when I press on "Above £50" it is showing me all records not only above the value. Do You know why?

  • WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    Re: Filter gallery with dropdown boxes using collections

    Hi @marcy_pi ,

    You asked this question in part on another post - try this

    Filter(
     Table5,
     (
     Dropdown_Part_P.Selected.Result = "All" ||
     'PART NUMBER' = Dropdown_Part_P.Selected.Result
     ) &&
     ( 
     Dropdown_Month_P.Selected.Result = "All" ||
     month = Dropdown_Month_P.Selected.Result
     ) &&
     (
     Dropdown_Value_P.Selected.Result = "All" ||
     (
     (
     Dropdown_Value_P.Selected.Result = "Above £50" && 
     ValueField >= 50
     ) ||
     ValueField < 50 
     )
     )
    ) 

     

    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.

    Visit my blog Practical Power Apps

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard