How to add static values to dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I have a problem with adding static values to the dropdown list. It is necessary to combine data from SP and static.

Now the Items property of the drop-down list is the value:

Filter(Maengelarten; CsGewerkTitle = ddGewerk.Selected.Value)

You need to add the following entries to the list:

Kein Mangel

Sonstige

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hello!

You can Collect this data and then add to that collection manually while you are collecting it:

ClearCollect (maengelartenDrop;
{CsGewerkTitle: "Sontige"};
{CsGewerkTitle: "Kein Mangel"};
Filter(Maengelarten; CsGewerkTitle = ddGewerk.Selected.Value).CsGewerkTitle
)

then have your dropdown with Items:
maengelartenDrop

The formula might need a bit of tweaking as I've not written any code in another spoken language, but the concept is solid.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the column value you want to display within your Dropdown control?

Could you please show more details about the data structure of your SP list?

I agree with @iAm_ManCat 's thought almost, I also have made a test on my side, please take a try with the following workaround:

Set the OnStart property of the App or OnVisible property of the first screen of your app to following:

ClearCollect( DropdownCollection; Maengelarten.ColumnName; /* <-- ColumnName represents the Column in your SP list, which you want to use as the display value within the Dropdown control (which you want to add static values to) */
{ColumnName: "StaticValue1"};
{ColumnName: "StaticValue2"};
{ColumnName: "staticValue3"};
... )

Set the OnChange property of the ddGewerk Dropdown control to following:

ClearCollect( DropdownCollection; Filter(Maengelarten; CsGewerkTitle = ddGewerk.Selected.Value).ColumnName; /* <-- ColumnName represents the Column in your SP list, which you want to use as the display value within the Dropdown control*/ {ColumnName: "StaticValue1"}; {ColumnName: "StaticValue2"}; {ColumnName: "staticValue3"}; ... )

Or

ClearCollect( DropdownCollection; Filter(Maengelarten; CsGewerkTitle = ddGewerk.Selected.Value); /* <-- ColumnName represents the Column in your SP list, which you want to use as the display value within the Dropdown control*/ {ColumnName: "StaticValue1"}; {ColumnName: "StaticValue2"}; {ColumnName: "staticValue3"}; ... )

Set the Items property of the Dropdown control that you want to add static values to as below:

DropdownCollection

The user @AccessPowerApps has faced similar issue with you, please check the response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/Need-Dropdown-with-blank-null-default/td-p/58172

Best regards,

Was this reply helpful? Yes No