I'm trying to add gallery record to a collection and I'm getting this msg. My expression is this on the onselect property:
UpdateIf(
colLocations,
numID = ThisItem.numID,
{
Facility: Dropdown4_1.Selected,
Location: Dropdown2**.Selected**
}
)
These are the dropdown properties:
Facility dropdown Items Property:
Choices([@'Access Details'].Facility)
I wanted to filter the Location dropdown by the Facility dropdown.
Location dropdown Items Property:
Filter(Locations, Facility = Dropdown4_1.Selected.Value)
The problem is the Location. When I am adding location into the collection I am adding it as a Location record. But when i added the defaults into the collection initially (I wanted my gallery to show blanks in the dropdown controls), I'm adding it as the Access Details Location lookup.
Collect(colLocations,
{
Facility: Defaults('Access Details').Facility, //Facility column is a lookup to the Facility list
Location: Defaults('Access Details').Location //Location column is a lookup to the Location list
}
);
So how can change the location defaults to match the schema of the location dropdown so that when I add the dropdown into the collection it matches?
