Edit

Share via

workbookFilterCriteria resource type

  • Article

Namespace: microsoft.graph

Represents the filtering criteria applied to a column.

Properties

Property Type Description
color String The color applied to the cell.
criterion1 String A custom criterion.
criterion2 String A custom criterion.
dynamicCriteria String A dynamic formula specified in a custom filter.
filterOn String Indicates whether a filter is applied to a column.
icon workbookIcon An icon applied to a cell via conditional formatting.
operator String An operator in a cell; for example, =, >, <, <=, or <>.
values Json The values that appear in the cell.

JSON representation

The following JSON representation shows the resource type.

{
  "color": "String",
  "criterion1": "String",
  "criterion2": "String",
  "dynamicCriteria": "String",
  "filterOn": "String",
  "icon": {"@odata.type": "microsoft.graph.workbookIcon"},
  "values": {"@odata.type": "microsoft.graph.Json"}
}