How to bind a datasource to a dropdown in PowerApps

Question

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.

For me better answer in stackoverflow.com/questions/39490200/… Here how applied: how to bind DropDownList — Humberto Espinosa

user7002376 user7002376 · Accepted Answer · 2017-01-30T16:43:08

Try

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

or

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

Hope this helps.