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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
13 | |
11 | |
6 | |
6 | |
5 |