[LogicApps/Flow] Odata operators for Odata query

[Updated on September 8, 2020]

Hi Folks,

While working on Logic apps and Flow we need to apply a different filter on Odata query to get the desired data from an Odata entity. Below are the most used operators to use in an Odata query with example. 

The operators supported in the expression language are shown in the following 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

For details refer below link 

Open Data Protocol (OData)

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

This post is referring to https://www.odata.org/.

QuickFix-9: Dynamics 365 Talent: Attract and Dynamics 365 Talent

Dynamics 365 Talent is now Dynamics 365 Human Resources

New updates are on the way for D365 Talent, checkout below links

Building a more successful workforce with Dynamics 365 Human Resources

Announcing changes to Dynamics 365 Talent

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

[Logic Apps] Define parameter null-able.

Hi Folks,

When we define parameters in a Logic apps by default they need a value to be passed by calling object. If you want to make a parameter to accept null value as well then define them as below.

default declaration:

{
    "properties": {
        "packageName": {
            "type": "string"
        }
"type": "object"
}
}

Allow null value:

{
    "properties": {
        "packageName": {
           "type":["string", "null"]
        }
"type": "object"
}
}

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta