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

(1) Share

Report

Posted on by abbyamante

110

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

All responses (6)

Answers (1)

Verified answer

abbyamante 110 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
Suggested answer

SaiRT14 1,216 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)
ronaldwalcott 855 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)
DS-14111351-0 2 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.
abbyamante 110 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.
Suggested answer

FLMike 29,361 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