cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Formatting output of multiple checkboxes

Jump to solution

Hi - 

I have a form where users select a bunch of options from a checklist. e.g. "I want A, D, E, G"

I want that list emailed to another person. 

I'm having trouble with the formatting of the selected options in the email. It shows up like this: 

{"__metadata":{"type":"Collection(Edm.String)"},"results":["A"]}

How do I get rid of all these extra characters? 

Thanks!

Labels: (1)
Reply
8 Replies
Not applicable

Re: Formatting output of multiple checkboxes

Jump to solution

‌, is there any chance you know how to do this? :-)

I'm sitting with ‌ at the xchange conference, and when she asked, I thought perhaps I'd ping you and see. 

Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

‌ is the control on the form connected to a column in your list?  or is it disconnected on your form?

Any chance you can add a screenshot of the control?

Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

Hi Cassy - it is connected to a choice-based column in my list. 

Not sure if this is the screenshot you're looking for, but it's a list of technology items that can be requested, and users can select multiple checkboxes:

Then in my workflow, I'm just sending an email to technology that references the checked items in Item Properties: 

It's this email that results in all the extra characters I reference above: 

{"__metadata":{"type":"Collection(Edm.String)"},"results":["CRM Access, Phone"]}

0 Kudos
Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

OK let me try one sec.

Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

OK odd here is what I have:

Works fine for me.

What version SharePoint/Nintex are you using?

What does the saved item look like in your list?  Mine looks like this:

Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

Ah, I see, I've been doing it all wrong. I'd been inserting the choices into the email from Item Properties in the column on the right, but I should have been using Advanced Lookup, which stripped out all the gobbledygook when I selected Comma Delimited. However mine doesn't give me spaces between the commas: 

Technology requested: Computer,Phone Number,Advisor View access,Other

But this is better than what I had before!

Reply
Workflow Hero

Re: Formatting output of multiple checkboxes

Jump to solution

Oh good pleased it was a simple fix.  You can always use regular expression action to replace "," with ", " if you want a space?  ‌ all done

Reply
Not applicable

Re: Formatting output of multiple checkboxes

Jump to solution

So nice of you to take the time, ‌! ‌, would you mind clicking "mark correct" by Cassie's reply that helped? It'll help others in the community find the answer to this in the future.

Thanks!

0 Kudos
Reply