cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
maruthi216
Level: Powered On

Populating a value in drop down based on values from 2 other drop downs (Cascading)

Hello Experts,

I am new to powerapps, learning from your forum, thanks for your support.

I am developing an app similar to below.. but was struck with an error.

I have 4 Sharepoint Lists.

  1. PAMFR(Title/Manufacturer).
  2. PADEVICES(Manufacturer/Device).
  3. PAMODEL(Manufacturer/Device/Model).
  4. PA_ACCESS(Manufacturer/Access)

My Requirement: when I select Manufacturer in dropdown1, I should get the Device in dropdown2 and model in dropdown3 and access in dropdown4.

 

But I am getting the “error” as attached. Also I attached screenshots of my sharepoint lists.

Any help would be of a great help.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Populating a value in drop down based on values from 2 other drop downs (Cascading)

Hi @maruthi216 ,

Could you please share a bit more about the formula you typed within the Items property of the Dropdown1_1?

Could you please share a bit more about the data type of the "Manufacturer" column in your PADEVICES, PAMODEL and PA_ACCESS lists? Is it a Choice type column or a Single text type column?

 

Based on the issue that you mentioned, I think there is something wrong with it. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Dropdown1 to following:

Distinct(PAMFR, Manufacturer)

 

set the Items property of the Dropdown2 to following:

Filter(PADEVICES, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PADEVICES list is a Choice type column, please modify above formula as below:

Filter(PADEVICES, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PADEVICES list into  "Manufacturer", please modify above formula as below:

Filter(PADEVICES, Title = Dropdpown1.Selected.Result)

then set the Device column as Display column value within the Dropdown2.

 

set the Items property of the Dropdown3 to following:

Filter(PAMODEL, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PAMODEL list is a Choice type column, please modify above formula as below:

Filter(PAMODEL, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PAMODEL list into  "Manufacturer", please modify above formula as below:

Filter(PAMODEL, Title = Dropdpown1.Selected.Result)

then set the Model column as Display column value within the Dropdown3.

 

set the Items property of the Dropdown4 to following:

Filter(PA_ACCESS, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PA_ACCESS list is a Choice type column, please modify above formula as below:

Filter(PA_ACCESS, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PA_ACCESS list into  "Manufacturer", please modify above formula as below:

Filter(PA_ACCESS, Title = Dropdpown1.Selected.Result)

then set the Access column as Display column value within the Dropdown4.

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Populating a value in drop down based on values from 2 other drop downs (Cascading)

@maruthi216 

 

What are the column types in each list?

Community Support Team
Community Support Team

Re: Populating a value in drop down based on values from 2 other drop downs (Cascading)

Hi @maruthi216 ,

Could you please share a bit more about the formula you typed within the Items property of the Dropdown1_1?

Could you please share a bit more about the data type of the "Manufacturer" column in your PADEVICES, PAMODEL and PA_ACCESS lists? Is it a Choice type column or a Single text type column?

 

Based on the issue that you mentioned, I think there is something wrong with it. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Dropdown1 to following:

Distinct(PAMFR, Manufacturer)

 

set the Items property of the Dropdown2 to following:

Filter(PADEVICES, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PADEVICES list is a Choice type column, please modify above formula as below:

Filter(PADEVICES, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PADEVICES list into  "Manufacturer", please modify above formula as below:

Filter(PADEVICES, Title = Dropdpown1.Selected.Result)

then set the Device column as Display column value within the Dropdown2.

 

set the Items property of the Dropdown3 to following:

Filter(PAMODEL, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PAMODEL list is a Choice type column, please modify above formula as below:

Filter(PAMODEL, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PAMODEL list into  "Manufacturer", please modify above formula as below:

Filter(PAMODEL, Title = Dropdpown1.Selected.Result)

then set the Model column as Display column value within the Dropdown3.

 

set the Items property of the Dropdown4 to following:

Filter(PA_ACCESS, Manufacturer = Dropdpown1.Selected.Result)

if the "Manufacturer" column in your PA_ACCESS list is a Choice type column, please modify above formula as below:

Filter(PA_ACCESS, Manufacturer.Value= Dropdpown1.Selected.Result)

If you changed the Title column in your PA_ACCESS list into  "Manufacturer", please modify above formula as below:

Filter(PA_ACCESS, Title = Dropdpown1.Selected.Result)

then set the Access column as Display column value within the Dropdown4.

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

maruthi216
Level: Powered On

Re: Populating a value in drop down based on values from 2 other drop downs (Cascading)

Thanks Kris.

 

I was able to fix this issue by "Parent>>>child" relation ship.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 373 members 5,044 guests
Please welcome our newest community members: