Hi
I want to make a e-mail with a variable with refers to Location and Sessions.
As of right now the folowing variables worked perfectly to integrate:
--
The mail looks like this:
Thank you Robin for your registration
Soon the event 'The digital workplace' will take place and we will gladly provide you with all the practical information.
Date: 2020-10-07 09:00
Did you choose to attend the event online or in the Experience Center? Then you will find the right information below.
Link to webinar: Click here (this works)
Locatie:
Sessions:
---
I am unable to find the right variable for 'location' and 'sessions' wich I refer to as Building.
For sessions I used the variable 'Define Sessions'
Is there any work around this?
Hi Robin,
Reasons:
Location
Lookup field such as "Building" or "Room" only stores the GUID of record.
In Dynamics, the field will be formatted by system to show record name, however, dynamic expression only shows the raw GUID value in email.
Sessions
'Define Sessions' is an optionset field, it is used for defining progress of sessions.
Solution:
Location
Create a new custom text field like "Building name" to save the name value of building record, trigger a flow to on creation/update of event entity to sync building name to the custom field.
(Retrieve the building whose id equals to value of Building field, then populate the custom field with name property of the retrieved record.)
Sessions
Dynamic expression only supports to retrieve the record that is directly related to contact, email checker will throw error if there is a indirect entity.
(Contact -> Event -> Session)
Similar to the solution above, please create another multiple line text field to Event entity to save associate sessions,
then triggering the flow on same condition:
In flow, we initialize a string variable to save sessions list, append each session item to the variable with "Apply to each" action .
add an extra br tag to each item to break the line.
Result:
Sessions:
{{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.new_sessionlist}}
Regards,
Clofly
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156