OData filter help

[drewcarousel]

Dear Community,

I have a view in Dynamics which i want to send out on a weekly basis - looking online it seems the best way to do this is to create a list of records in flow & then create an HTML table off of the data. I'm not familiar with ODATA filtering and so cannot replicate the filters I have in place for my view - please can you help me replicate the below in ODATA syntax?

thanks,

Drew

[v-litu-msft]

Hi @drewcarousel,

If you are using filter array action to do that, the expression should be:

@and(contains(item()?['SolutionStage'],'Text1'),not(equals(item()?['SolutionStage'],'Approved')),not(equals(item()?['SolutionStage'],'Revised')),not(equals(item()?['SolutionStage'],'Contract approved')),not(equals(item()?['OnHold'],'Yes')),equals(item()?['Status'],'Open'))

Some texts are not completed, you should perfect them.

If you are using ODATA filter array in the Dynamic action, you could refer to this table:

Operator	Description	Example
Logical Operators
Eq	Equal	/Suppliers?$filter=Address/City eq 'Redmond'
Ne	Not equal	/Suppliers?$filter=Address/City ne 'London'
Gt	Greater than	/Products?$filter=Price gt 20
Ge	Greater than or equal	/Products?$filter=Price ge 10
Lt	Less than	/Products?$filter=Price lt 20
Le	Less than or equal	/Products?$filter=Price le 100
And	Logical and	/Products?$filter=Price le 200 and Price gt 3.5
Or	Logical or	/Products?$filter=Price le 3.5 or Price gt 200
Not	Logical negation	/Products?$filter=not endswith(Description,'milk')
Arithmetic Operators
Add	Addition	/Products?$filter=Price add 5 gt 10
Sub	Subtraction	/Products?$filter=Price sub 5 gt 10
Mul	Multiplication	/Products?$filter=Price mul 2 gt 2000
Div	Division	/Products?$filter=Price div 2 gt 4
Mod	Modulo	/Products?$filter=Price mod 2 eq 0
Grouping Operators
( )	Precedence grouping	/Products?$filter=(Price sub 5) gt 10

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

[ManishJain · Accepted solution]

Hi @drewcarousel ,

If you are connecting to D365 , List Records action has option of attaching fetch xml . Go to advanced find and download the fetch xml from there and add it to Fetch XML Query parameter of List Records action.

Thanks