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:
This is the error:
Ideas?
Thanks for your help.
Solved! Go to 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.
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.
Thank you, very helpful.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 |
User | Count |
---|---|
13 | |
9 | |
7 | |
3 | |
3 |