How to add a text value to the drop down values which came from a SharePoint list?

(0) Share

Report

Posted on by MichaGue

235

Hi,

I am using a drop down which values are fed form a Column of a SharePoint list. Within the drop down I use:

Distinct([@lst_Demo], Countries)

Now the values of the drop down are, for example "Germany", "France", "USA", "Denmark".

Now I want to add the text "none" at the first value of the drop down list.

I tried the following:

Ungroup(
 Table(
 {DropdownOptions: ["None"]},
 {DropdownOptions: Distinct([@lst_Demo],Countries)}
 ),
 "DropdownOptions"
 )

It does not work. If I look at the value properties of the drop down now I have two choices, "value" and "result".

If I set the value property of the drop down to "value" my text "none" is visible at the drop down.

If I set the value property of the drop down to "result" the countries are visible at the drop down.

How do I make my drop down show "none" as the first value and then the "countries"?

Why do I need this? I want to use the drop down as filter for a gallery.

Thanks a lot.

Michael

Categories:

I have the same question (0)

All responses (1)

Answers (1)