I want to send an email with attachments from an unrelated library. I know I can attach via URL to that particular file. But what if the files to be attached are based on query conditions, so now each emails will have different files and different number of files to attach.
I have the query part done, and it's building a collection variable "col_collected_urls" with the URL's of all the files that should be attached. Is there any tricks with the syntax for the variable I assign to the Email Attachments so that it can be loaded with multiple URLs.
I tried a few guesses with HTML or multi-line text but didn't get anywhere. I'd rather not create X number or empty variable and fill them because I don't know how many will it max out at.
Since you have that data in a collection, here's what I would propose:
Use the for each action against every item in the collection - output each item as a single URL
What should happen is the loop will go through each URL and push it into the variable below it. You can then capture that URL and store it in a table or whatever as part of the build string.
The output of the build string will then be a collection of all the URLs outputted in order and in a readable format, not just a collection with semi-colons.
If you care to export your workflow and list template, someone may be able to configure it for you quickly. 🙂