Unanswered

How to use Choices function, but for SQL? I would like to populate my drop down in a form with items from a different SQL table.

(0) Share

Report

Posted on by lujanea

Hi there,

I would like to create a drop down in a form, that contains items from a different table (data source) in an Azure database. However, the Choices function doesn't seem to work for SQL data sources.

Is this possible for SQL data sources, and if it is how can this be achieved?

Thank you in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report

@lujanea ,

There is no need for choices() function, use inside Items property of the ComboBox,DropDown the name of SQL table (of course, it is already has a connection in app).

Was this reply helpful? Yes No
lujanea 4 on at

Like (0)

Report

Thank you for your response. Is there any way to do it inside a form?

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Setting a control items property is not influenced if is inside a form or not. So select the control, go to the items property and set it as you need.

maybe a screen shot would be more relevant in explain what you want to achieve.

Was this reply helpful? Yes No