Loading a Collection Variable

[rogerb]

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!

[emha · Accepted solution]

query like this should work

‌ yes/no field‌ ‌ ‌

[rogerb]

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?

[rogerb]

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.