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 / Add Blank Value to Dro...
Power Apps
Answered

Add Blank Value to Dropdown

(0) ShareShare
ReportReport
Posted on by 9

Hi,

I try to add a Blank entry to my Dropdown.

 

I have a SP List with a Personcolumn for Projectmanagers.

In Powerapps i have a Collection ->colProjektleiter that runs on Startup

 

 

ClearCollect(
 colProjektleiter;
 ShowColumns(
 AddColumns(
 Projektliste; "Email"; Projektleiter.Email);"Projektleiter")
 )

 

 

 

on the Dropdown i have on Items a Distinct function so i only see 1 Entry of each Project Manager:

 

 

Distinct(
colProjektleiter;Projektleiter.Email)

 

 

 

Above the Dropdown i have a Textfield where the current User Email is shown.

 

Now my Gallery is filtered as followed:

 

 

If(
 IsBlank(drpCurrentUserProjektdaten);
 Filter(
 [@Projektliste];
 Projektleiter.Email = User().Email
 );
 Filter(
 [@Projektliste];
 Projektleiter.Email = drpCurrentUserProjektdaten.SelectedText.Value
 )
)

 

 

 

So if the Dropdown is Blank, it takes the current User, if something is chosen in the Dropdown it takes that value.

This is so the Projectmanagers can on demand also Edit a Project from a Coworker.

 

This all works fine. the issue is, once something is chosen on the Dropdown, you cant go back to the Blank state.

 

Nebucadnezza_0-1624284205405.png

 

I tried to use the default Value on the Dropdown to be User().Email

This works in the Browser but not when i run the App in Teams.

 

If it i could get it to work in Teams so the Dropdown always uses the Current User as Default, this would make it much easier.

Thank you for your help

Categories:
I have the same question (0)
  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Nebucadnezza It would be better to get the User().Email into a global variable in the OnStart of the App and use this variable in the default property of the dropdown.

    Further, to make the dropdown blank, the user has to select the selected option again!

  • Nebucadnezza Profile Picture
    9 on at

    @CNT 

    Hey, thank you for your Input.

    I didnt know about the double Selection in the dropdown. i Think i can work with that for now since im a little under Timepreassure

     

    since i learn what to do as i go, maybe you can give me an example on how i would get global Variable with User().Email OnStart?

    i have multiple Collections but i havent touched variables yet.

     

    would it be something like this?

     

    Set(varUserMail,User().Email)

     

    Sidenote:

    I also learned during thatProject that my SP list needs to be reworked .Basicly its one big list with about about 50 Columns, i want to transfer this to Dataverse at some Point so i can work with multiple apps that share the same Data.

  • Moreshwar Profile Picture
    135 on at

    There is a property AllowEmptySelection of dropdown. Setting its value to true will help you select blank as well.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Nebucadnezza The way you are setting the variable is correct. Moving to Dataverse is a very good idea. Having 50 column is not a great idea though. Please read a bit on database normalisation before you finalise your tables, columns and the relationships.

  • Nebucadneza Profile Picture
    3 on at

    @CNT  Thanks i will try the thing with the variable

     

    About the 50 colums, thats currently in SP List

    I would probably make alot of tables with few Colums instead of the SP List is what i ment 🙂

    I will have to read alot about databases in order to understand how i can achieve my goals.

     

    maybe you can share a few good links to start with?

     

    thanks for your help, much appreciate it

  • Verified answer
    CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Nebucadneza some links for you,

    https://www.youtube.com/watch?v=xoTyrdT9SZI

    https://www.youtube.com/watch?v=l5DCnCzDb8g

    https://www.javatpoint.com/dbms-normalization

     

    Please remember to give a 👍 and accept the solution as it will help others in the future.

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

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard