cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Child list populating cascading dropdown in parent list form - need the values from dropdown to feed to parent list

I have a child list I use for my cascading dropdown values in my parent list form.  I chose this way because the columns have duplicate values depending on your selections

question.PNG

I have my function setup as followed for the 3 dropdown fields (and it works great!)

  1. Distinct(Types, 'Type')
  2. Sort(Distinct(Filter(Types,'Type'=Dropdown1.Selected.Value),'Sub-Type'),Result)
  3. Sort(Distinct(Filter(Types,'Type'=Dropdown1.Selected.Value, 'Sub-Type'=Dropdown2.Selected.Value),'Type Category'),Result)

 

The problem I can't seem to resolve is when data is submitted the child dropdown values does not populate the parent list with the dropdown selection.  How can I get that to work?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Which type columns do you use to store the three Dropdown selected values within your Parent List? Choice type columns?

 

I assume that you use three individual Choice type columns to store the three child Dropdown selected values, is it true?

I have made a test on my side, and don't have the issue that you mentioned, please take a try with the following workaround:

Within the Edit form (parent list form), set the Update property of the Data card which contains the first Dropdown box to following:

{
   Value: Dropdown1.Selected.Result
}

set the Update property of the Data card which contains the second Dropdown box to following:

{
   Value: Dropdown2.Selected.Result
}

set the Update property of the Data card which contains the third Dropdown box to following:

{
   Value: Dropdown3.Selected.Result
}

 

If you use three individual Single text columns to store the three child Dropdown selected values, please take a try with the following workaround:

Within the Edit form (parent list form), set the Update property of the Data card which contains the first Dropdown box to following:

Dropdown1.Selected.Result

set the Update property of the Data card which contains the second Dropdown box to following:

Dropdown2.Selected.Result

set the Update property of the Data card which contains the third Dropdown box to following:

Value: Dropdown3.Selected.Result

Please take a try with above solution, 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

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Which type columns do you use to store the three Dropdown selected values within your Parent List? Choice type columns?

 

I assume that you use three individual Choice type columns to store the three child Dropdown selected values, is it true?

I have made a test on my side, and don't have the issue that you mentioned, please take a try with the following workaround:

Within the Edit form (parent list form), set the Update property of the Data card which contains the first Dropdown box to following:

{
   Value: Dropdown1.Selected.Result
}

set the Update property of the Data card which contains the second Dropdown box to following:

{
   Value: Dropdown2.Selected.Result
}

set the Update property of the Data card which contains the third Dropdown box to following:

{
   Value: Dropdown3.Selected.Result
}

 

If you use three individual Single text columns to store the three child Dropdown selected values, please take a try with the following workaround:

Within the Edit form (parent list form), set the Update property of the Data card which contains the first Dropdown box to following:

Dropdown1.Selected.Result

set the Update property of the Data card which contains the second Dropdown box to following:

Dropdown2.Selected.Result

set the Update property of the Data card which contains the third Dropdown box to following:

Value: Dropdown3.Selected.Result

Please take a try with above solution, 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

Anonymous
Not applicable

Thank you!  this worked perfectly!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,989)