I am trying to take a values from a multi-select checkbox and store in a collection so I can loop through them. I was wondering if I could use a regular expression and split it, but I am not sure of the syntax.
So, I was struggling with this and finally figured it out.
That's it. For me, it was discovering the option to bring back the return type of a choice checkbox column type. I spent HOURS trying to regex the string before discovering that.
I think it's a semicolon, but not sure. Maybe first test this by using a workflow set to start manually, and all it does is use the log to history action. In the action use a reference to the multi select field and nothing else. Run the workflow on the single item and check the value from workflow history. Then build the primary workflow using that data. Using the regular expression Split option is a great way to split values like these into collections, then use the for-each loop through that collection.
It's actually just ;#
so a semicolon followed by a hash.
noteworthy that a field like that starts and ends with those. So your data could be stored as
if you need additional help to the above, this is a really good blog https://community.nintex.com/community/tech-blog/blog/2014/07/28/regular-expressions-in-nintex-workflow
Great work Cassy Freeman and Thorsten Dehaes!
Paul Vana, does this help answer your question?
Great use of built in features!
Just made use of this, and Nintex cleverly allows you to format the result of Lookups as well so you can choose the Lookup value or ID!
With some new options now available to us, the best practice would be to store the multiselect item property into a dictionary, fetch the collection within the dictionary, then for each on the collection. This way there is no parsing work required.
Retrieving data ...