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 Procedur...
6 days ago
SharePains Home of Microsoft Tech
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 Mi...
23 days ago
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. ...
1 month ago
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 peo...
1 month ago
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 ...
2 months ago
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 n...
2 months ago
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.
2 months ago
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 Nam...
3 months ago
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 ...
3 months ago
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 1000...
4 months ago
