Hi all,
I’m currently having a problem with the comboboxes in that they only show the delimiters in the app after submitting the form (e.g. I would expect to see “Item 1, Item 2, Item 3” and instead I see “ , , , ”). It seems to be a problem for both single select and multi-select comboboxes, but not for the drop downs, free text fields or radio buttons that are also within the form but display selected results correctly. Even stranger is that the data is recording correctly in the back end Sharepoint list (i.e. “Item 1, Item 2, Item 3”).
I have included the objects and properties that I think may hold the key to the mystery below, but remains unsolved (due to a lack of solving by me). Any assistance or ideas will be greatly appreciated.
Object | Property | Formula (fx) |
cbxOperatingCountries(combobox) | Item | SortByColumns(Filter('Country risks',('Country risk level'.Value = "High" Or 'Country risk level'.Value = "Severe" Or 'Country risk level'.Value = "None")),"Title").Country |
cbxOperatingCountries(combobox) | DefaultSelectedItems | RenameColumns(Filter(Split(Parent .Default,","),!IsBlank(Result)),"Result","Value") |
cbxOperatingCountries(combobox) | Reset | false |
Data Card Operating Countries | Default | ThisItem.OperatingCountries |
Data Card Operating Countries | Update | Concat(cbxOperatingCountries.SelectedItems, Country & ", ") |
Submit button | OnSelect | SubmitForm(Form1) |
Form1 | DataSource | Sharepoint List 1 |
Form 1 | OnSuccess | Set(glbCurrentRecord, Self.LastSubmit); |
Form1 | Item | Patch(Coalesce(glbCurrentRecord, Defaults('Sharepoint List 1')),{ID: Blank()}) |
