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 Apps
Unanswered

undefined

(0) ShareShare
ReportReport
Posted on by 67

i have combobox which uses the formula 

Distinct(Filter(Positions, Status.Value <> "Closed without Hiring" && Status.Value <> "Hired"), Title)
. This shows me all position names in the dropdown  but i want a one more row in this which is of "All Position" , so that if i click can on that it should show combine data of all position else if i select particualr position from combobox then it should show particular records only .
Categories:
I have the same question (0)
  • mmbr1606 Profile Picture
    14,629 Super User 2026 Season 1 on at

    yoi could try this onvisible of screen:

    ClearCollect(
     ColPositions,
     [{Title: "All Positions"}],
     Distinct(
     Filter(Positions, Status.Value <> "Closed without Hiring" && Status.Value <> "Hired"),
     Title
     )
    )
    
    

     

    and set the items property of your combobox to:

    ColPositions

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Mitanshu Profile Picture
    1,656 Moderator on at

    You can combine table as below:

     

    Table(
    Distinct(
    Filter(Positions, Status.Value <> "Closed without Hiring" && Status.Value <> "Hired"), 
    Title
    ),
    {Value:"All Position"}
    )

     

    If in code above with Value doesn't work, then try {Result:"All Position"} or {Title:"All Position"}.

     

    This will put "All Position" at the end of your Combobox.

     

    Assuming you are using this ComboBox to filter gallery , then you will have to modify the formula for Item Property in your Gallery

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard