cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phoenix_cluster
Frequent Visitor

Get a notification when a date in the future comes (Dynamics 365)

Hi Guys,

 

I am looking to create an automated flow, which will send a notification (email for example) to a specified person when a date in the future arrives. The date is in Dynamics 365 under all 'Contacts' I have created. It is a date field with a date in it, always in the future. I am looking to create a flow which will automatically prompt me to do something once that date has been reached.

 

I cannot seem to find an appropriate trigger in Power Automate: Dataverse for that.

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions

Dear @phoenix_cluster ,

you should add those columns in your Fetch XML:

MarconettiMarco_0-1660647857854.png

Download the Fetch, copy and paste it in Power Automate.

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

View solution in original post

6 REPLIES 6
MarconettiMarco
Super User
Super User

Hello @phoenix_cluster ,

you should use the Scheduled flow (with Recurrence equal to 1 per Day) and, as second action add a Dataverse "List rows" action by putting the filter you want to search for. I suggest to use the Fetch XML Query.

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

MarconettiMarco
Super User
Super User

@phoenix_cluster here the Fetch XML (I grabbed the birthdate field as an example):

FetchXML.gif

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Amazing, thanks for your reply. Could you take a look at this screenshot if this makes sense? I added the email send action. I want it to include the customer full name and Unique ID, do I need to fetch it somehow in the steps beforehand? 

 

Thanks for your help.

KYC.png

@phoenix_cluster ,

in the Fetch XML query please add the fetch without the first row and without "-".

Add the code like below:

 

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="contact">
    <attribute name="fullname" />
    <attribute name="telephone1" />
    <attribute name="contactid" />
    <order attribute="fullname" descending="false" />
    <filter type="and">
      <condition attribute="birthdate" operator="on" value="2022-08-30" />
    </filter>
  </entity>
</fetch>

 

In regards of the Unique ID, are you referring to the GUID?

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

phoenix_cluster
Frequent Visitor

This is much better, it is sending indeed. Unfortunately, when I ask it to add two separate fields, it is not doing it (just leaves it blank. Please see the screenshot, the issue is that the uniqueID field in the Fetch XML is listed as srvsys_uniqueID, but in the email body it is just listed as uniqueid. Same with KYC review. Is that the issue here that it cannot 'find those fields'? If yes, can I manually specify to include the 'srvsys_uniqueID'?

Please also see how the Unique ID is presented under the 'Contact'.kyc1.pngkyc2.png

Dear @phoenix_cluster ,

you should add those columns in your Fetch XML:

MarconettiMarco_0-1660647857854.png

Download the Fetch, copy and paste it in Power Automate.

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,472)