Unanswered

Syntax Error

(1) Share

Report

Posted on by VDaPonte

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!!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
VDaPonte 28 on at

Like (1)

Report

Trice602,

Unfortunately, I got the same error after changing as you suggested.

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi @VDaPonte ,

Please check your List Rows present in a table action and make sure you have turned on ISO 8601 date formatting.

Was this reply helpful? Yes No
VDaPonte 28 on at

Like (0)

Report

I already had ISO 8601 chosen

Was this reply helpful? Yes No