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 (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 (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