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”
PowerApps bug: default property of check box is ignored on app launch
This is an annoying bug. Continue reading “PowerApps bug: default property of check box is ignored on app launch”
PowerApps User() function – cache current user OnStart
The User() function currently gets called by your app every time it is used. This can cause you app to slow down, or expressions with User() to not work at all. The quick answer is to cache the current user in a global variable when the app starts.
Continue reading “PowerApps User() function – cache current user OnStart”