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}}
After applying the JSON:
{
"colors": [
{
"name": "red"
},
{
"name": "green"
},
{
"name": "blue"
}
]
}
We have this result:
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