You’re offline. This is a read only version of the page.
28
Help
I am trying to create a flow to automate an email to run daily for reminders in an excel table based on dates. Under the "list rows present in a table" I have filtered as below- my column with the dates is titled 30 Day Reminder CPR
The format for the Datetime is: formatDateTime(convertFromUtc(utcNow(),'Eastern Standard Time'), 'yyyy-MM-dd')
I keep getting this error message:
Syntax error at position 16 in '30DayReminderCPR eq '2024-02-23''.
inner exception: Syntax error at position 16 in '30DayReminderCPR eq '2024-02-23''.
clientRequestId: 126d19a8-8132-4680-8915-1cb889061eae
HELP PLEASE!!
Hi @VDaPonte ,
I think the issue is the convert time zone here. Given you are running this once a day, remove that convert expression and use:
formatDateTime(utcNow(), 'yyyy-MM-dd')
Save and retest. If you are running this, let's say anytime in the AM from the US or Canada, the utc date is equal to today's date so converting the time zone is not needed and the formatting may be the root cause.
If you absolutely need the time zone conversion, use the convert timezone action and then refer to the dynamic content of that action in your formatDateTime expression.
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
