Cascading Drop-down option

(0) Share

Report

Posted on by freshyshreya

675

Hi,

I am trying to create cascading drop-downs as shown in the below pic.

Note:

1 is a combo-box selection.The user can select any one of the option here.

2 is a drop-down selection.The values related to whatever user has selected in 1 appears.

3 is a Data Table.It displays the values related to what the user selects in 2 finally.

Please provide help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @freshyshreya ,

Please try to update the code according to your datasource and column values.

DropDown: Items Filter(DataSource,YourColumnName=ComboBox.Selected.YourrequiredValue) DateTable: Filter(DataSource,YourColumnName = DropDown.Selected.YourrequiredValue)

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.

Was this reply helpful? Yes No
freshyshreya 675 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik ,

Thanks for your solution.I implemented the logic the only thing where I am getting warning(highlighted) is shown in the pic below:
Though there is a warning,I am able to run the forms properly,how shall I go about it?

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @freshyshreya ,

There is a type mismatch would you hover and check the type OpportunityID ?
I think if it is number type please try updating the formula as mentioned below.

Filter(DTA_Portal,'Opportunity ID' = Value(Dropdown1.Selected.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.

Was this reply helpful? Yes No
freshyshreya 675 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik ,

This works.Thanks for the solution!

Was this reply helpful? Yes No