Hi,
I am experiencing an unusual behavior in an SP custom form when using comboboxes. When I modify another column in edit mode and then save, the default value in the SP list column, associated with the combobox, gets erased and changes to blank.
I’ve built a SharePoint list/custom form. It has two columns: ‘Name’ and ‘MultipleChoice’ (with options: choice 1, choice 2, choice 3).
Scenario 1:
I modified the Name Datacard to create a dropdown (ddName) which is associated with a different data source. The settings are:
Items = ‘EmployeeList’ with Value set to ‘Title’
Default = Parent.Default
Datacard Update: ‘ddName.Selected.Title’.
This configuration works perfectly when I enter new records, edit records, and save records.
Scenario 2:
Later, I modified the same Datacard: I removed the dropdown and replaced it with a combobox (cbName), associated with the same data source (EmployeeList). The settings for this are:
Items = ‘EmployeeList’ with Field primary text set to ‘Title’
DefaultSelectedItems = Table({Value: Parent.Default}) or {Value: Parent.Default}
Datacard Update: ‘cbName.Selected.Title’.
When I create a new record, everything works as expected. However, when I edit a record and change the 'MultipleChoice' option then save, the 'Name' value is erased and appears as blank in the SP list.
Scenario: 3
As a workaround, when I set the data card items to Distinct(EmployeeList, Title) and change the Datacard Update to cbName.Selected.Value, the issue disappears, and the 'Name' value doesn’t get replaced with blank upon editing.
Items = Distinct(EmployeeList, Title)
DefaultSelectedItems = Table({Value: Parent.Default}) or {Value: Parent.Default}
Datacard Update: ‘cbName.Selected.Value’.
Have I overlooked something? Why doesn't scenario: 2 work properly?
