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

Good morning @mdevaney,

 

If(
    IsBlank(ComboBox2.Selected.Value),
    Filter('Apprentice List',StartsWith('Full name',TextInput1.Text)),
    Filter('Apprentice List','Base Office' in ComboBox2.SelectedItems,StartsWith('Full name',TextInput1.Text)))

Please see the compelted code above. 

Your solution has worked.

 

Thanks a million for your help.

 

Regards,

CameronTCD

@CameronTCD 

Victory!  Best of luck in building your app. Cat Happy

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,798)