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)

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report

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