cascading dropdown

(0) Share

Report

Posted on by BJ94

264

Hi All,

I have two dropdown and in 1st dropdown I have taken Order No., Status, and Material name. So on the basis of 1st dropdown in 2nd dropdown need to show the values. Like when selected 1st dropdown as status then in 2nd dropdown need to show approved, rejected, hold options.

How can we do this?

Please give suggestions.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report
To get an idea how this works, create the following then play around with it to get a better understanding of the formulas.

Make one Dropdown (Dropdown1 in this example), and set it's items to

[1,2,3,4,5,6,7,8,9,10]

Now create a 2nd dropdown (Dropdown2) and set it's items to

Switch( Dropdown1.Selected.Value, 1, ["A","B","C"], 2, ["D","E","F"], 3, ["G","H","I"], 4, ["J","K","L"], 5, ["M","N","O"], 6, ["P","Q","R"], 7, ["S","T","U"], 8, ["V","W","X"], 9, ["Y","Z","AA"], ["AB","AC","AD"] )

Now you have a working example of two dropdowns where the second chanegs based on the first

Was this reply helpful? Yes No
BJ94 264 on at

Like (0)

Report

Hi @TheRobRush
There is lot of data in second dropdown in order no. and materials.
Is there any other way to add data in second dropdown.

Thanks!

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

I do not understand what you are asking

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

What is the source of first dropdown, and where is data you want in second stored

Was this reply helpful? Yes No
BJ94 264 on at

Like (0)

Report

Hi @TheRobRush

This solution is not working.

Thanks!

Was this reply helpful? Yes No
BJ94 264 on at

Like (0)

Report

First dropdown data is column name from database and second dropdown data i.e Order no. (like 211025, 211045) is stored under column name(Order No.)

And order nos. are around to 2000 and all.
only status is like approved, rejected, on-going, hold.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

Will need to see the structure of both lists, because need to know what to reference that matches etc.

or is it all one splist

with first dropdown the column called name in this list

and the second dropdown should include every records order number value when the name column is the name on the dropdown 1

Was this reply helpful? Yes No
BJ94 264 on at

Like (0)

Report

Yes , column name is order number and which is first dropdown. And in second dropdown data saved in column - Order no., That we need display.,

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

Again, will need column info. Vheck your SharePoint list settings for each of these columns and let us know what types the columns are 🙂

Also, you typed column 1 is named order number and column 2 is named order no?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @BJ94,

Have you resolved your problem?

I understand what @TheRobRush is confused of😂, for us, any unresolved issue needs details as many as you could provide.

Anyway, I just want to confirm with you that if you populate the first dropdown with all the column names, and once you select one column, the second dropdown should display the corresponding values within?

If so, you should tell us how we could fetch each column values from your list, 'Order No.', Status, 'Material Name'... All these columns has different methods to fetch the value within based on their different column types.

If all of them are single-line-of-text, you should set the Items property of the second dropdown as below:

Switch( Dropdown1.Selected.Value, 'Order No.', List1.'Order No.', Status, List1.Status, 'Material Name', List1.'Material Name' )

If there is Choice type or other type, you should replace the List1.Status as Choices(List1.Status)

Was this reply helpful? Yes No