Power Apps - Power Apps Experimental Features

Cascading dropdown menus

Like (2) Share

Report

Posted on 10 Apr 2025 05:39:18 by JK-27031040-0

Hello, am trying to create a cascading dropdown lists for Incidents categories and types.

I have created an online excel sheet and a table and linked it to the application - and have types the functions but am not able to see the values.

Table name: Table1

Category dropdown: Dropdown_cat

Type Dropdown: Dropdown_typ

screenshots as below.

All responses (13)

Answers (0)

Suggested answer

Inogic 983 Super User 2025 Season 1 on 18 Apr 2025 at 13:12:04

Like (0)

Report
Cascading dropdown menus

Hi,

When you use Distinct(Table1, Category) in Power Apps, it creates a one-column table in the background with a default column named Result, which contains all the unique values from the Category column in Table1.

For example, the output might look like: { Result: "Incidents" }, { Result: "Near Misses" }, { Result: "Opportunities for Improvement" }.

To display these values in a modern dropdown control (e.g., Dropdown_cat), set the Items property to Distinct(Table1, Category), and then set the Value property (available in the right-hand properties pane or directly via code) to Result.

This tells the dropdown to display the distinct category names from the Result column.

Note: In some modern controls, the column may be labeled as “Value” instead of “Result”, so use the appropriate name based on the control's behavior.

Hope, this helps.

Thanks!

Inogic
JK-27031040-0 12 on 17 Apr 2025 at 13:13:15

Like (0)

Report

Cascading dropdown menus

@Inogic, Thanks for the answer- the below in not clear to me, how to do that? and what do you mean by a result column?
Suggested answer

Inogic 983 Super User 2025 Season 1 on 17 Apr 2025 at 10:31:34

Like (0)

Report

Cascading dropdown menus

Hi,

To create cascading dropdowns using your online Excel table (Table1), follow these steps to ensure everything works correctly:

1) Set up the Category dropdown (Dropdown_cat)

                Items property: Distinct(Table1, Category)

                Note: Since Distinct() returns a column named Result, you need to set the Value property of the dropdown to: Result

2) Set up the Type dropdown (Dropdown_typ)

                Items property: Filter(Table1, Category = Dropdown_cat.Selected.Result)

                Value property: Type

                This filters the Type values based on the selected Category.

3) Make sure the Excel column headers are exactly Category and Type (case-sensitive, no extra spaces).

4) Check that your Excel file is properly connected as a data source in Power Apps.

5) Ensure you select a value in the Category dropdown first — Type dropdown depends on it.

6) Avoid using .Value with Dropdown_cat if you're using Distinct() — use .Selected.Result instead.

Hope this helps.

Thanks!

Inogic
stampcoin 1,300 on 16 Apr 2025 at 13:07:30

Like (0)

Report

Cascading dropdown menus

@JK-27031040-0 Hi,

I suggest that you delete the type dropdown, and add it back. .

your code looks ok ( I created one app similarly).

you can add a button load the data into a collection and test it.

Category dropdown.

Item DropDown.

Excel Table1,

You will be there.
w.p 4,218 on 16 Apr 2025 at 11:58:35

Like (0)

Report

Cascading dropdown menus

@JK-27031040-0

Can you click the red X, share the error message, or try removing and re-adding it?
JK-27031040-0 12 on 16 Apr 2025 at 10:34:58

Like (0)

Report

Cascading dropdown menus

@w.p, no worries - will you able to find the missing art from the below pictures? I don't see values
w.p 4,218 on 16 Apr 2025 at 08:41:02

Like (0)

Report

Cascading dropdown menus

@JK-27031040-0

Sorry, I prefer to communicate like this. Other members might be willing to have a Teams call.

When it's not in design mode, can you share screenshots of what happens when you select the dropdown?
JK-27031040-0 12 on 15 Apr 2025 at 19:56:25

Like (0)

Report

Cascading dropdown menus

@w.p, still I cannot see values - can we connect on teams please to sort this out please?
JK-27031040-0 12 on 14 Apr 2025 at 04:34:20

Like (0)

Report

Cascading dropdown menus

@ronaldwalcott Yes
ronaldwalcott 3,653 on 13 Apr 2025 at 19:17:10

Like (1)

Report

Cascading dropdown menus

Are you creating this in a SharePoint form?