Power Platform Community Forum Thread Details

I have a dropdown in a form which stores the name of a school building. The data for this form is stored in a sharepointe list alled Rita_TED2205

The items for this dropdown are dependent on two other dropdowns outside of the form, and the data used to populate these dropdowns is stored in a Sharepoint list called Rita_County_District_Building. Everything works fine when the user uses the dropdowns to select the building that data gets stored back to Rita_TED2205 in a building column no problems.

The issue I am having is the dropdown won't display default value stored in the Rita_TED2250 building column. I can see it is the default value in the right hand property navigation so it is assigning the value and storing the value correctly. Here is my code for the dropdowns.

CountyDrop Down (outside of the form):

ForAll(Distinct(Rita_County_District_Building_MDE, County), {Result: ThisRecord.Value})

District DropDown (outside of the form):

Sort(ForAll(Distinct(Filter(Rita_County_District_Building_MDE, County=County_Select.Selected.Result),DistrictName), {Result: ThisRecord.Value}),Result)

Building DropDown (in the form):

Sort(ForAll(Distinct(Filter(Rita_County_District_Building_MDE, DistrictName=District_Select.Selected.Result),BuildingName), {Result: ThisRecord.Value}),Result)

My datacard default for the building dropdown in the form is ThisItem.building and default for the dropdown is Parent.Default

I have tried to use a lookup because the items are coming from a different list because I read about this solution, but I cannot get it to work.

Categories:

Building Power Apps