cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FelipePanza
Helper II
Helper II

Dataverse table if due date is equal today send email reminder

Hi, I have a Dataverse table with a date column. How to make a flow that daily look at date column for every row in table and send a email to me.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @FelipePanza 

 

Please see my YouTube tutorial.

 

https://www.youtube.com/watch?v=KeZnMUGtBSA

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

9 REPLIES 9
Sundeep_Malik
Community Champion
Community Champion

Hey @FelipePanza 

You can make a recurrence flow, that runs every 24 hours. Then use list rows. In the filter query add the columnname, all in small letters, maybe you will be required to add an id before the column name too, id is like c1234 something.

And match that date column with today' date.

Keep the format of the both dates similar.

Filter query:

 

columnname eq 'formatDateTime(utcNow(),'MM-dd-yyyy')'

or

idcolumnname eq 'formatDateTime(utcNow(),'MM-dd-yyyy')'

 

Sundeep_Malik_0-1665148336277.png

Sundeep_Malik_1-1665148353282.png

 

 

 

@Sundeep_Malik Thanks, the problem now is that is a choice column and that give me only a number 10001, not the formatted value.

This is a Status column with 3 alternatives. 10001 equals Pending. How can I show the text in the email and not the number?

Hi @FelipePanza 

 

Believe @Sundeep_Malik, answered the question correctly.

 

So, your next question is related to choice field. To get the text you need to use the field as an expression like below. Of course you need to bind the value with body('') or item('') whichever way you are getting from the previous step. Below here aj_status is my custom option field.

 

aj_status@OData.Community.Display.V1.FormattedValue

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

@abm I have this flow: that start with

Ocurrende - List rows (3 column that I want and odata filter -7 days). 

One of this 3 columns is a choice field and I have found that the text value is in 

new_statuspaprosessenOData.Community.Display.V1.FormattedValue

Can you please show me the step to get this 3 column in an email. 

Sundeep_Malik
Community Champion
Community Champion

Hi @FelipePanza 

 

Please see my YouTube tutorial.

 

https://www.youtube.com/watch?v=KeZnMUGtBSA

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
PP4Sharon
Helper I
Helper I

@Sundeep_Malik I want the date to be [Today].  what would I put in 'formatDateTime(utcNow(),'MM-dd-yyyy')' if the date in the SP list says "5 hours ago"  

PP4Sharon
Helper I
Helper I

I need the date [Today] to be a variable of whatever the date is for Today

Sundeep_Malik
Community Champion
Community Champion

@PP4Sharon 

The expression you have written is correct for today.

But I am not really getting the part where you said the 5 hours ago thing?

Have you saved 5 hours ago in your database?

 

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!

Users online (3,960)