Filtering issues

(0) Share

Report

Posted on by Caleb62881177

789

Hello Everyone,

I am trying to get a Switch expression where if you select Value1 in ComboBox1 then in ComboBox2 you have Option1 to Option3 to choose from. I am using the comboBoxes in a Form and I have Dataverse as my data source.

I am using this Switch formula, but it's not working.

Example:

If you choose Value1 on ComboBox1 then on ComboBox2 you have the choices of 1000, 2000, 3000.

If you choose Value2 on ComboBox1 then on ComboBox2 you have the choices of 1000, 2000.

Switch(
    DataCardValue.Selected.Name,
    "Value",
    Filter(
        Choices('Table Values'),
        Value <> "1000" && Value <> "2000"
    ),
    "Value",
    Filter(
        Choices('Table Values'),
        Value <> "3000" && Text(Value) <> "4000"
    ),
    Choices('Table Values')
)

If anyone has any idea how to accomplish the solution my problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

ankit_singhal 624 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please check the link below.
https://www.enjoysharepoint.com/power-apps-dropdown-filter/#Power_Apps_dropdown_filter_another_dropdown

Note: Please mark verified, if it is useful for you

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can u try this:

Switch( ComboBox1.Selected.Value, "Value1", Filter( Choices('Table Values'), Value in ["1000", "2000", "3000"] ), "Value2", Filter( Choices('Table Values'), Value in ["1000", "2000"] ), Choices('Table Values') )

please mark as verified answer if it helped

cheers

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ankit_singhal

I read through the article, but I doesn't help with my current issue.

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mmbr1606,

Your formula works, but I am getting an error of "Table doesn't contain any column of text type".

I have use this expression below before where I don't get the error, but the ecxpression still doesn't work.

Switch( ComboBox1.Selected.Value, "Value1", Filter( Choices('Table Values'), Text(Value) in ["1000", "2000", "3000"] ), "Value2", Filter( Choices('Table Values'), Text(Value) in ["1000", "2000"] ), Choices('Table Values') )

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey

Can u try this:

Switch(

ComboBox1.Selected.Value,

"Value1",

Filter(

Choices('Table Values'),

Text(Value) in ["1000", "2000", "3000"] // Convert the values to text for comparison

),

"Value2",

Filter(

Choices('Table Values'),

Text(Value) in ["1000", "2000"]

),

Choices('Table Values') // Default case if no match

)

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606,

Your expression works, but I am getting an error of "Table doesn't contain any column of text type."

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What Kind of column types do you have?

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606, Sorry for responding now.

figured out what I did wrong. I was suppose to use a lookup and filter via that.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey

was the code right and only the colum tyoe in your datasource wrong?

please dont forget to mark an nswer as verified, so we also can help others.

if non of the provided answers solved the issue, please post how you solved it and mark that as answer.

thanks in advance

Was this reply helpful? Yes No