cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CameronTCD
Helper II
Helper II

Filtering a Gallery by Combo box

Hello, 

 

I've browsed many many forums looking for a solution but I'm yet to find one.

I look to filter a gallery using the results from a combo box.

 

I'm having two issues however. 

 

  1. I'm searching a SharePoint list column based on 'Office'. 

    This means that I have multiple iterations of the same value, I would like to filter this by unique values.

  2. I can't seem to actually find the correct code to filter the gallery using the combo box.

 

Help would be much appreciated.

 

Regards,

CameronTCD

21 REPLIES 21
Pstork1
Dual Super User III
Dual Super User III

Filtering by multiple selections at a time gets a lot more complex.  Now you'll have to pull the selected offices into a local collection and do a Search (rather than a Filter) to see if a record is 'in' the collection.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@mdevaney 

 

Thanks.

 

One more thing. I'm still yet to bring distinct/unique values to the combo box. It's a single-text column as originally thought.

 

Regards,

CameronTCD

mdevaney
Super User III
Super User III

@CameronTCD 

FYI, you can make more than one post the solution if you wish.  I think @Pstork1 deserves credit for at least 50% of the problem solving here Cat Happy

 

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Filtering-a-Gallery-by-Combo-box/m-p...

@CameronTCD 

Did you try the suggestion of @Pstork1 and myself to see what shows in the auto-complete for the ComboBox Items property?  A video or screenshot would be excellent.

@mdevaney 

 

Video of the items property & returned distinct values:

https://www.dropbox.com/s/x2b0przpiwoojy6/Ax8DopvF1V.mp4?dl=0

@CameronTCD 

 Actually, I was hoping you could show me what happens when you type up to this point in the function and see what the automcomplete suggests

 

Distinct('Apprentice List','Base Office'.

@mdevaney 

 

Ah apologies, I see. 

Attached video: https://www.dropbox.com/s/qs7dsp8tenmahju/45uhGgpTww.mp4?dl=0

 

Regards,

CameronTCD

@CameronTCD 

Wierd.  I must admit I am a little confused why its not working now.

No worries. 

I've just created a collection in my combo box as earlier suggested.

 

If you could help me with one last thing that would be golden!

Currently if no items are selected, the gallery returns blank. Do you know a fix to this?

 

Many thanks @mdevaney , @mdevaney  for all of your help til this point.

 

@CameronTCD 

You could do something like this.  If IsBlank does not work try IsEmpty.

 

If(
    IsBlank(ComboBox.Selected.Value),
    your_code_to_filter_combobox_here )
    

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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