User Defined Types in Power Apps
Recently I already mentioned Named Formulas and User Defined Functions in my posts. Today I'm looking at User Defined Types.
9 days ago
SharePains Home of Microsoft Tech
SQL Functions for Encrypting and Decrypting Large text fields
After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this pos...
12 days ago
Encrypt a large rich text field in SQL Stored Procedures
Recently I have done a lot of work with SQL Stored Procedures in Power Apps. But what do you do if you want to have some fields encrypted in y...
15 days ago
Weird date handling in Power Apps
This is a typical post on a Friday afternoon, about weird date handling in Power Apps. But understanding this issue will help in many situatio...
19 days ago
When an item is created vs When an item is created or modified
As part of my SharePoint connector series, I had a look at the When an item is created and the When an item is created or modified triggers in...
28 days ago
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...
1 month ago
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...
1 month 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. ...
2 months 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...
2 months 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 ...
3 months ago
