Add an empty choice in a SharePoint "choice" Column

(0) Share

Report

Posted on by Sajarac

3,276

Hi there,

In moss of the online post say about that the way to do this is:

Go to the column drop down list in question.
At the first entry on the list do a return to create a blank space.
Inside that blank space place your cursor and press and hold down the ALT key while typing 0129 on the NUMERIC KEYPAD. ...
In the Default Entry setting do the same.
Save and you are done.

But after I have this thing implemented I am getting a square

Could someone please help me?

Thank you kindly.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

KrishnaV 5,023 on at

Like (2)

Report
Copy link

Link copied!
Hi @sajarac ,

Why do you need this ? if you want to add an empty selection in your dropdown then follow this:
on App onStart property

ClearCollect(coldropdownVal,""); Collect(coldropdownVal,Choices(SampleList.Status))

Now you refer this collection in your dropdown control as below

Items property of the dropdown control: coldropdownVal

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Sajarac 3,276 on at

Like (0)

Report
Copy link

Link copied!

Hi bud, thank you very much for your prompt reply.
I need this because for instance I have several “choice” columns in my share point list.

Now in my app let’s say I have a drop down with 3 options
Blue
Yellow
Orange
now my choice is orange, so orange selected and saved. But if I change my mind and I don’t need a selected color, there is no way to leave the drop down empty.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

Hi @sajarac ,

I got you in such a case please add a blank space to the dropdown by changing the approach. I don't suggest you to add a blank at the SharePoint list level.
If not add the below values as choice fields in the list column:
--Select--
Blue
Yellow
Orange

Now you will have --Select-- remove the color from user selection.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
AC-16100139-0 Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @sajarac,

Thanks for raising this question.

The following PowerApps Idea has also been posted with regards to dropdown control has no blank option:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Drop-down-control-has-no-blank-option/idi-p/20016

If you configure a combo box to disable searching (IsSearchable = false) and to be single-select (SelectMultiple = false) it should be fairly similar to a dropdown, with the advantage of being able to click on an "x" of the selected item pill to remove that item and have a blank selection.

Keep us posted as to how you get on with the options provided to-date.

Cheers,

Allan

Was this reply helpful? Yes No
Sajarac 3,276 on at

Like (0)

Report
Copy link

Link copied!

@ACahill, Hi there.
I did a quick work around for this and is working, not applicable to all the fields "I mean Choices" are not supported I guess.

What I did, I have created an Edit form connected with my SharePoint List, in the form I have added a new record "Empty" and then submitted back to the list. the only thing is that the list cannot have any field as required. After that I have an empty record and now I have a blank space in my combobox.

Thanks for your help, I have voted for that idea!

Was this reply helpful? Yes No
AC-16100139-0 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sajarac,

Thanks for letting us know your workaround and for voting for the idea, most appreciated.

Cheers,

Allan

Was this reply helpful? Yes No
Scanners 2 on at

Like (0)

Report
Copy link

Link copied!

doesnt work puts an ASCII charactor in that looks like a rectangle

Was this reply helpful? Yes No