How to use filters in excel

Could you clarify how to use filters inside excel file.

Hello @davrans,

Firstly, add this condition to some place inside the excel template

{{filteredColors = colors|filter(value.name != “green”)}}

Then add the tag

  • {{filteredColors.name}}

image

After applying the JSON:

{
  "colors": [
    {
      "name": "red"
    },
    {
      "name": "green"
    },
    {
      "name": "blue"
    }
  ]
}

We have this result:

image

The same manner it works in DOCX and PPTX templates.

Best regards,
Petr
Plumsail team

How to do it if I have an array of

{
  "colors": [
    {
      "name": "red"
    },
    {
      "name": "green"
    },
    {
      "name": "blue"
    }
  ]
}

Hello @davrans,

I described how to use it with the array in my reply above.

Best regards,
Petr
Plumsail team