How to bind a datasource to a dropdown in PowerApps

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

How do you bind a datasource to a dropdown in PowerApps.

I have connected my Azure table to my PowerApps app so that the tables appear in my Data Sources.

I then added a dropdown control to my form.

In my Items property I can have list values hardcoded e.g.

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

but I want to link it to my DataSourceTable values that has "ID" and "ColorName" columns.

According to this help page I just need to put my tablename in the Items Property but this doesn't work.

Answer

user7002376 picture user7002376 · Jan 30, 2017

Try

Dropdown1.Items = Distinct(DataSource, ID) for ID Dropdown

or

Dropdown1.Items = Distinct(DataSource, ColorName) for ColorName Dropdown.

Hope this helps.

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