cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drewcarousel
Frequent Visitor

OData filter help

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?

 

drewcarousel_0-1607422113112.png

thanks,

Drew

1 ACCEPTED SOLUTION

Accepted Solutions
ManishJain
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,370)