web

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

News and Announcements icon

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

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:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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!
Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

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

Kind regards,
Nandit

Join the conversation