Dataverse table if due date is equal today send email reminder

[FelipePanza]

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.

[Sundeep_Malik]

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')'

[FelipePanza]

@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?

[abm]

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

[FelipePanza]

@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]

@FelipePanza 

Check if the following link helps for that choice column:

https://powerusers.microsoft.com/t5/General-Power-Automate/Choice-column-in-dataverse-is-showing-up-...

[abm · Accepted solution]

Hi @FelipePanza 

Please see my YouTube tutorial.

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

Thanks

[PP4Sharon]

@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]

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

[Sundeep_Malik]

@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?