web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Rtzpj6+9e0P9M8KxFT2TSD
Power Apps - Building Power Apps
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.

Like (0) ShareShare
ReportReport
Posted on 28 Mar 2023 17:11:54 by 4

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:
  • CU-18081211-6 Profile Picture
    9,266 Moderator on 29 Mar 2023 at 14:26:02
    Re: 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.

    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.

  • lujanea Profile Picture
    4 on 29 Mar 2023 at 13:08:37
    Re: 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.

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

  • CU-18081211-6 Profile Picture
    9,266 Moderator on 28 Mar 2023 at 17:54:51
    Re: 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.

    @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).

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete