Hi @BenDaneliuk. Would it be available to filter the SharePoint lists with Condition under Microsoft Flow? Add a condition to a flow. Currently OData filters are not implemented yet by all connectors. See the response from SameerCh in the following thread. ODATA Filters - are these implemente d yet? But the filter query works for SharePoint lists.
Power Query Odata Filter List Of Items 2016
Hey Animal,You can definitely do this and it's a great idea too for the reason that you mentioned: Server-side filtering is faster, especially when the amount of data in Acumatica is very large.Let's say that I have the following Generic Inquiry in Acumatica. And I want to access that data in Excel.I can use the following URL to access the Generic Inquiry (notice that ALL of the data appears): note in the screenshot above that any spaces in field names get removed by OData so I had to reference VendorID rather than Vendor ID.If I want to only see Mr.
Peter Lai (EP00000022), then I can add some stuff onto the end of my URL like this (note how now only one record is returned): eq 'EP00000022'Maybe I don't want to see Vendors with a Status of Inactive. If that's the case, then I can do this:ne 'Active'Or maybe I have the following Generic Inquiry in Acumatica. Which looks like this in Excel:Now, suppose I want to only show documents that are larger than $2,000. I can do this: gt 2000Note: for Greater Than use gt, for Greater Than or Equal use ge, for Less Than use lt, for Less Than or Equal use le.You can also combine filters. Maybe I want to see all documents than are between $2,000 and $3,000.
Odata Filter Query Sharepoint
I can do this: ge 2000 and DetailTotal le 3000There are more filters available in OData ( ), but as far as I can tell, Acumatica hasn't implemented them yet.