oData Filter & SharePoint list

[sergeluca]

are odata filters implemented for SharePoint list connections ? How can I make a lookup to another list and return a list item based on a filter ?

[v-yamao-msft]

Hi Sergeluca,

I create a flow to send an email when a new item is created in SharePoint Online list. In the trigger “When a new item is created”, I configure the Filter Query field with a formula. But it doesn’t work for me. It seems that Odata Filter has not been implemented. We still don’t have a timeline right now.

I find two articles for SharePoint Odata syntax for a reference:
http://www.trigent.com/blog/introduction-to-rest-api-with-odata-operators-in-sharepoint-2013/
https://msdn.microsoft.com/en-us/library/office/fp142385.aspx#bk_supported

As a workaround, you could add a condition in your flow to realize what you need. This article about “Add a condition to a flow” could be a reference for you:
https://flow.microsoft.com/en-us/documentation/add-a-condition/

Best regards,
Mabel Mao

[Vlada]

I get same results, did you figure out if we just write odata query wrong or if the flow action is bugged?

But i guess if it worked and query was written wrong it should return zero results.

Also condition is not real workaround as get item action only gets 256 or so items from the list and I would need to write custom itterator somehow.

[keldelasalas]

Same issue here. i couldn't complete the flow since it's selecting all columns so I'm getting ""The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.", this error. Tried a workaround by applying an OData Filter but that doesn't apply to the REST API Call.

[Piagno]

The filter isn't implemented yet. As an workaround you can add a loop and check the filter for each item itself.