We have a list in SP2013 environment where we want a workflow which sends out a summary email to the "assigned to" person of all the items which is due to him. can that be done?
Solved! Go to Solution.
Yes you can do this in an email using workflow.
Use a Site Workflow to query the list and build a collection, then use a For Each to loop through the collection and in each loop, build a string with the HTML containing the information relating to that item and store that HTML in a variable, appending it to the variable mean it builds and builds rather than overwriting the variable value.
Then use this HTML in your email.
I finished a blog post that may help you.
Let me know if you have questions or if the blog helped you accomplish what you needed.