Skip to main content

Notifications

Community site session details

Community site session details

Session Id : if1B5eBCztX1BZT1HZt1y4
Power Apps - Building Power Apps
Answered

Drop-down: Need to add "Please Select" to drop-down

Like (0) ShareShare
ReportReport
Posted on 1 Feb 2023 00:27:20 by 101

I have a drop down pulling from a SharePoint list.  The default value of the drop down is set to the first user listed in the drop down.  Does anyone know how I can add "Please select" to the drop-down.

 

This is the data that I have under Items:

Sort(Filter('Contacts List', 'Variance Approver'.Value="MfgEng" ||'Variance Approver'.Value="QA"),Title,Ascending)

 

 

  • MicroMarc365 Profile Picture
    101 on 01 Feb 2023 at 15:03:26
    Re: Drop-down: Need to add "Please Select" to drop-down

    That worked! Thank you so much!

  • Verified answer
    v-bofeng-msft Profile Picture
    on 01 Feb 2023 at 01:23:09
    Re: Drop-down: Need to add "Please Select" to drop-down

    Hi @MicroMarc365 ,

     

    Please try:

    Ungroup(
     Table(
     {Value:Table({Title:"Please Select"})},
     {Value:Sort(Filter('Contacts List', 'Variance Approver'.Value="MfgEng" ||'Variance Approver'.Value="QA"),Title,Ascending)}
     ),
     "Value"
    )

     

    Best Regards,
    Bof

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 58

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 42 Super User 2025 Season 1

Overall leaderboard
Loading started