workbookFilterCriteria

Azure ADCollaborationContactsDocumentsEmailGraphIdentityMicrosoftOffice 365PresentationsProductivitySpreadsheetsT1Tasks

Properties

Name	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	object	An icon applied to a cell via conditional formatting.
operator	string	An operator in a cell; for example, =, >, <, <=, or <>.
values	object	The values that appear in the cell.
@odata.type	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookFilterCriteria",
  "title": "workbookFilterCriteria",
  "required": [
    "@odata.type"
  ],
  "type": "object",
  "properties": {
    "color": {
      "type": "string",
      "description": "The color applied to the cell.",
      "nullable": true
    },
    "criterion1": {
      "type": "string",
      "description": "A custom criterion.",
      "nullable": true
    },
    "criterion2": {
      "type": "string",
      "description": "A custom criterion.",
      "nullable": true
    },
    "dynamicCriteria": {
      "type": "string",
      "description": "A dynamic formula specified in a custom filter."
    },
    "filterOn": {
      "type": "string",
      "description": "Indicates whether a filter is applied to a column."
    },
    "icon": {
      "anyOf": [
        {
          "$ref": "#/components/schemas/microsoft.graph.workbookIcon"
        },
        {
          "type": "object",
          "nullable": true
        }
      ],
      "description": "An icon applied to a cell via conditional formatting."
    },
    "operator": {
      "type": "string",
      "description": "An operator in a cell; for example, =, >, <, <=, or <>."
    },
    "values": {
      "description": "The values that appear in the cell."
    },
    "@odata.type": {
      "type": "string"
    }
  }
}