SharePoint Get items filter query using endsWith, error 'Invalid Template'

[taramoe]

I'm attaching to a SharePoint list.  I'm trying to query a data set with one column I want to query based on how the string ends.  I'm using endsWith and am getting an error that I haven't been able to resolve.  The query works fine until I add the 'endsWith' part.

The field MeetingDateTimeText is a text field.

The full expression is: 

endsWith(triggerBody()?['{MeetingDateTimeText}'],'4') 

and I've also tried:

endsWith(Item()?['{MeetingDateTimeText}'],'4')

This is the error:

Ideas?

Thanks for your help.

[Pstork1 · Accepted solution]

Unfortunately, SharePoint only supports a StartsWith operation and I don't think that one is available for use with Odata queries.  You'll have to filter some other way and then filter further after you get the dataset.  Queries within Flow allow more options than odata.  This article is on Odata queries in REST with SharePoint, but the concepts are the same.

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...

[taramoe]

Thank you, very helpful.