So, you have 3 parts to your question.
How to create an email that:
- includes a list or repeating group of variable length
- combines 2 fields in the db per line of the list
- personalizes this for each user.
Let’s leave 3 out of it for the moment, b/c that’s too hard to answer right now.
For 1 & 2:
There are several ways to do this, but in my experience the easiest/error-proof is to create a new field in your db that has the ‘line’ as you’d like it to appear in the email. In your case, create a field that combines the Event Date and Event Title to read Event Date: Title . Make sure to put the colon and space in your new field - that way you can call the field in your email and it will look just how you want it to with no further adjusmtents.
Then, when it’s time to create your email, do:
"Here’s a list of upcoming events:
Search Event’s [New field] joined with line_break ."
That will list your events in the way you want. You can put whatever search constraints on the search to get the listings you need.
I would start here. Once you’re ready you can look into the 3rd part of your question, ‘personalize an email for each user’. For this it sounds like you need to run an API workflow on a list. It’s tricky but Nigel has written elsewhere on it and provided demo examples and you can learn how to do that once you do the above.