Sharepoint Integration with Powerapps Forms- Unable to update multi select Combo box values to the existing values in a record

[Maja2]

I'm new to Power apps. We are integrating the sharepoint list with the power apps form. I have single line text column in the sharepoint list. In Powerapps the input is a combobox with multi select enabled. When i use the form in new mode, the updates to the backend Sharepoint list happens seamlessly. However when the Form is in Edit mode, I have set the DefaultSelectedItems Property to 

If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(SharePointForm1.Mode=FormMode.Edit,RenameColumns(Split(ThisItem.'Functional Area',","),"Result","Value")))

The existing items for the record i'm editing is showing as selected in the combo box selected items. However, when i update the selection (Either add new selection or delete), the existing values are not captured and only the new values are captured. For eg: If the record has "Yellow, Red" selected, and if i select "Blue" in the combobox list while editing, the new updates happens as ",,Blue" instead of "Yellow,Red,Blue."

Update Property of the Data card: Concat(ComboBox4.SelectedItems,Result,", ")

Items for the multi Select Combo Box: Distinct(Colors,'Name')

Any help here is much appreciated.

[victorcp · Accepted solution]

Hi,

in your combobox the item has this schema {Result: ""} but the default schema is {Value: ""}, remove the renamecolumn and it should work.

If(SharePointForm1.Mode=FormMode.View,Table({Value: Parent .Default}),If(SharePointForm1.Mode=FormMode.Edit,Split(ThisItem.'Functional Area',",")))

[Maja2]

Thanks @victorcp The above solution worked.