Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter choice column combobox

Posted on by 73

Hi I'm trying to filter the options within a combobox based on whether the option contains the selected value of another combobox. So I have tried this but it does not return any value:

 

Filter(Choices([@'Register'].'Code'), DataCardValue7.Selected.Value in Choices([@'Register'].'Code'))

 

The intellisense does not show any issue in the formula but as I say the results bring back nothing. So for example if I were to choose Option 1 on the first combobox I would want to filter out only those choices that contained the text Option 1 etc.  

 

Any points appreciated!

Categories:
  • WalesMariner Profile Picture
    WalesMariner 73 on at
    Re: Filter choice column combobox

    That's brilliant thank you Warren!

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 143,532 on at
    Re: Filter choice column combobox

    Hi @WalesMariner ,

    Try this format

    Filter(
     Choices([@'Register'].'Code'), 
     DataCardValue7.Selected.Value in Value
    )

     

    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.

    MVP (Business Applications)   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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard