Scheduled based flow with "An identifier was expected at position" error

(0) Share

Report

Posted on by MrEdward

102

Hi there,

I did my research with people with this error but the solution seems to be turning off "Explicit column selection" in advance settings on PowerApps. I tried that and it didn't work (didn't think it would work since it's not a trigger).

This is my flow layout:

and for List records odata filter, I used:

startswith(creo_entrytime, 8/04/2020)

Anyways, I'm wondering if anyone has a work around or solution to this?

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @MrEdward

Startswith can only be used in a text field.

if your field is a text field. Than add single quotes around your date in your filter

Was this reply helpful? Yes No
Verified answer

MrEdward 102 on at

Like (2)

Report
Copy link

Link copied!
Thanks for replying @Jcook.

I found out that the issue was the format, it had to be the exactly the same format as the one fetched from CDS:
formatDateTime(utcNow(),'yyyy-MM-ddT12:00:00Z')

then I used greater than (gt) and less than (lt) odata to filter out the date - that seems to work.

Was this reply helpful? Yes No