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 Querylength(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?