Answered

Add Blank Value to Drop down with SharePoint List Distinct

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

DrpItemType (drop down) has Items=Distinct(CHMerchandise,Title) and it works, but I'd like to add a blank value as the first option.

I also have DrpItemChosen (drop down) with

Filter(
CHMerchandise,
Title = DrpItemType .Selected.Result
)

Which I would also like to have a blank value as the first option.

I have buttons that enable/disable based on if these fields are populated, and I don't want the default values to have items selected already.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
@IPC_ahaas

In the OnVisible property of the screen put ClearCollect(itms,{Result:Blank()};Collect(Distinct(CHMerchandise,Title)) and in the Items property of the dropdown: itms or without a collection put this formula directly in the Items property of the dropdown

Ungroup( Table( {myMenuOptions: Table({Result: Blank()})}, {myMenuOptions: Distinct(CHMerchandise,Title).Result } ), "myMenuOptions" )

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

I get an error with Collect(Distinct(CHMerchandise,Title)) saying that it's expecting at least two values.

Changing it to this seems to work:

Collect(
itms,
{
Result: Distinct(CHMerchandise,Title)
}
);

While the latter code (Ungroup) works, I don't really understand what it's doing that makes it work.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@IPC_ahaas

It should be

ClearCollect(itms,{Result:Blank()};

Collect(Result,Distinct(CHMerchandise,Title))

As you figured out.

The second formula does essentially the same without the collection. For a better explanation see https://www.matthewdevaney.com/how-to-add-a-blank-value-to-a-dropdown-list-in-power-apps/

Was this reply helpful? Yes No
AlanJ88 2 on at

Like (0)

Report

Where did people get the itms from?

Was this reply helpful? Yes No
NPG87 7 on at

Like (0)

Report

i have a similar problem to solve, i have a dropdown list running 2 conditions to retrieve items for all departments or the one selected in OQ stream dropdown, but dont know how to add a blank to this list.

Below is my coding for my existing dropdown list:
Sort(
ForAll(Distinct(
// Filters any subtopics that are either area-specific or that are topic specific
Filter(
'Document List',
//Filter by either an area selected or by "All"
Or(
Stream = 'OQ Stream'.SelectedText.Value,
Stream = "All"
)
),
Title
), {Result: ThisRecord.Value}),
Result
)

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report
Here is what my final coded ended up being:

Ungroup( Table( { Items: Table({Result: Blank()}) }, { Items: ForAll(Distinct(CHMerchandise,Title), {Result: ThisRecord.Value}).Result } ), "Items" )

Hopefully that is helpful.

Was this reply helpful? Yes No