Forum Discussion

nkanda's avatar
nkanda
Data Storage
03-15-2024

Multiple Dropdown filter using BloX

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

1 Reply

Replies have been turned off for this discussion
  • 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.