cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Develop a way to access a SQL table using a text to return the corresponding number

This feels like a complex problem to me.

 

We have an app that we are looking to allow the user to either, type in a text or select from a dropdown but have that return the associated number to that text/dropdown into the app.

 

Example: I put in ID and it returns the account ID associated in the SQL table.

buteaur_0-1623778889310.png

Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
cchannon
Super User
Super User

Yes, just set up your SQL database as a data source in the canvas app and you can query it like any other data source.

 

A quick search on Google turned up this blog which seems like exactly what you're looking for:
Search Records From SQL Server Using PowerApps Canvas App (c-sharpcorner.com)

View solution in original post

1 REPLY 1
cchannon
Super User
Super User

Yes, just set up your SQL database as a data source in the canvas app and you can query it like any other data source.

 

A quick search on Google turned up this blog which seems like exactly what you're looking for:
Search Records From SQL Server Using PowerApps Canvas App (c-sharpcorner.com)

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,662)