How do I edit values pulled into a multi-select combo box and submit the data correctly?

Like (1) Share

Report

Posted on 13 Mar 2025 16:49:43 by futr_vision

813 Super User 2025 Season 1

Here is my situation. I have an app with a screen (gallery form screen) that contains a gallery and a form which can be edited when a user selects a gallery item. This all works great and most fields are easily editable and save correctly. However, I have one oddball field. This field returns a value from a Dataverse table that has multiple segments as seen below. This data is from a multi-select combo box on the initial form.

I added this data, to the Dataverse table, using a concat function for the Update property of the multi-select combo box like this

Concat(CB_PartnerName.SelectedItems,'Partner Name',";")

On the gallery form screen the combo box populates correctly (sort of) with the data from the Dataverse table as shown above. However, when I go to edit that field, I run into issues. Adding an additional item from the drop down I get a result that looks like this. I am guessing this largely due to the fact I am using the same function on this combo box.

Ideally, I want to this to work one of two ways.

The next item I select gets concatenated to the end of the original. For example, if I add Cisco the update would submit HPE;Inte;Multiple;Cisco to the Dataverse table.
The other option is that when the data is retrieved from the Dataverse table the reverse of the concatenation is done. Each item shows up as it normally would in a multi-select combo box as this mock-up below shows. This way I can remove existing items and add new items and still write it back to the Dataverse table as a concatenated value separated by semicolons

Any ideas how to effectively do this?

All responses (2)

Answers (1)

Verified answer

MSR@08012015 542 on 14 Mar 2025 at 05:18:29

Like (0)

Report
How do I edit values pulled into a multi-select combo box and submit the data correctly?

Hi,

Basis on my understanding, try this below approach.

CB Items Property

Choices(TableName.Column)

CB Default Selected Items Property

ForAll(Split(ThisItem.ColumnName,";"),{Value:Result})

DataCard Update Property

Concat(Combobox.SelectedItems,Value,";")

If you still facing issue revert us back with screenshot we can resolve it together.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item
Michael E. Gernaey 35,902 Super User 2025 Season 1 on 14 Mar 2025 at 02:14:15

Like (0)

Report

How do I edit values pulled into a multi-select combo box and submit the data correctly?

Hi @futr_vision

Can you please post your DefaultSelectedItems and the Default for the Text Label

Question:

So you select A and click Save (submit form), you see only A in the Dataverse?

You Edit

You Select B

Now you see A,B,A,B ??

If you Submit the form what is in the back end?

I see no reason why your update code would be doubling everything up

So thats why I want to make sure, if you are saying the back end is doubled up? Or just in the UI? In which case that should be easier to resolve.