Answered

Filter choice column combobox

(0) Share

Report

Posted on by WalesMariner

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,779 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
WalesMariner 73 on at

Like (0)

Report
Copy link

Link copied!

That's brilliant thank you Warren!

Was this reply helpful? Yes No