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.
