cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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:

reschedule.png

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

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

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. 

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

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

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





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




Highlighted
Helper I
Helper I

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

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. 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (9,525)