cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamEll
Level: Powered On

Filtering gallery by multiple selected items in combobox

Hi all,

 

I am currently trying to filter my gallery based on data in a SharePoint list. The column I want to filter by is a multiple select choices column. My current code is: 

If(!IsEmpty(ComboBox.SelectedItems),Filter('Sharepoint List',ComboBox.Selected.Value in Topics.Value),'Sharepoint list')

 

Currently this filters the gallery by SelectedTopic1 and SelectedTopic2 and SelectedTopic1&SelectedTopic 2, but I only want to see results for SelectedTopic1&SelectedTopic2 - is there any way to do this? I've tried ComboBox.SelectedItems / ComboBox.SelectedItems.Value in Topics.Value but I get an error saying "Cannot use Table values in this context"

 

Thanks in advance for any advice

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Filtering gallery by multiple selected items in combobox

Hi @SamEll 

 

If you want to implement thsi with delegation

https://www.youtube.com/watch?v=44j2VRbdWjk

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: Filtering gallery by multiple selected items in combobox

Hi @SamEll 

 

If you want to implement thsi with delegation

https://www.youtube.com/watch?v=44j2VRbdWjk

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

SamEll
Level: Powered On

Re: Filtering gallery by multiple selected items in combobox

Thank you for this!

Highlighted
PedroPereira
Level: Powered On

Re: Filtering gallery by multiple selected items in combobox

Hello,

 

I am using your method and grouping all the items. However if I want to reset the combobox the Gallery«s items just disappear and then I need to select any of the combobox choices and then unselected it/them to make the Gallery display all values. Do you have any idea why this happens?

 

To unselect the values from the combobox should be the same effect as the function of reset the combobox, however with this method it has different outputs and I still haven't figured out why.

 

Thanks in advance.

 

Regards,

Pedro Pereira

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,998)