- Bring in the second Datasource: Data -> Connectors -> Select type -> Fill in required selections.
- Change your form, text box to dropdown.
- Advanced Unlock
——————————————————————– - Items – Data source: Bring in the Data source for Items
Change from ‘Parent.AllowedValues’ to Datasource Name
or
Distinct(DatasourceName, ColName)
Sort(Distinct(DatasourceName, ColName),Result)
SortByColumns(‘Zebra-Colors’.ColourName, “ColourName”)
———————————————————————- - Update: Select the datacard – Update:
DataCardValue20.Selected.Value
TO
DataCardValue20.Selected.Result (column name)
————————————————————————- - Default: Select the dropdown and change from’ Parent.Default’ to:
If(EditForm1.Mode = FormMode.Edit, Parent.Default, ” “)