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)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,171)