How to set the default value of a dropdown in powerapps

powerapps
choba78 picture choba78 · Sep 14, 2016 · Viewed 12k times · Source

I have a dropdown in powerapps and need to set the default value

My Items property of my dropdown I have it linked to my data source which is an Azure table.

'[dbo].[ColorTable]'

One could see the contents simplified as the following

Table({ColorName:"red"; ID: "1"};{ColorName:"green"; ID: "2"}{ColorName:"blue"; ID: "3"})

although I have many more entries.

In my details edit screen I have the ID value in my main datasource. However I need to set the dropdown's default with this value, however the dropdown use the ColorName as it's value.

How do I set the dropdowns default ID value since its Value is ColorName and not ID?

Answer

choba78 picture choba78 · Sep 14, 2016

I have a workaround that works but in conjunction with saving the selected value back again it can conflict with the saving.

In the Default property of the dropdown I add the following code

LookUp('[dbo].[ColorTable]';ID=ThisItem.fk_ColorID;ColorName)

Related questions

Rest API calls with PowerApps

I am playing around with Microsoft PowerApps and Microsoft Flow. I am trying to figure out how to make API calls from PowerApps and return the results(Status and Body) to a field such as a text box in my …

Read More
powerapps: populate drop down list from another datasource

I stumbled across Microsoft PowerApps earlier, and though I would have a play with it. I have connected to my SQL Server, and created a template for browsing, viewing and editing a basic application. Now in my database I have …

Read More
Pass a value to another screen

I have a screen where the user can select an option (not a browse gallery as it does not do what is required). I want to pass the item the user has selected to the pre-made "DetailScreen1" which is used …

Read More