Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How do I trigger an email to be sent out based on a date in the account form

Posted on by 20

Hi all,

I want to send out a customer voice survey every 3 months after someone was been in our program for 3 months. I've made a calculated field to show the date that marks the 3 month anniversary for each person. Is there a way I can trigger an email to be sent when the 3 month mark has been hit? Would this involve creating a power automate flow?

  • Qingqing Xin Profile Picture
    Qingqing Xin on at
    RE: How do I trigger an email to be sent out based on a date in the account form

    Hi Felicia,

    You can create a scheduled cloud flow which is repeat daily to compare the calculated date with now.

    8738.Picture1.png

    Set repeat daily.

    2818.Picture2.png

    Here are some of the more important parts of the process, then just add a step to send an email. The first half of the Filter rows is the Name of calculated field.

    Picture3.png

    Regards,

    Qingqing Xin

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: How do I trigger an email to be sent out based on a date in the account form

    Hi,

    Please look at below article which is similar to your requirement with small change

    xrmdynamicscrm.wordpress.com/.../

  • Suggested answer
    Anshuman Trivedi Profile Picture
    Anshuman Trivedi 130 on at
    RE: How do I trigger an email to be sent out based on a date in the account form

    Hello Felicia,

    To Answer your question - You have create scheduled flow to run on daily basis and fetch all the records where current date is equal to the date calculated by you in calculated field once you got those records fetched you have add a action to send email notification action to your flow it will send email notification to the provided recipent.

    Please mark this as Verified if this answers your question.

    Thanks

    Anshuman

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans