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

Announcements

News and Announcements icon
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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 140 Super User 2026 Season 1

#2
Nagaraju_Matta Profile Picture

Nagaraju_Matta 128

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 70 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans