Skip to main content
Nintex Community Menu Bar

Loading a Collection Variable

  • Oct 25, 2017 12:30 PM UTC
  • 3 replies
  • 30 views
  • Translate All

Forum|alt.badge.img+8

I am trying to build a workflow that add values from a list where checkboxes were checked. For instance, say I have a list called Source, and this list has a checkbox field called Export. For all rows where Export=Yes I want to put field1 values into a collection variable. Can anyone help with this? I've searched the forum and haven't gotten the solution for this particular situation. Thanks!

3 replies

Forum|alt.badge.img+14
  • Scholar
  • Oct 25, 2017 3:37 PM UTC

query like this should work

210053_pastedImage_3.png

‌ yes/no field‌ ‌ ‌

Translate

Forum|alt.badge.img+8
  • Author
  • Oct 25, 2017 6:29 PM UTC

Ok, I've got that working. Thanks so much Marian! Now when I put try to update a Word doc with the collection variable I get some ugly formatting as below. How do I replace the "<div class" stuff with bullets or something more readable?

Translate

Forum|alt.badge.img+8
  • Author
  • Oct 25, 2017 8:22 PM UTC

Ok, so I've figured out that the formatting was from the column type. Once I changed it from multi line rich text to plain text I was able to get a semicolon delimited string. I should be able to do a regex to convert that to a bulleted list.

Translate