How do we get all results to be stored in a variable so that we can later use that variable to send out an email to multiple email addresses?
In a Site WF running daily
There are multiple Sql Queries configured the same (just on different views in db) pulling back multiple email (contacts) Storing in a collection variable - in the WF History, we can see only one email address is being stored (there should be several)
When testing the query in the wf, we get multiple results - SQL Query is a success
we want the collection variable to take each email address and separate it by a comma or a semicolon - for emailing purposes.