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

ODATA Filters - are these implemented yet?

Is ODATA Filtering implemented yet? I see posts from June saying that it's not, and a post from August from a person who was able to use ODATA Filters.

 

However, it is not clear to me HOW to use the filters. I've been playing around with them and the syntax needed in the context of Flows is not clear.

 

My flow: https://flow.microsoft.com/manage/flows/c178b321-c618-4e1f-a680-65d443f2bf96

 

The results from Get Rows from a Google Sheet:

Body

{
    "value": [
       { "@odata.etag": "", "ItemInternalId": "ftH9OB_-Kt4", "First Name": "Jim", "Last Name": "Rickles", "Company": "Real Doctor", "Email": "fake@doctor.org", "__PowerAppsId__": "ftH9OB_-Kt4" },
       { "@odata.etag": "", "ItemInternalId": "r0hcEcMZoGM", "First Name": "", "Last Name": "fcsda", "Company": "don't take me", "Email": "", "__PowerAppsId__": "r0hcEcMZoGM" }
    ]
}
 
The filter I've applied should be filtering out the "don't take me" value:
Filter Query
length(Company) gt 0 and length(Email) gt 0 and length(First Name) gt 0 and length(Last Name) gt 0
 
It's not clear if I need to add quotation marks around the value variables, e.g. length("First Name"). Do I need to add "filter=" to the beginning of the field? Do I need to add value() or value. to prepend the column variables or brackets around the variable name, e.g. length(value()[First Name])? What is the correct format for accessing a variable?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Automate
Power Automate

Re: ODATA Filters - are these implemented yet?

ODATA filters are not implemented yet by all connectors.  Certain connectors -- like Salesforce, SQL, CRM do support it.  But, others, like Excel, GoogleSheets, do not support it.  Even then, the set of filters supported differ from one connector to another due to differences in underlyig API capabilities.

 

We hope we can provide a consistent filtering capability.  I would suggest you put in an idea in the Flow Ideas.

 

For ODATA semantics you can look up the docs at odata.org.  And you shouldnt be providing the query parameter name($filter), just the expression.

View solution in original post

4 REPLIES 4
Highlighted
Power Automate
Power Automate

Re: ODATA Filters - are these implemented yet?

ODATA filters are not implemented yet by all connectors.  Certain connectors -- like Salesforce, SQL, CRM do support it.  But, others, like Excel, GoogleSheets, do not support it.  Even then, the set of filters supported differ from one connector to another due to differences in underlyig API capabilities.

 

We hope we can provide a consistent filtering capability.  I would suggest you put in an idea in the Flow Ideas.

 

For ODATA semantics you can look up the docs at odata.org.  And you shouldnt be providing the query parameter name($filter), just the expression.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: ODATA Filters - are these implemented yet?

Thank you for the prompt response. 

 

Would it be possible to remove, disable or hide fields and features that are not implemented?

 

If non-implemented fields were grayed out and users could not interact with them, then users could see what future features are coming without productivity being lost on trying out features that do nothing.

 

I will submit this as a "feature" request as well.

Highlighted
Regular Visitor

Re: ODATA Filters - are these implemented yet?

Have these been implemented yet for Sharepoint list connections (Sharepoint Get Item)? 

Highlighted
Regular Visitor

Re: ODATA Filters - are these implemented yet?

Noting comments above about the triggers that do have ODATA filters implemented, there seems to be an issue with the Salesforce connector. Filter expressions seem to work in some situations and not others (haven't quite determined the scenarios as yet).

 

If I take an example of "When a record is created" trigger, putting a filter into the advanced parameters to limit the number of times the workflow is triggered does not seem to work.

 

Any thoughts?

Cheers

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,394)