combobox selected items returns a json string format instead of clean values

(1) Share

Report

Posted on by abbyamante

112

Hello Experts,

I have an issue with my combobox control inside my form control in canvas apps.

Im using a sharepoint as a data source and the values selected shows on a correct format. (please see image below)

but in my canvas apps it shows on a json format (please see image below)

how can i change this into a clean format (Dosis, mts350,EII, AF)?

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Michael E. Gernaey 52,203 Super User 2025 Season 2 on at

Like (1)

Report

combobox selected items returns a json string format instead of clean values

Hi,

This is because it's a Choice field, so that's the format you get.

That being said, you do not explain WHERE it shows up like this, because it won't in a comboBox.

So I added a form, set the SelectedItems to multiple, then I have a Label where I concat the Value property which has the string you want,

into a label

Was this reply helpful? Yes No
abbyamante 112 on at

Like (0)

Report

combobox selected items returns a json string format instead of clean values

@FLMike - thank you for your input. My apologies, my post is missing some information.

in my data source (SP list) its a multichoice column. and the values shows up correctly just like the image below:

but in my canvas app in my Form control, Combobox datacard (Please note im using modern controls), the choices selecteditems are showing as a JSON format.

I did not have this issue with the classic form control though. only in the modern form control.

Please see results in my canvas app form below:

In the DefaultSelectedItems property i have = [Parent.Default].

also please note, I am re-using the same form control when the user needs to edit an item.

Was this reply helpful? Yes No
DS-14111351-0 14 on at

Like (0)

Report

combobox selected items returns a json string format instead of clean values

Did you find a solution for this? I have the same issue.

Was this reply helpful? Yes No
ronaldwalcott 3,827 Super User 2025 Season 2 on at

Like (0)

Report

combobox selected items returns a json string format instead of clean values

Your item statement looks incorrect should be more like Choices(myListName.MyColumnNameContainingChoices)

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,988 Super User 2025 Season 2 on at

Like (0)

Report

combobox selected items returns a json string format instead of clean values

pls try the following:

Concat(ComboBox.SelectedItems, YourFieldName & ", ")

If your ComboBox control is named ComboBox1 and the field you want to display is Title, the formula in a label would look like this:

Concat(ComboBox1.SelectedItems, Title & ", ")

Remove Trailing Comma - Left(Concat(ComboBox1.SelectedItems, Title & ", "), Len(Concat(ComboBox1.SelectedItems, Title & ", ")) - 2)

Was this reply helpful? Yes No
Verified answer

abbyamante 112 on at

Like (0)

Report

combobox selected items returns a json string format instead of clean values

Hello All,

Thank you all for your help and answers. It was actually a simple fix on my end. Im using a sharepoint list as a data source and the issue was in my list im using a column type Multiline Text and i have the Enhanced rich text turn on.

I changed the settings to 'no' and it fixed the issue

Was this reply helpful? Yes No