cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Resolver III
Resolver III

To overcome Pagination limits how could I write the following "Filter array" action in the form of an ODATA filter query?

To overcome Pagination limits how could I write the following "Filter array" action in the form of an ODATA filter query?

Screenshot 2020-11-03 064518.png

1 ACCEPTED SOLUTION

Accepted Solutions

I ended up modifying the workflow to use an ODATA query using already known information from a SharePoint table.

View solution in original post

3 REPLIES 3
Paulie78
Super User
Super User

Try this:

subject eq 'SearchCriteriaHere'

Replace SearchCriteriaHere with your ESN Ticket number. 

 

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

This would be correct if I already had an input to enter there, but I don't. If you look at my Filter array I am saying "Only return the ESN Ticket Number entry if a match is found in the subject somewhere". Currently the email subjects don't come in consistently so its hard to do this with split (last, first).

 

If I had a consistent subject format to work with I'd just split it out and use that with the ODATA filter, but in this case I don't have that convivence yet.

I ended up modifying the workflow to use an ODATA query using already known information from a SharePoint table.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,668)