Hello, I have a SharePoint List called 'Visit' that records the Clinical Visits of workers at a site.
In my PowerApps Form that is supposed to create a New Visit record, I have 2 ComboBoxes: Labor Name and Labor_ID, both being Lookup Fields in the Visit list(the image is attached below).
If the name changes, the ID in the ComboBox below changes to the related ID and vice versa (if the ID changes the Labor Name in the ComboBox above changes to the related name).
*The problem is when I submit the form, all the form's data is successfully submitted to a new Visit Record in SP, except for the 2 ComboBoxes Labor & Labor ID; creating blank cells in the newly created record*
It did randomly submit on 2 occasions but that was it.
Labor Name ComboBox `OnChange`:
Set(varFromLaborList, false);
Set(var_Labor_Name, laborNameComboBox.Selected.Value);
Reset(laborIdComboBox);
Labor Name ComboBox `DefaultSelectedItems`:
[LookUp(Labor, Labor_ID = var_Labor_ID, 'Name (FirstName)')]
Labor_ID ComboBox `OnChange`:
Set(varFromLaborList, false);
Set(var_Labor_ID, Value(LaborIdComboBox.Selected.Value));
Reset(LaborNameComboBox);
Labor_ID ComboBox `DefaultSelectedItems`:
[LookUp(Labor, 'Name (FirstName)' =var_Labor_Name, Labor_ID)]
Finally OnSelect I just use SubmitForm(MyForm)
