Skip to content
Category: SQL Server
2018-12-18

Learning to Connect PowerApps with SQL Server

It’s time to do more interesting things with PowerApps. In this entry, we will connect PowerApps to a SQL Server table by inserting a DataTable, because it is a good way to show data on the PowerApp.

1: Scenario.

To begin, let’s create a blank PowerApp. At first, we will see the following screen:

2: Adding a DataTable.

Let’s click on “Insert” and we will open the menu of elements to insert in the PowerApp.

The next step will be to insert the data table, to do this, we click on the “Data Table” button.

Once added the DataTable, we should choose the connection with which we want to create the viewing.

We see that no data appears in the table, that is because we have not established any connection. In our case, we chose the gateway called “PowerAppsTest” and it points to the database with same name, then we select the table we want to show, in our case “[ejem]. [Employees]”.

When the table is inserted, it will appear like this:

As we can see, a message appears in the table saying that we have not selected any field in the data table, so we have to select the “check” of the fields of the table that we want to show.

If you are interested in the Power Platform, don’t hesitate to consult our Data Analytics page.

3: Testing.

We will make a query from SQL Server that shows us the data of this table, to see if they agree with the data shown by the application.

In the following entries we will see how to delete data or insert data in SQL Server through a PowerApp.

If you want us to help you with the support of your SQL Server in your business or company, contact us at info@aleson-itc.com or call +34 962681242.

Complete este formulario para recibir la guía de Windows Server en Azure
*Obligatorio
Complete este formulario para recibir la guía de Windows Server en Azure
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
*Obligatorio
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud Migration Essentials
*Obligatorio
Complete este formulario para recibir Cloud Migration Essentials
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
*Obligatorio
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete this form to recieve the guide of Windows Server on Azure
*Required
Complete this form to recieve the guide of Windows Server on Azure
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
*Required
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud Migration Essentials
*Required
Complete this form to recieve Cloud Migration Essentials
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud security Advice for Nonprofit Leaders
*Required
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud Migration Simplified Ebook.
*Obligatorio
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
Thank you for filling out the form [name]. Here's your Free eBook!