AMA: Flow error

[sbibbco]

I am getting the following error when attempting to get date and time items from a SharePoint list - Unable to process template language expressions in action 'Get_items' inputs at line '0' and column '0': 'The template function 'formatDateTimeutcNow' is not defined or not valid.'.

[cwebb365 · Accepted solution]

No, you're missing the apostrophe like I said to add. See screenshot. Also remove leading space. 

[sbibbco]

That worked, thank you much, but the output looks terrible

[JamesRA]

I have the same error message on my side

[sbibbco]

James, check the syntax and make sure there are no spaces. also beware of cut and paste.

[JamesRA]

Hi sbibbco, I followed your recommendation, but I have the same problem.


I have this error message: 
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The expression \"Valid To eq '2022-06-15T17:48:29.1436051Z'\" is not valid."}}}

[cwebb365]

You need to get the actual SharePoint column name to use in the filter. You can’t have a space in the name. Go to the list settings then the column and you’ll see it in the URL. It’ll either be Validto or something like Valid_X0200_To 

then use that value instead of Valid To 

[cwebb365]

Surrounding it with ‘Valid To’ might work. Can’t remember. But either way that’s most likely the issue or at least one of them. You might still have ti formate the date time to something you can use as well if that doesn’t work that’ll be the next thing which I covered in this post already.  

[JamesRA]

Thank you so much, it worked. I change the Valid To by "Valid_x0020_To"

You are a genius 😛

[megan37]

@cwebb365 thanks for that screen shot, fixed a similar issue I was having!