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.
Solved! Go to Solution.
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.
columnname eq 'formatDateTime(utcNow(),'MM-dd-yyyy')'
idcolumnname eq 'formatDateTime(utcNow(),'MM-dd-yyyy')'
@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?
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.
@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
Check if the following link helps for that choice column:
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?
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!