Notice email based on a date

[Guicord101]

Hi guys!
I have a spreadsheet with two columns:
Email and Date.
I would like the flow to read the date and send a notice 120, 90, 60 and 30 days before that date to the respective email
Example:
gui@automate.com.br (column 1) 05/31/2022 (column 2)

On 05/01/2022, an email must be sent to gui@automate.com.br
Is it possible to do that?
I tried this:

My code is: 

adddays(utcNow(),-2,'dd-MM-yyyy')

And error is:

My database:

[ScottShearer · Accepted solution]

@Guicord101 

Your filter query is not formatted properly and you are using the wrong date format in the filter.  See my example below.  In my example I add one day (you add two) to the current date.  The single quotes in my filter query are required.  My date column is called MyDate - you can't have spaces in the column names.  You can use the expression in my Compose action in the body of your email.

[Guicord101]

Sorry, but I don't understand what you did.
I thought of making the flow like this:
Comparing the table date with the current date discounting 9 days, it looks like this:

However, that doesn't work either. I believe it's because it's not listing the "date" column correctly, look at this:

Apparently the stream can't pull in the "date" format

[ScottShearer · Accepted solution]

@Guicord101 

You don't need your condition if you use a filter query as in my example.  If you want the date to be 9 days before today, substitute the -9 for the 1 in my addDays() expression.  Also, note that I use yyyy-MM-dd in my filter.  That is required because you have to specify ISO 86-1 format.

If you follow my example it will work for you.  Use a Recurrence trigger instead of my button trigger.  Substitute a send email action for my Compose action but use the expression in my Compose action to format the date in your email.

[Guicord101]

Thank you very much!! You helped me a lot, it worked!