I have a lookup field that is a combobox called Location. When not blank, this field auto-populates other fields with WorkAddress, WorkCity, and WorkState. The data is pushed to SharePoint (datasource) properly with the exception of the WorkState field (Dropdown). I have two issues:
- The OnChange property for Location is updating all items in the canvas app instead of just the item. But, as stated above, it is updating the SharePoint list correctly except for the WorkState.
- The WorkState Update property is throwing an error and from all of my research and past experience, the formula looks correct. The error is "Expected Record Value".
Here are my formulas on each where PSDR TAA Addresses is a lookup list. The main datasource is EmpDB:
Location.OnChange: Clear(colLocationUpdate);
ClearCollect (colLocationUpdate,
LULocationDataCardValue.SelectedItems.Value)
Location.Update: LULocationDataCardValue.Selected
WorkState.Update:
If(
!IsBlank(LULocationDataCardValue),ForAll(
colWorkState,
{
Id: LookUp('PSDR TAA Addresses',STATE = Result).ID,
Value: LookUp('PSDR TAA Addresses',STATE = Result).STATE
}
))
Thank you in advance for your assistance.
