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
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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

Top Solution Authors
Top Kudoed Authors
Users online (3,666)