web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / 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) ShareShare
ReportReport
Posted on by 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.


I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard