Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

ODATA syntex for a power Automate

No idea if this is the correct place to post this.  I work with powerApps.  I have to get a subset of records from a sharepoint list.  Due to delegation in PowerApps, I know I can't do this with nati...
pstork1's avatar
pstork1
Frequent Visitor
2 years ago

Unfortunately, SharePoint doesn't support he use of OData queries using the EndsWith() function. It supports StartsWith(), but not EndsWith(). In Power Automate you can use paging to get all the items from SharePoint and then use a Filter Array action to filter them by EndsWith.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Man I feel like I only run into limitations working with power Apps...  Thanks for the response.  The list can be very large, I would expect a filter array step would take too much time iterating over each record.  If the ODATA Filter query can I used contains?  I've tried writing this in ODATA syntax but can't get it to work.