Power Apps and SQL Server

[ivpd]

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

How can i do ?

[Pstork1 · Accepted solution]

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/

[yashag2255 · Accepted solution]

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!

[v-yuxima-msft · Accepted solution]

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]

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.

[Pstork1]

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.

[JoaoN]

Thank you! I will do that!