Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

92
Views
ODATA filter fails when I try to filter by a lookup

I'm trying to modify the ODATA query (with a Power Automate Flow for what its worth)

This works. It filters the items in a SharePoint list to only show the ones with 'cat1' in the title.

{
"host": {
    "connectionReferenceName": "shared_sharepointonline",
    "operationId": "GetItems"
},
"parameters": {
    "dataset": "https://conotoso.sharepoint.com/sites/site1",
    "table": "...",
    "$filter": "substringof('cat1', Title)"
}

}

however if I try to also filter on a lookup to another list by adding in


I get 
Action 'Get_items' failed
Bad Request
Not Valid

```{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "GetItems"
    },
    "parameters": {
        "dataset": "https://conotoso.sharepoint.com/sites/site1",
        "table": "...",
        "$filter": "substringof('cat1', Title) OR Category/Title eq 'cat1'"
    }
}

Thanks P

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!