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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to add an "NA" opt...
Power Apps
Unanswered

How to add an "NA" option to my dropdown list manually (the rest of the dropdown list is coming from a sharepoint list)

(0) ShareShare
ReportReport
Posted on by

Currently, I have a dropdown list that is populated from values in a column from a SharePoint list. I am looking to add an "NA" option to my dropdown list. I was asked not to include the "NA" value as part of the SharePoint list, so need to add it manually in PowerApps.

 

Currently, my "Items" section for my dropdown has the following:

 

'PPG People'.'Full Name'

 

sjoshi_0-1707330745661.png

 

AN

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,362 Super User 2025 Season 2 on at

    @sjoshi 

     

    How many rows are we talking about?

     

    If its under 2,000 and will stay that way, then use a collection, and fill it from the sharepoint list, adding in the NA.

    Also, add a Sort Column in the Collection if you want. to make sure that NA is always on Top

     

    But either way on sorting, a Collection is the best way to do what you said 


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard