You’re offline. This is a read only version of the page.
8
Distinct(
Items=Filter(
HH_BU_Mapping,
'HH Business Unit' = Edit_HHBusinessUnit_Dropdown.Selected.Value,
'BU_Category_1 ' in Edit_BUCategory1_ComboBox.SelectedItems,
BU_Category_2 in Edit_BUCategory2_ComboBox.SelectedItems,
BU_Category_3 in Edit_BUCategory3_ComboBox.SelectedItems
),
Brand
)
This is the code for items property of combo box, it is showing me table with Value Column and it has no value that is it is empty, and the count of rows for this is also coming 1. I want that when there is no data then I should display "Other" option in the combo box. Please help.
Hi @upadharp ,
Please try below formula in Items:
Share
Report
All responses (
Answers (
With(
{
outputTable: Ungroup(
Table(
{tableObject: Distinct(
Filter(
HH_BU_Mapping,
'HH Business Unit' = Edit_HHBusinessUnit_Dropdown.Selected.Value,
'BU_Category_1 ' in Edit_BUCategory1_ComboBox.SelectedItems,
BU_Category_2 in Edit_BUCategory2_ComboBox.SelectedItems,
BU_Category_3 in Edit_BUCategory3_ComboBox.SelectedItems
),
Brand
).Value},
{tableObject: Table({Value:"Others"})}
),
"tableObject"
)
},
ShowColumns(
GroupBy(
outputTable,
"Value",
"Grouped"
),
"Value"
)
)
Best regards,
