'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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'ODATA filter fails when I try to filter by a lookup

Sources

Related Questions