2

How can I filter on multiple columns when making a web service call in a SP 2013 designer workflow? For example if this is the url for the service call then how is the $filter part different from what it is shown here for a single column:

https://mydomain.sharepoint.com/mysite/_api/web/lists/GetByTitle('MyList')/items?$filter=Column1 eq 1

1 Answer 1

3

Use the AND operator to join the filters

https://mydomain.sharepoint.com/mysite/_api/web/lists/GetByTitle('MyList')/items?$filter=Column1 eq 1 AND Column2 eq 2 AND Column3 eq 3
2
  • Thank you. I didn't think of that. I didn't see any documentation on this either.
    – Aamir
    Commented Apr 13, 2016 at 16:09
  • AND should be in small case like and
    – George
    Commented Dec 27, 2017 at 15:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.