Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Variables in Dynamics ...
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 Robin ConXioN 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?

  • Suggested answer
    cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Variables in Dynamics Marketing E-mail based on event location & event sessions

    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans