Hi,
I'm trying to create a multiple dropdown filters, but can't figure what I'm doing wrong to make the filters work. Any assistance will be much appreciated.
my Script
{
"type": "AdaptiveCard",
"Version": "1.0",
"style": "",
"script": "",
"title": "",
"showCarousel": true,
"titleStyle": [
{
"display": "none"
}
],
"backgroundColor": "",
"body": [
{
"type": "ColumnSet",
"spacing": "none",
"columns": [
{
"type": "Column",
"separator": "none",
"spacing": "medium",
"items": [
{
"type": "TextBlock",
"text": "Department Filter",
"weight": "bold"
},
{
"type": "Container",
"spacing": "none",
"width": "240px",
"height": "50px",
"style": {
"color": "black",
"padding-top": "10px",
"margin-left": "1px",
"backgroundColor": "white"
},
"items": [
{
"type": "Input.ChoiceSet",
"id": "data.filters[0].filterJaql.members[0]",
"class": "dropdownChoices",
"value": "",
"displayType": "compact",
"choices": "{choices:Team}",
"style": {
"color": "Black",
"font-weight": "medium",
"padding-left": "1px",
"margin-left": "10px",
"border": "2px solid grey",
"height": "35px",
"font-size": "14px"
}
}
]
},
{
"type": "TextBlock",
"text": " "
}
]
},
{
"type": "Column",
"separator": "none",
"spacing": "medium",
"items": [
{
"type": "TextBlock",
"text": "Status Filter",
"weight": "bold"
},
{
"type": "Container",
"spacing": "none",
"width": "240px",
"height": "50px",
"style": {
"color": "black",
"padding-top": "10px",
"margin-left": "1px",
"backgroundColor": "white"
},
"items": [
{
"type": "Input.ChoiceSet",
"id": "data.filters[0].filterJaql.members[0]",
"class": "dropdownChoices",
"value": "",
"displayType": "compact",
"choices": "{choices:Status-1}",
"style": {
"color": "Black",
"font-weight": "medium",
"padding-left": "1px",
"margin-left": "10px",
"border": "2px solid grey",
"height": "35px",
"font-size": "14px"
}
}
]
}
]
},
{
"type": "Column",
"separator": "none",
"spacing": "medium",
"items": [
{
"type": "TextBlock",
"text": "Mission Status",
"weight": "bold"
},
{
"type": "TextBlock",
"text": "{panel: Date"
},
{
"type": "TextBlock",
"text": "Mission Status"
}
]
}
]
}
],
"actions": []
}
What I want to achieve
Thank you
Hi @nkanda,
The code that you sent is missing the action. An action creates a button that when clicked, executes the specified action. In this case, the action type is Filters, which is a pre-built action. You can find example codes for Filters actions in the Actions tab > Action Types > Dashboard Filters (see screenshot below for reference). You can specify either the Panel Name (the name of column that you add to your BloX widget), Filter Name (the dashboard filter name), or Dimension (the dim structure of the filter column, i.e. table name, column name, data type, etc) in the action code.
You can also refer to this article for a working example: BloX - Dropdown list as a dashboard filter.
Let me know if this helps.
