You’re offline. This is a read only version of the page.
18
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
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
Hi @drewcarousel,
If you are using filter array action to do that, the expression should be:
Share
Report
All responses (
Answers (
@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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
