Skip to content
Category: SQL Server
2018-10-24

Datatable doesn’t show data on User mode at PowerApps

PowerApps show us an entire world of possibilities, but they are in a premature state, so we have not too much sites to get information about the problems that can appear.

Sometimes things happen that we can’t understand. Mistakes that never happened to us, applications that always worked nice suddenly … They fail.

This is what we have found in PowerApps.

Creating the scenario:

To reproduce this error, we are going to create an application with PowerApps in which we have to show a table with the SQL Server data (DataTable) that we need. The problem is that from the editing mode we see it works correctly:

This is what should appear when displaying the table “Companies” with the names of these, the date of the amount, their respective ID and the amount made, however, when running the application from the user mode we see that the table can not find any data to show:

Don’t be mad, first let’s check the connection, the gateway, the permissions of the database, the properties of the table … And if after this we can’t find the problem that prevents us from viewing the table in user mode , What else can we do?

Solution:

The solution is as simple as going to the properties of the application.

As we can see, we have many options activated … Too many. So we are going to proceed to disable one of them, specifically the option to keep time by doing simultaneous loads to reduce loading time and to reduce the consumed memory.

If any experimental feature of the PowerApps is enable, we will remove it just in case it produces an error in our application. Now we try again to visualize the table in user mode and everything will work correctly.

As we are facing problems with the creation and design of the PowerApps, we will report about the solutions found.

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!