web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Variables in Dynamics Marketing E-mail based on event location & event sessions

(0) ShareShare
ReportReport
Posted on by 25

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:

  • {{ contact.firstname }} - Contact Firstname
  • {{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.msevtmgt_name}} - Originating Event Name
  •  {{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.msevtmgt_eventstartdate}}  - Origininating Event Date
  • {{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.msevtmgt_attendeeurl}} - Originating Attendee URL

--

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: 

9b6aad26-5087-4680-abfd-c8554b0ce9df.


Sessions: 

---

I am unable to find the right variable for 'location' and 'sessions' wich I refer to as Building. 

  • {{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.msevtmgt_building}}
  • When I integrate it it only showes a code

For sessions I used the variable 'Define Sessions'

  • But it doesn't seem to show anything. 

 

Is there any work around this?

I have the same question (0)
  • Suggested answer
    cloflyMao Profile Picture
    25,210 on at

    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. 

    pastedimage1603179490718v1.png

    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 .

    pastedimage1603180519492v2.png 

    add an extra br tag to each item to break the line. 

    pastedimage1603180687286v3.png

    pastedimage1603180758837v4.png

    Result:

    2330.x1.JPG

    Sessions:
    {{contact.contact_msevtmgt_event_msevtmgt_originatingeventid.new_sessionlist}}

    pastedimage1603180967229v6.png

    Regards,

    Clofly

    pastedimage1603180943427v5.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Pallavi Phade Profile Picture

Pallavi Phade 94

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 69 Super User 2025 Season 2

#3
TAHER Mehdi Profile Picture

TAHER Mehdi 58

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans