Power Platform Community Forum Thread Details

Dear Community,

I am having difficulty getting my cascading dropdowns to work in my customised SharePoint list Power Apps form. The relationship is 'Department' (Parent) and 'Section' (child), which has over 250 values in total - in a separate list in my site. Unfortunately, on Edit and View Form, the 'Section' blanks out. The issue happens sporadically. I am using Edge browser - latest version on Windows 10.

My solution is as follows:

In my Department and Section DataCard, I have added a new dropdown field - Default property set to 'Parent.Default'
The original 'DataCardValue' field is set to: myDropdown.Selected.Result
AllowEmptySelection is turned on for Department and Section
Items property in Department is set to: Sort(Distinct(DepartmentSectionStructure, Department.Value).Result, Ascending)
Items property in Section is set to: Sort(Filter(DepartmentSectionStructure, Department.Value = Dropdown1.SelectedText.Value), Title, Ascending)

Has anyone else seen this issue before?

Thanks.

Categories:

Building Power Apps