Answered

Blank value in Dropdown

(0) Share

Report

Posted on by vshah804

Hello Team,

I have SharePoint online list column as the data source for my dropdown control. In the SPO List, I have added the blank row (Last row) so that I can see distinct values in the dropdown (Please let me know if there is a better way to do it). The issues, i see blank value in the drop down but It's last, I would like to have it first in my dropdown list. I tried sort but didn't help.

FYI I don't want to use collection.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@vshah804

Do you really want it to be blank or a "Choose" option?

Is this actually a Dropdown or is it a ComboBox? If it is a Dropdown, you can also utilize the "AllowEmptySelection" property of the control.

In general, putting a blank value in your list is not needed and can cause your app to break if someone in the future sees it and things it is there by mistake and deletes it. It is best to handle the logic you want in the app directly and not have the data try to drive a behavior.

Was this reply helpful? Yes No
vshah804 43 on at

Like (0)

Report

@RandyHayes - I like to have Blank value to choose. Please help. Thanks.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report
@vshah804

Sure thing.

First I would ditch the blank value in your SharePoint list, you don't need it.

Next, on the Items property of your Dropdown, set the formula to the following:

With({listItems: yourSharePointList}, ForAll( Sequence(CountRows(listItems)+1), {Value: If(Value-1 = 0, Blank(), Last(FirstN(listItems, Value-1)).yourColumnName)} ) )

In the above formula you will need to substitute:

1) The name of your SharePoint list where indicated. Or, if you are using a Filter, that filter statement.

2) The name of your column in the list that you want displayed in your Dropdown where indicated.

This will give you a collection-less dynamic dropdown with the first item being a blank option.

Was this reply helpful? Yes No