web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Check if the table has...

Power Apps

Answered

Check if the table has no value then , give an other option in the combo box

(0) Share

Report

Report

Posted on by upadharp

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.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @upadharp ,

Please try below formula in Items:

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,

Was this reply helpful? Yes No

Join the conversation