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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dropdown with Custom T...
Power Apps
Answered

Dropdown with Custom Text value

(0) ShareShare
ReportReport
Posted on by Talha 72

Hi.,

I have a table that contain List of Project. each of project have project detail like (Project size, Project manager) etc.

i have listed Project manager in dropdown list with another table successfully.

Now i need to display list of project in gallery based on selected project manager in dropdown.

this was down by this command successfully (Filter('[Project_Table]',Project_x0020_Manager = Dropdown1.Selected.Full_x0020_Name))

 

what i need this the dropdown display only Manager name from sql table. i need dropdown value as follos:

All Projects

Manager 1

Manager 2

Manager 3

 

If i select all Project value, the gallery need to display all manager project if i select perticular manager then the gallery need to display specific manager project only.

 

so how can i add the "All Projects" text in dropdown list...

 

please help me to resolve this issue.

Thanks

Categories:
Building Power Apps
  • Verified answer
    NEPatton Profile Picture
    NEPatton 360 on at

    Ah - I had a similar function in my app.  I did it like this:

     

    ClearCollect(Project_Table, {Full_x0020_Name:"All Projects"}); Collect(Project_Table, datasource)

     

    So now Project_Table is a collection like:

     

    All Projects

    Manager1

    Manager2

    ....

     

    Then, use a filter function like this to get projects:

     

    (Filter('[Project_Table]',(Project_x0020_Manager = Dropdown1.Selected.Full_x0020_Name)||(Dropdown1.Selected.Full_x0020_Name="All Projects")))

     

    Does this make sense?

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans