cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

oData Filter & SharePoint list

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 ?

 

4 REPLIES 4
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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.

Kudo Commander
Kudo Commander

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (9,027)