Hi there,
I have an issue with Send an email (V2).
It seems that there is an issue with a dynamic filter for date as static date is working and email is being sent.
However, I don't understand the problem as I have already checked with Chat GPT, if its set correctly.
I have an excel table on one drive - > file selected -> table selected -> Filter Query -> Month2 eq ' formatDateTime(utcNow(), 'MMMM') ' -> referring to column I need data from. This should be the current month.
My time zone is Central Europe.
With the static date "August" I get the email sent, but with this formula not sure what is wrong.
Please advise.
Thanks.