cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bluenose
Frequent Visitor

Cascading Dropdown Editing Issue

Hi,

I have created a Power App with 3 Cascading Dropdown Boxes and it works as intended when adding a record to a SharePoint Online (SPO) List. However, when I wish to edit a record I cannot retrieve the selections that were made in those Cascading Dropdowns. I think it is because when I store the records in the SPO list, they are stored as Text Input boxes. 

 

The reason that I store them in this fashion is because I have written a PowerShell script that imports XML data for 1000+ legacy records from SharePoint 2010 InfoPath forms.

 

Can you please advise if this can be achieved or if there is a better way to accomplish this task?

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Community Champion
Community Champion

Hi @Bluenose 

 

Yes, this can be achieved. This example is based on your text column.

 

Items property is

 

Distinct(MappingSPList,ColumName).Result

 

 

Set the DefaultSelectedItems property to 

LookUp(Distinct(MappingSPName,ColumnName).Result,Result=ThisItem.ColumnName)

 

Set Update property to

ComboBoxName.Selected.Result

 

In My Example, I have Region, Country, and State. (SP List Called Facilities)

 

Region (Name : RegionComboBox)

 

Items Property

Distinct(Facilities,Region).Result

 

DefaultSelectedItems property to

LookUp(Distinct(Facilities,Region).Result,Result=ThisItem.Region)

Update Card property is

RegionComboBox.Selected.Result

 

Country (CountryComboBox)

 

Items property 

Distinct(Filter(Facilities, Title = RegionComboBox.Selected.Result),Country).Result

DefaultSelectedItems property to

LookUp(Distinct(Facilities,Country).Result,Result=ThisItem.Country)

Update property to

CountryComboBox.Selected.Result

 

The same goes for State as well.


Thanks,
Stalin - Learn To Illuminate

View solution in original post

3 REPLIES 3
StalinPonnusamy
Community Champion
Community Champion

Hi @Bluenose 

 

Yes, this can be achieved. This example is based on your text column.

 

Items property is

 

Distinct(MappingSPList,ColumName).Result

 

 

Set the DefaultSelectedItems property to 

LookUp(Distinct(MappingSPName,ColumnName).Result,Result=ThisItem.ColumnName)

 

Set Update property to

ComboBoxName.Selected.Result

 

In My Example, I have Region, Country, and State. (SP List Called Facilities)

 

Region (Name : RegionComboBox)

 

Items Property

Distinct(Facilities,Region).Result

 

DefaultSelectedItems property to

LookUp(Distinct(Facilities,Region).Result,Result=ThisItem.Region)

Update Card property is

RegionComboBox.Selected.Result

 

Country (CountryComboBox)

 

Items property 

Distinct(Filter(Facilities, Title = RegionComboBox.Selected.Result),Country).Result

DefaultSelectedItems property to

LookUp(Distinct(Facilities,Country).Result,Result=ThisItem.Country)

Update property to

CountryComboBox.Selected.Result

 

The same goes for State as well.


Thanks,
Stalin - Learn To Illuminate

View solution in original post

StalinPonnusamy
Community Champion
Community Champion

Hi @Bluenose 


Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

@StalinPonnusamy Yes, that worked as instructed. Apologies for not getting back sooner but I was on annual leave for a few days last week. 👍

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,992)