Azure SQL Database is a very powerful tool, but currently there are limitations to its use in conjunction with PowerApps. I would appreciate any feedback on this list so that it can be kept up to date. Please note that all work-arounds are temporary, since sooner or later these limitations should be resolved by Microsoft. Continue reading “PowerApps and Azure SQL Database: Current issues and how to work around them”
PowerApps: A simple app using Azure SQL Database
In my post about PowerApps and Azure SQL Database, we created three tables and a blank app connected to those tables. In this post we will develop the app and hopefully you will find some design hints. Continue reading “PowerApps: A simple app using Azure SQL Database”
PowerApps and Azure SQL Database: a step-by-step beginner’s guide
In this post I will outline how to set up an Azure SQL Database and connect it to PowerApps to be ready to create a full solution for a simple business case: assigning resources to projects. Continue reading “PowerApps and Azure SQL Database: a step-by-step beginner’s guide”
PowerApps: How to reuse your code (at least in the same screen)
From version 2.0.702 we have a new function called Select(), which allows you to select (i.e. press/click) another control on the same screen or in the same container (i.e. a gallery’s template). Continue reading “PowerApps: How to reuse your code (at least in the same screen)”
PowerApps: Improving app performance
There are many reasons that an app can be slow to load, slow to respond, and slow to write to data sources. If your app feels sluggish there is often a lot you can do yourself to make it more reactive, even though the root of the problem may have to do with the way PowerApps is designed. Continue reading “PowerApps: Improving app performance”
PowerApps: simple shopping cart
Here is a simple way to implement a shopping cart in your PowerApp, just follow the steps below. I will demostrate with some sample data. The selected items will be added to or removed from the ShoppingCart collection as the user clicks on the check box. You can then use this collection elsewhere in your app, for example to submit orders once confirmed. Continue reading “PowerApps: simple shopping cart”
PowerApps 101: where do I store my data?
Any business IT solution must store data, be it customer information, inventory data, financial transactions, documents or pictures. It is important to chose the right place for your data. Continue reading “PowerApps 101: where do I store my data?”
PowerApps: improving lookup performance
Here is the scenario: you have two tables in Azure SQL DB or two custom lists in SharePoint that are related to each other via a foreign key (i.e. lookup) and you want to show all columns from the parent table. You manage to do this, but performance is very slow, the labels in your gallery take seconds if not minutes to show the correct value. Continue reading “PowerApps: improving lookup performance”
PowerApps bug: formatting of integer leaves stray decimal point
This is an annoying bug, but fortunately no more than that. Continue reading “PowerApps bug: formatting of integer leaves stray decimal point”
PowerApps issue: cannot update Azure SQL DB / SQL Server column value to NULL
This is a really fundamental problem when working with nullable columns. Continue reading “PowerApps issue: cannot update Azure SQL DB / SQL Server column value to NULL”