Unanswered

Syntax error at position

(0) Share

Report

Posted on by Lindsay2

Hi, I'm trying to build a flow where an email is sent when the due date comes around. Under 'list rows present in a table' and I filtered as below - my column with the dates is titled ;Request availability':

The format datetime is: formatDateTime(convertFromUtc(utcNow(),'GMT Standard Time'),'yyyy-MM-dd')

But I get this error message:

Syntax error at position 34 in 'RequestAvailability eq'2023-06-06''.
inner exception: Syntax error at position 34 in 'RequestAvailability eq'2023-06-06''.
clientRequestId: 4fb7923c-183e-4336-bec9-9ae67457bed7

Help please??

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Lindsay2

Pls give a blank space between eq & formatDateTime(convertFromUtc(utcNow(),'GMT Standard Time'),'yyyy-MM-dd') expression. It should be like RequestAvailablilty eq @{formatDateTime(convertFromUtc(utcNow(),'GMT Standard Time'),'yyyy-MM-dd')} but in your case it is:
RequestAvailablilty eq@{formatDateTime(convertFromUtc(utcNow(),'GMT Standard Time'),'yyyy-MM-dd')}

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Lindsay2 10 on at

Like (0)

Report
Copy link

Link copied!

That's brilliant thanks! I've done that and it's worked, however I am now getting this error:
Invalid filter clause: cannot find the 'RequestAvailability' column.
clientRequestId: 088a1f2c-4fe5-4394-8cd9-b506dee4fbe2
serviceRequestId: 72008b38-4163-41cb-b6fb-c243147d6c75;36bbfc53-5b94-45f0-9c10-8720d4846c4b;661df154-5f06-4da4-9af9-5881c6acee87

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Lindsay2

You need to type the internal name of the SharePoint column. To find that, go to List Settings:

Next, Scroll down to Columns section and click on the column whose internal name needs to be find out. Lets says for column 'ParticipateDate'. Internal name will be shown in the site URL as the value of query string parameter 'Field' (after = symbol):
Replace RequestAvailablilty with the internal name in "Get item" action and run the flow to test the results.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Lindsay2 10 on at

Like (0)

Report
Copy link

Link copied!

Many thanks! Unfortunely this isn't working for me - my column isn't coming up 😞

Was this reply helpful? Yes No