web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Two combobox Nested fi...

Power Apps - Building Power Apps

Suggested answer

Two combobox Nested filter

(0) Share

Report

Report

Posted on by ernu

140

Hello all,

I have Dataverse table and there are two different columns in this table.

The type of these columns are "Choice" and I already defined the values in the dataverse table side.

Column values of LR:

- A, B C

Column values of LRx:

- 10, 20, 30, 40, 50

According to my scenario in Power Apps;

> When I select value "A" in the LR combobox, I want to see only value "10" in the LRx combobox.

> When I select value "B" in the LR combobox, I want to see only value "20" and "30" in the LRx combobox.

> When I select value "C" in the LR combobox, I want to see only value "40" and "50" in the LRx combobox.

I tried filter option but it didn't work. How can I handle that? Thanks.

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Two combobox Nested filter

Hi ernu,

For the kind of behaviour you are trying to achieve, it makes more sense to have the Dropdown control instead of a ComboBox control (at least for LR). If you still wish to use Combobox, update the SelectMultiple property of the first Combobox to false.

Here's how I did it:

Items property of the First Combobox:

Choices(DVTable.LR)

Items property of the Second Combobox:

Switch( ComboBox1.Selected.Value, 'LR (DVTable)'.A, Filter( Choices(DVTable.LRx), Value = 'LRx (DVTable)'.'10' ), 'LR (DVTable)'.B, Filter( Choices(DVTable.LRx), Value = 'LRx (DVTable)'.'20' || Value = 'LRx (DVTable)'.'30' ), 'LR (DVTable)'.C, Filter( Choices(DVTable.LRx), Value = 'LRx (DVTable)'.'40' || Value = 'LRx (DVTable)'.'50' ), Choices(DVTable.LRx) )

This is how it works (works the same way for both Classic and Modern Controls):

Classic Controls

Modern Controls

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report

Two combobox Nested filter

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit

Was this reply helpful? Yes No

Join the conversation