Power Automate 中 CDS的 filter

在flow中, 我们可以用ODATA来传query来筛选我们需要的内容

 

 

 

 

支持的filter query 公式

Operator	Description
eq	Equal to
ne	Not equal to
contains	contains
not contains	Does not contains
gt	Greater than
lt	Less than
ge	Greater than or equal to
le	Less than or equal to
and	and
or	or
startswith	Start with the specified value
endswith	End with the specified value

 

Contains

contains(textfieldschemaname,’value’)

 

Contains data (is not blank)

textfieldschemaname ne null

 

 

Does not contains

not contains(textfieldschemaname,’value’)

 

Does not contains (Is Blank)

textfieldschemaname eq null

 

Contains (Does not contains) for Option Set

optionsetfieldschemaname eq optionsetnumericvalue

optionsetfieldschemaname ne optionsetnumericvalue

 

 

Contains with "OR", "AND" 

contains(field1name,’value1′) or contains(field1name,’value2′)

optionsetfieldname1 eq optionsetnumericvalue1 or optionsetfieldname1 eq optionsetnumericvalue2



contains(field1name,’value1′) and contains(field1name,’value2′)

optionsetfieldname1 eq optionsetnumericvalue1 and optionsetfieldname1 eq optionsetnumericvalue2

 

 

Start with  / End with

startswith(fieldname,’startvalue’)

endwith(fieldname,’startvalue’)

 

 

Greater than / Less than

numberfield gt specificnumber

datefield gt ‘specificdate’

createdon gt ’10/08/2019 05:00′

 

datefield lt ‘specificdate’

numberfield lt specificnumber

createdon lt ’10/08/2019′