Brackets around data

J

I put together a Sharepoint Online list.  There are some multiple choice fields.  When the Nintex Cloud Form is submitted, the multiple choice fields have brackets and quotations around the data (first row in screenshot attached).  If I enter the information directly in Sharepoint Online, this doesn't happen (second row in screenshot).  I made the list column in Sharepoint Online a single text field and it still does this (last three rows).  Any thoughts?  

We have other lists/forms connected to the same Sharepoint Online Site that contain multiple choice fields and this isn't happening.  Am I missing something?
Thanks for any information.

1 Attachment

2 replies

bamaeric
Userlevel 5
Badge +13

The "Choice - Multiple" form control in NWC stores its selections data in a collection. If you just need to get the first/only value from the field, you can use the "Get item from collection" workflow action to extract just the value (without the brackets and quotations) and store that in a text workflow variable. If you need multiple values, then you would need to loop through the collection to pull out each value and add/append it to a text workflow variable.

Garrett
Userlevel 6
Badge +16

Hi @jenniferl 


 


As @bamaeric explained, the values are stored as a collection type.


 


Here is a simple solution If you just want to remove the square brackets and quotation marks from a multiple choice list, refer to this article https://community.nintex.com/t5/Nintex-Workflow-Cloud-Forum/Way-to-remove-the-square-brackets-and-quotation-marks-from-a/m-p/94884 (using Regex)


 


If you want the Regex to add a space after the comma, refer to this recent article https://community.nintex.com/t5/Nintex-Workflow-Cloud-Forum/RegEx-to-add-a-space-after-a-comma/td-p/221711 


 


Credit to @burked for providing the solution to both.


 


Cheers

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings