web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Make default Drop Down...

Power Apps

Answered

Make default Drop Down value "SELECT" instead of first value found in SharePoint list

(0) Share

Report

Report

Posted on by iwonder

1,146

Thank you for taking the time to read my question.

I have a drop down in my app that has a SharePoint List column as it's Item's source.

Is there a good way of adding something like "SELECT" to the drop down as the default value so that the user has to make a choice?

I put " SELECT" into my list and then I sorted my Items for the drop down, but it seems that SharePoint won't let me put in a leading space. I don't want to have an underscore before "_SELECT" either.

I don't think it's necessary to have a second column in my list with numbers that I sort on either as items may be added or removed, and therefore make the numbers pointless.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!
I am trying this on AppStart, but is there a better way than having to store Collections?

ClearCollect(colFeedPrg,{FdPrg:"SELECT"}); ForAll(Sort(FeedProgram,Title,Ascending) As src,Collect(colFeedPrg,{FdPrg:src.Title}));

Thanks
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @iwonder ,

You could use SortByColumns() function and AddColumns() function.

Add a dropdown control and set its Items property to:

SortByColumns(AddColumns(LIST131.Title,"Number",If(Title="Select",1,Blank())),"Number",Ascending,"Title",Ascending)

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Join the conversation