web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Filter Gallery with combobox from SP Lists that have column with multiple choices available

(0) ShareShare
ReportReport
Posted on by 7

Hi everyone,

I'm sorry if my English isn't perfect i'm French and if there's any french helpers that would be awesome!

 

So, I made an inventory management app connected to a database which is a SP List from Microsoft Lists.
The aim of this app is for anybody in the company can check if theres a product in stock.
Im stuck..
I have a screen with 2 combo box and 1 gallery. The gallery needs to be filtered by the 2 combobox.
Each dropdown depends of 1 specific column of my SP list.
I have my 1st column called "Gamme" which is a multiple choice column, so for example when u create a new entry, u can select either "VR", "SE","SI" (basically multiple selection) .. or just select "VR" or just "SE"...

My second column is called "Categorie" and is a choice column with only 1 selection available.

 

When I filter my gallery with the 2 dropdown, I got an error which says me that it is impossible to compare these types "table","text"

 

I can't figure it out how to solve this, i tries so many options, searched on internet for hours and still stuck.

It's been weeks and im losing my mind rn, can  someone please save my life ? 😞

I have the same question (0)
  • Verified answer
    TheRobRush Profile Picture
    11,128 Moderator on at
    Re: Filter Gallery with combobox from SP Lists that have column with multiple choices available

    The structure for a MultiChoice SPColumn is {Value: Option 1 selected, Value: Option 2 Selected} etc because theres more than 1 item in it, it is a table. To filter by this it would be like

    Filter(Venues, "Upper Lot" in Area.Value)

    Where venues is my splist, upper lot is option I want to find, and Area is the multi choice column.

     

    Main issue with this is it will not be delegable, soif you go over 2000 records in your splist this will no longer be reliable. So far as I know there is no real permanent way around that

     

    Reza came up with a workaround if you need delegable version I haven't tested it but linked video for you

  • theteddybeard Profile Picture
    7 on at
    Re: Filter Gallery with combobox from SP Lists that have column with multiple choices available

    Absolutely faulous, it works like charm!

    Thanks a lot for your help I wish u the best 🙂

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 632 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 386 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 245 Moderator

Last 30 days Overall leaderboard