Hi all,
I have a form with several comboboxes, and on form submission the information is being saved to a Sharepoint List. When selecting an existing record to open in the form, all the information is retrieved correctly from Sharepoint and displayed in PowerApps but an issue arises when making a change to the record and resubmitting the form.
What I want to happen is for any combobox that is amended by the user in PowerApps should have the updated values reflected in the Sharepoint record, and for any combobox that is not amended should remain unchanged in the Sharepoint Record.
What is actually happening is:
- Powerapps doesn't seem to recognise that there are already records in all comboboxes, except for the comma which separates the items in Sharepoint (this renders my IsBlank test moot as it keeps picking up the commas, per screenshot below)
- When adding an additional item in the multi-select comobobox PowerApps only records this new item in Sharepoint and erases the previous item
- If no amendments are made to the combobox values the original combobox values are cleared from the sharepoint record and replaced only with the comma delimiter
Please see example combobox & screenshots below. Any assistance will be greatly appreciated.
Before any amendments made to the combobox values
After amending combobox value to add "Cambodia" and submitted form, Sharepoint overrides the previous information instead of showing "Egypt, Djibouti, Cambodia"
