Trigger E-mail on Action Date within Excel Table

[XiScorpii]

I am brand new to Microsoft Flow and believe I am pretty close (from my own research) to what I want to do-- I appreciate any feedback and guidance in advance!

I am utilizing this scheduler (below) that is stored within a SharePoint site:

All three of these fields will play a role in the flow, but currently I am facing trouble in converting date values within Excel (ACTION DATE) into Power Automate. So far what I have is below:

The trigger of the entire process is that IF the 'Action Date' is today's date, then execute the e-mail. Every time I run the test, the date comes up as false and this is not the case. Deductive reasoning has led me to the fact that I am converting the date incorrectly into flow. In addition, I do not need time values accompanied by the date.

May someone please assist with this? 

[tom_riha]

I'd try to initialize 2 string variables before the condition and store both sides of the condition into them. That way you can see in the flow run history what values will enter the condition and adjust them accordingly.

[XiScorpii]

May you please elaborate? I am new to Flow so I am unsure what you are talking about, but I did try to make sense of it. 

This is my logic for what you just said:

Initialize Variable--

Name; Action Date

Type; String

Value; (Not sure what to put here)

** Then I do the same thing with today's date?

The thing with this is that I will have more than just two dates in the Action date column.

[tom_riha · Accepted solution]

So when I look again on your flow, the values in the condition don't seem right, so I'll start from the beginning. In Power Automate if you want to add a function, you need to go into the 'expressions' tab and design them there. If you just type them in as a string they'll be processed as a string. 

Then, to compare dates in Power Automate they should be in the same format which you already expected in your condition. For that there's formatDateTime() expression. On the left side, you use a dynamic content from the Excel file.

formatDateTime([Date dynamic content],'yyyy-MM-dd')

On the right side, to get today's date, Power Automate has utcNow() expression, where you can define the date format as a parameter.

utcNow('yyyy-MM-dd')

 

If for any reason the condition doesn't work, you can create the two variables with the same expressions as you're using in the condition:

1st variable value: formatDateTime([Date dynamic content],'yyyy-MM-dd')

2nd variable value: utcNow('yyyy-MM-dd')

That way you'll be able to see what enters the condition and adjust it if needed.

[XiScorpii]

Great thank you, this worked!

[gcha13]

Hello can I ask how did you get the Grab Scheduler action? I cant seem to find it in the list. 😊