Skip to main content
Nintex Community Menu Bar

Brackets around data


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.

Translate
Did this topic help you find an answer to your question?

2 replies

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 463 replies
  • July 29, 2022

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.

Translate

Garrett
Forum|alt.badge.img+16
  • Scout
  • 904 replies
  • July 29, 2022

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

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings