Cascading Dropdown Editing Issue

[Bluenose]

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?

[StalinPonnusamy · Accepted solution]

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

[StalinPonnusamy]

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

[Bluenose]

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