SQL Stored Procedures in Power Apps and the maximum data row limit
With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we…
How to develop business critical applications in Microsoft Excel?
Recently I have spoken with quite a few organisation who are interested in Microsoft 365, about business critical applications developed in Microsoft Excel. Quite a high percentage of organisations seem…
5 Best Practices for Named Formulas in Power Apps
Quite a few of my recent posts have been about named formulas in Power Apps. In this post I’m going through some of the best practices. Named Formulas A mentions…
Compare multi-select people fields in Power Apps
Yesterday, I needed to compare the values of two collections with people records. In this posts the details on how to compare multi-select people fields. The example app I created…
Type cast tables coming from SQL Server stored procedures in Power Apps
A new feature in Power Apps is SQL Stored Procedures that can be called directly form the Power App. This will give you an UnTypedObject, but how do we type…
This app ran into a problem in Power Apps
Today, one of my client’s app showed the This app ran into a problem error. How to debug the This app ran into a problem First we will need to…
User Defined Functions vs Named Formulas in Power Apps
Microsoft recently released User Defined Functions in Preview. In this post I'm going to compare User Defined Functions with Named Formulas.
How to use Named Formulas in Power Apps
Named Formulas were recently introduced into Power Apps. They can be great, but they do have a bit of a user guide. The principal ideas of Named Formulas Within the…
The Visible property in forms in Power Apps
Recently I came across a bit of a weird behaviour in Power Apps where the Visible property of a data card and a DataCardValue control’s Visible property was giving me…
1000th blog post on SharePains.com
A couple of weeks ago I announced that the 1000th blog post on SharePains.com was on its way! Well, you are looking at this post now. The 1000th blog post…