在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′