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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Does Trigger Based journeys in Real time Marketing work with Caliculated fields.

(1) ShareShare
ReportReport
Posted on by 3
Hi All,
 
We are trying to trigger emails to our customers based on calculated fields (number of days remaining to their appointment date) in real-time marketing. Here we are able to perform this operation in segment-based journeys but the campaign manager wants to do this by using Trigger-based journeys.
 
Is it possible to achieve below things by using Trigger-based journeys in Real-time marketing:
  1. Triggers based on calculated field. (Ex: Emails should be triggered on 5,3,1days before the appointment day, Here the number of days to appointment is calculated field. will the trigger work on calculated fields)
  2. Control over the time emails are sent out (customer only wants to send the emails during business working hours EX: Mon-Fri 9-6:30 )
Thanks in Advance.
I have the same question (0)
  • Suggested answer
    Dengliang Li Profile Picture
    Microsoft Employee on at
    Hi,
     
    Regarding your first question, we conducted tests. The results demonstrated that triggers are applicable to calculated fields.
    The procedure of the test is as follows:
    Step 1. Select a trigger.

     
    Step 2. Add conditions

     
    1. Add the calculated field.

     

     
    1. Configure the value of the Calculated field to be equal to 1, meaning that the number of days remaining to the appointment date is 1.

     
    1. Similarly, add two more conditions and set them equal to 3 and 5.Select the Match any option.

     
    Step 3. Add the Send an email action to the journey, select an email, save and publish it.

     
     
    Step 4. Verify the test results.
    1. Create 3 contacts, and configure the appointment days field as 1, 3, and 5.

     

     

     
    1. Enter the journey and click Total flow, check who the email was sent to.

     
    1. The email was sent to the 3 contacts that match the conditions.

     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Dengliang Li

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

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
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans