Event Registrations & Real-time Marketing Journeys

Online events are a big part of marketing. Ideally your customers sign up to gain more insights from you as subject matter experts, and new prospects register because they are interested in your products or services and want to hear what you have to say. Win/Win! D365 Marketing provides an Event planning and management area to set up your webinars (or in-person events) and use Microsoft Teams as part of the process. I wrote a full series of blogs about how to do this, but using Outbound Marketing. What about how this might be possible with Real-time Marketing? Think of having 1 Trigger, 1 Email and 1 Journey. Each time someone registers for an event they get a fully customised email that relates to the correct Event, including a calendar invite they can add to their calendar. Wouldn’t that be cool? Let’s see how it can be done.

NOTE: This was written quite some time ago, and changes have been made since that this is no longer needed. Although you can still use this approach if you want a fully custom ICS file, it’s not needed to make sure you have one for each Event that is registered for. The out of the box trigger will allow for this.

The first thing, if you’ve never created an Event before, go ahead and read the following three posts:

• Creating Your Registration Form
• Adding Team Members & Speakers
• Adding Your Webinar Event

Create Your Custom Trigger

Once that is sorted, we now need to create a custom Trigger to use in our marketing email(s) and journey. For those of you who have dug in to this already, you will know that there is a Marketing Event Registration Created trigger that exists out of the box. Although you can get a lot from it, one thing is missing, and that’s the ability to do anything about a calendar invite (ICS file). You would need to create a different email for each webinar, and therefore create a different journey for each one too. Creating our own custom Trigger means we can get exactly what we need. Navigate to the Triggers area under Real-time Marketing and then click New Trigger. Give it a name and description.

Now add in the variables needed. We will be passing through the right data when someone registers for the webinar via the marketing form you’ve added to your website. You don’t need all of these, but read through to the end to see what I do with them, then you can decide what to leave out of your trigger (or add in if you think I’ve missed something!). Make sure the data type is text for all of them except the Event Start and Event End Time. Those should be set as Date/Time. Remember, you don’t need to set up anything for values from the Contact, you can get those without the need for a trigger. Walk through the next screens and then finally make it live by clicking on the Ready to use button.

NOTE: This was written quite some time ago, and changes have been made since that this is no longer needed. Although you can still use this approach if you want a fully custom ICS file, it’s not needed to make sure you have one for each Event that is registered for. The out of the box trigger will allow for this.

Create Your Marketing Email

Once the Trigger is live, we can then set up our email and use the values from the Trigger. Select your template then start creating your email. For each Event, you might use the Event Image column on the Website and form tab to add something unique for each one. Let’s add this so the top header image of the email is different depending on which event it is for. Add an image to the email then pick Insert from URL.

Type directly in to the field and call it something like {{EventImage}}. Then click Insert. Nothing will display, but if you also decide to use an Event Image and pass through the URL for the image in to your trigger, it will be displayed.

We need to map this dynamic content to the right trigger value. Click on the Personalize option from the right, and you will see the new EventImage you added with a red icon next to it. Click on the Event Image dynamic personalisation tag you added.

Now you can map it and find the Event Registration trigger you created, then select the Event Image value from the list.

You can keep building out your email based on your own requirements. Below you can see where the header image would show (just a little image icon for now), the Contact’s first name, the Event Name, Event Start Time to End Time and the Time Zone. Then I have added the Event Description. For the two buttons I am passing through the Unique Join Link for the Join on Microsoft Teams, and the Unique ICS File for the Add To Calendar. Finally, you can see another blank image which I added in the same way as the Event Image, but instead used the QR Code value which will also be passed through as a URL. Save your email and mark it as Ready to send. Consider creating other emails if you want to do a full set similar to how I showed in this post for Creating Marketing Emails, but using Real-time instead of Outbound Marketing.

NOTE: This was written quite some time ago, and changes have been made since that this is no longer needed. Although you can still use this approach if you want a fully custom ICS file, it’s not needed to make sure you have one for each Event that is registered for. The out of the box trigger will allow for this.

Create Flow One – New Event Created

You only need this part if you want to create an ICS file that you can then send to a Contact who has registered for an event. If you don’t want to do this, you can ignore this section. We cannot add attachments to D365 Marketing emails (yet!) but we can add buttons that link to a file stored somewhere online that is accessible to people outside of our organisation. So the first thing you will need is to decide where you store those. In this example I am using SharePoint, most organisations already use it. You will need to make sure you can create links to share documents with people outside the organisation. I wanted to create a process that could also allow for a quick clean up at the end of an event. For that I figured when an Event is created, a flow will create a new folder, simply using the Event GUID. That then gives you options to run another flow at the end of an Event to find the folder with the same name based on the GUID and delete it along with all of it’s contents. Then you aren’t wasting space with old files.

So this first flow is simple. Two steps. The first is your trigger using the Dataverse connector that runs when a new record is Added. The table name is Events, and your scope is Organization. You can of course add more filtering to this should you need it, but this just gives you the basics. The second step is the action of Create new folder from the SharePoint connector. Select the Site Address you want to use, then the top level folder to put the new folder in to. Finally, use the Event id for the Folder Path, which gives it the GUID name.

Create Flow Two – New Event Registration

NOTE: If you name your steps the same as mine, you should be able to copy and paste from the expressions I have shared. If not, then you will need to restructure them based on your own flow.

This is the flow that will run when someone fills out your marketing form online that you have linked to an Event. This creates an Event Registration record and is the starting point of our flow in a trigger from the Dataverse connector. So when a record is added, and pick the table name of Event Registrations. Set the Scope to be Organization.

Next we have an action, again with the Dataverse connector, and Get row by id. Use the Event from the trigger to get the related Event.

Then another Get row by id, this time for the Images table using the Event image value from the previous step. If you don’t intend on using Event images you can ignore this step entirely.

And another Get row by id, this time for the Contact that is linked to the Event Registration from the original trigger of the flow.

NOTE: Thanks to Matt Johnson for this next part about where to get the necessary org id from. Originally it was in a Marketing configurations record. Updated section below to reflect the change and new place to access it.

Now we need to get an id that is tied to a Web applications record in your environment. It’s unique for each one, and is not the same thing as the main Dataverse org id. So we will use a List rows action step from the Dataverse connector for the Web applications table. We only need one column, so in select columns add msevtmgt_publicendpoint. There should only be one record but I have added 1 as the row count to only bring back one record. We can then use this later on in the flow when we need to generate some URL’s that need this id included in them.

Another List rows step, this time for Time Zone Definitions. An ICS file needs to know the time zone in a very specific format and naming convention, and not one that D365 has values for. Or, we can simply add Z to the end of a date and time stamp to indicate it’s in UTC (0) time. Without these next few steps, the person receiving the calendar invite could get it with the wrong date/time for their local timezone. For example, an event at 10 AM EST should be 3 PM in the UK. However, without converting the timezone first, the recipient would get a calendar invite for 10 AM and appear to be 10 AM UK time. So, the easiest thing to do is to find the time zone from the event. We can add in a filter to the Filter rows option. This will get us the right time zone from the Event.

(timezonecode eq @{outputs('Get_Related_Event')?['body/msevtmgt_eventtimezone']})

Now we need two steps from the Date Time connector, and use the Convert time zone. One is going to be for the Start Date Time and one for the End Date Time. For the base time, it will have the Z already added to it. I want to remove that first so have an expression that will do this. It takes off the last character in the string. Then we format the string by using a custom format (scroll to the bottom of the list and click Enter custom value then paste this: yyyyMMddTHHmmss. For the Source time zone, we need to get the standard name from the Find Time Zone step. Using a List rows step means we would get an Apply to each loop if we just add the standard name field directly, so we can use an expression to get the first record found (which should be the only one) and use the field directly from there. The Destination time zone should be set as UTC Coordinated Universal Time.

For the Start Date Time:

substring(outputs('Get_Related_Event')?['body/msevtmgt_eventstartdate'],0,sub(length(outputs('Get_Related_Event')?['body/msevtmgt_eventstartdate']),1))

@first(body('Find_Time_Zone')?['value'])?['standardname']

For the End Date Time:

@{substring(outputs('Get_Related_Event')?['body/msevtmgt_eventenddate'], 0, sub(length(outputs('Get_Related_Event')?['body/msevtmgt_eventenddate']), 1))}

@first(body('Find_Time_Zone')?['value'])?['standardname']

The next action is a Compose step. This is needed to strip out some values from the Registration ID. It’s stored with an ER and then a space. This means when we try and pass it, it adds a gap which breaks any URL’s. So we need to strip out the first 3 characters to just leave us with the ID part of the Registration ID. We can then add in the ER and a plus sign later which will make a full URL without breaking anything. So, in your compose step, click on Expression and add in the following:

substring(triggerOutputs()?['body/msevtmgt_name'],3)

Now we need an Initialise variable step to create a unique join link. This is not stored anywhere, which is why we need to piece things together to generate it. For this, give your variable a name and select the type of String. Then we piece the string together like this. If you have named your steps the same, you should be able to just paste the expression below directly in to the value box. This pulls the Marketing org id (using the first approach as above rather than Apply to each), the output from the registration id step and the teams url value from the Event.

https://@{first(body('Find_Org_Id')?['value'])?['_organizationid_value']}.svc.dynamics.com/EvtMgmt/api/v2.0/checkin/stream?eventRegistrationId=ER+@{outputs('Remove_First_Part_Of_Registration_ID')}&sessionRegistrationId=&redirectUri=@{outputs('Get_Related_Event')?['body/msevtmgt_attendeeurl']}

For the next step, another Initialise variable step as a string. Only needed if you want to add a QR Code. I am not sure I see the point if it is an online webinar, but I wanted to show you how to get it just in case. For this one, your URL should look like this, with the endpoint value, some extra parts that are needed in the URL, and then at the end add the Registration ID from the trigger at the start of your flow.

@{first(body('Find_Org_Id')?['value'])?['msevtmgt_publicendpoint']}/EvtMgmt/api/v2.0/qrcode?code=@{triggerOutputs()?['body/msevtmgt_name']}

The next step is to create the ICS calendar event file. Thanks to Manuel Gomes for his blog post on this which gave me the starting point I needed. I was then able to figure out how to make the description of the ICS file pretty with HTML, including adding in an image. If you’ve named your steps the same as mine you should be able to copy and paste the information below and use it in your step. If not, just pay attention to the formatting of the date/time stamps that need to have the Z added after them in order to work. Notice that I have a DESCRIPTION part and then an X-ALT-DESC part which includes HTML. You don’t need both, but the HTML part will show in Outlook and looks great. The main DESCRIPTION is used by Google when importing a calendar ICS file. If you want to show an image, make sure you put the link to YOUR image in that section.

BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
UID:@{outputs('Remove_First_Part_Of_Registration_ID')}
DTSTAMP:@{formatDateTime(utcNow(), 'yyyyMMddTHHmmss')}
DTSTART:@{body('Convert_Start_Date_Time')}Z
DTEND:@{body('Convert_End_Date_Time')}Z
PRIORITY:3
SUMMARY:@{outputs('Get_Related_Event')?['body/msevtmgt_name']}
DESCRIPTION:@{outputs('Get_Contact')?['body/firstname']}, thanks for registering for the @{outputs('Get_Related_Event')?['body/msevtmgt_name']} webinar\n\nInformation about the event, including your unique joining link, can be viewed below.\n\n@{outputs('Get_Related_Event')?['body/msevtmgt_description']}\n\n@{variables('Unique Join Link')}\n\nDO NOT FORWARD THIS INVITATION - THE LINK IS UNIQUE TO YOU
X-ALT-DESC;FMTTYPE=text/html: <html><body><b>@{outputs('Get_Contact')?['body/firstname']}, thanks for registering for the @{outputs('Get_Related_Event')?['body/msevtmgt_name']} webinar. Information about the event, including your unique joining link, can be viewed below.</b><p>@{outputs('Get_Related_Event')?['body/msevtmgt_description']}<br><br>@{variables('Unique Join Link')}<br><br><b><i>DO NOT FORWARD THIS INVITATION - THE LINK IS UNIQUE TO YOU</i></b><br><img src="LINK TO YOUR IMAGE" alt="Alt Description for accessibility"></body></html>
LOCATION:Online
CLASS:PUBLIC
BEGIN:VALARM
DESCRIPTION:REMINDER
TRIGGER:-PT15M
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

Now we get in to the part of this second flow that will link to the SharePoint folder created in the first flow. Add the create new folder action from the SharePoint connector. Pick the same site address used in flow one, and the Documents library (or whatever you picked before). Now you can set the folder path to use the Event GUID first (which means it will put your new folder in the folder created in flow one for the Event) and then the Event Registration GUID.

Now we need to take the ICS file contents and actually create that as a file in the new folder created in SharePoint for this specific Event Registration. We pick the same site, and can then use the Full Path value from the step above. The file name can be anything, but I have just called it the name of the Event then .ics to give it the right extension. The File Content is going to be the variable for the ICS File Contents we created above.

The next step is the Get file properties action from SharePoint. Set the Site Address and top level library name (same one you used in the other steps) and use the ItemId as the ID from the step above.

The last step from the SharePoint connector is to make a link to it that is accessible outside your organisation. Use the action of Create sharing link for a file or folder. Again, set the site address and library name the same as you have used in previous steps. Use the ID from the previous step as the Item Id, set the Link Type to View only and the Link Scope to Anyone with the link, including anonymous. You can also expand the advanced options and add a link expiration adding the Event end date as when it will expire.

Now the last step, putting it all together and starting the custom trigger so the Contact who registered will be put in to a Journey. Choose the Perform an unbound action from the Dataverse connector. Then in the list of actions, scroll to those that start with msdynmkt_ and then look for the new one you created. Once you select it, you will see all of the variables you added. Now you can start populating them with dynamic values. We have the description, Event end date, BLOB CDN URL for the event image, Event name, Event start date, Event time zone, your QR Code Image variable, the Sharing Link from the last step, and Unique Join Link variable. For the Sharing Link, add ?&download=1 to the end of it. This will make it a file that downloads automatically when the button is clicked in the email, rather than taking the person to your SharePoint site. For the signal ingestion timestamp and signal timestamp, past in @{utcNow()}. For the signal user authid and profileid, use the Contact id from the Get Contact step added near the start of the flow. Phew! That’s all the steps. It might seem like a lot, but keep in mind I’ve shown you step by step to hopefully explain everything to make it clear.

Create Column To Save ICS File

This part again is optional. I thought it might be useful for a D365 Marketing user to have access to the ICS file that gets generated without having to go and hunt for it in SharePoint. That way if the Contact gets in touch and says the didn’t get the email, it can still be accessed and sent to them. For this, add a new column to the Event Registrations table. Set it as a File type and make sure you open the Advanced options area to increase the max file size. 131072 is the largest it can be.

Add this step in to the end of the second flow you created. Choose the up a file or an image from the Dataverse connector and set the table name as Event Registrations. Set the row id as the Event registration id from the original trigger step. You should then see your file column in the list. Expand the advanced options, and now set the ICS File Contents variable as the content, and use the Event name dynamic value and then .ics to give it the right file name.

Now when someone registers and they reach the end of the flow, the file will be added to their Event Registration record. Easy to access and download if needed. Keep in mind that you might want to have some process of cleaning up these files at the end of the event, so up to you how you want to manage it.

Create Your Real-time Journey

Finally we get to the end and can create the Journey to kick things off. You can build this as simple or complex as you would like. In this example I just have two steps, the trigger and the email. First, we got to the Journeys section in the Real-time marketing area to create a new one. Give your journey a name, and then make sure the type of journey is trigger-based. Then pick the new trigger you created from the list. Click on the Create button.

Now we can add a step and select to send an email. Pick the email you created earlier as what you want to send.

Create An Event Registration

Now fill out your form! You need to make sure it all works. Once you have completed the form, wait a few moments. The event registration will kick off your flow which needs time to run, and then drop the Contact in to the Journey at the end. Then the Journey needs time to push the Contact through. So it won’t be seconds but it should be at least within 5 or 10 minutes. You should get your email.

Here we can see the first part of the email that has used the image from the event, along with the event title and times including the timezone. We then see the description and a button that has a unique link that when clicked on will take the Contact in to the event in Microsoft Teams.

Scrolling down, there is also the Add To Calendar button and the QR Code (again, only if you feel it adds value for your requirements).

Clicking on the Add To Calendar button, you should then see your ICS file download.

Open up the ics file and check the details. It should be all about the webinar you registered for. Hooray! This can then be saved by the recipient to add it to their calendar so they don’t miss your event. Perfect.

---

Check out the latest post:
Auto Assign Leads Without Code Using Lead Scoring & Work Assignment