cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivpd
Level: Powered On

Power Apps and SQL Server

I want to create a Table in SQLServer and work with PowerApps.

How can i do ?

 

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Power Apps and SQL Server

Here's a blog post that will walk you through how to build a PowerApp that uses a SQL database in Azure.

http://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Super User
Super User

Re: Power Apps and SQL Server

Hi @ivpd 

 

For doing so, you need to setup the configurations for the both SQL server and the Powerapps.
 
SQL Server:
1) Create the SQL server and then create a table inside using the sql query.
2) Keep a note of SQL Server Name, Database Name and login credentials, these will be required to setup the connection in powerapps.
 
PowerApps:
1) From the top navigation, select View and then select Data Sources.
2) Click on Add Data Source in the pop up and then select New Connection, Search for SQL Server. 
3) Provide in the details noted down from the SQL server.
4) Once the connection is setup, you can use Gallery controls to shw the data inside the Data source or use the FIlter query to filter data based on specific conditions.
 
You can refer microsoft documentation for setting up the connection on the link below:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabas...
 
Hope this Helps!
Community Support Team
Community Support Team

Re: Power Apps and SQL Server

Hi @ivpd 

 

Could you please test with @Pstork1 's and @yashag2255 's post?

They are all very helpful.

 

More information:

add-data-connection

connection-azure-sqldatabase

 

If you want to use one gateway:

gateway-reference

 

Best Regards.

Yumia

6 REPLIES 6
Super User
Super User

Re: Power Apps and SQL Server

Here's a blog post that will walk you through how to build a PowerApp that uses a SQL database in Azure.

http://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Super User
Super User

Re: Power Apps and SQL Server

Hi @ivpd 

 

For doing so, you need to setup the configurations for the both SQL server and the Powerapps.
 
SQL Server:
1) Create the SQL server and then create a table inside using the sql query.
2) Keep a note of SQL Server Name, Database Name and login credentials, these will be required to setup the connection in powerapps.
 
PowerApps:
1) From the top navigation, select View and then select Data Sources.
2) Click on Add Data Source in the pop up and then select New Connection, Search for SQL Server. 
3) Provide in the details noted down from the SQL server.
4) Once the connection is setup, you can use Gallery controls to shw the data inside the Data source or use the FIlter query to filter data based on specific conditions.
 
You can refer microsoft documentation for setting up the connection on the link below:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabas...
 
Hope this Helps!
Community Support Team
Community Support Team

Re: Power Apps and SQL Server

Hi @ivpd 

 

Could you please test with @Pstork1 's and @yashag2255 's post?

They are all very helpful.

 

More information:

add-data-connection

connection-azure-sqldatabase

 

If you want to use one gateway:

gateway-reference

 

Best Regards.

Yumia

JoaoN
Level: Powered On

Re: Power Apps and SQL Server

Hello guys.

I am trying to use the SQL Server Express Editon as data source. Is that possible?

I am having some trouble to use it as conector to PowerApps. I inser the server name, data base, user and the password. I am using the cloud option, but can not connect it.

Super User
Super User

Re: Power Apps and SQL Server

Please post this as a new message instead of tagging it on to an old reply on a similar topic.  You will get a much better chance of a response if its not a reply to an already answered post.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
JoaoN
Level: Powered On

Re: Power Apps and SQL Server

Thank you! I will do that!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 271 members 3,967 guests
Please welcome our newest community members: