Blog - Recent Posts

Dataverse - How to create Entity Relationship diagrams

Entity relationship diagrams can help us visualise and better understand the schema of a database. In this post, we look at how to create an ER diagram for a set of Dataverse tables.

Data - How to group data in a gallery and calculate sums

When displaying records in a gallery, it can be very helpful to show the sums of values. This post provides a walk-through on how to carry out this task.

Dataverse - How you can more quickly bulk update data using the SQL language

If you need to want to update records in a Dataverse database using SQL commands, one way to carry this out is to use XrmToolBox and the SQL4CDS plugin. This post provides a summary of how this works.

Dataverse - How to fix the bug in the 'Business Rules' editor that prevents numeric values from saving

When there is a mismatch between the language of Dataverse and the language of the editor, business rules can fail to save with an error that looks like this - 'Enter a value from -922,337,203,685,477.00 through 922.337,203,685,477.00'. This post describes a workaround for this issue.

Training - List of Virtual Training Day Events in January and February 2023

Here's a list of Microsoft Virtual Training Day events in January and February 2023 - ideal if you're looking for some free online Power Platform learning.

Barcodes - How to scan barcodes - a summary of the 3 available barcode scanning controls

Power Apps provides 3 different controls for scanning barcodes. How do these controls differ and what are the circumstances in which we would use each control? Read this post to find out more.

Formula - How to calculate compound interest

If you need to calculate compound interest from Power Apps, this post describes the formula to carry out this task.

Data - What to do when the data panel is missing in designer

If you open an existing app in the Power Apps designer and can't find the data panel is missing, here's a workaround that you can try.

Editor - How to save and overwrite an existing app in Power Apps

If you're stuck on where to find the option in the modern app designer to overwrite an existing file, this post provides more details.

PCF - How to get the IP address of the client

If you need to find out the IP address of the client in a canvas app, this post walks through how to accomplish this task with the help of a PCF control.

Demo app - How to save data like a pro - Southcoast Summit Presentation

If you're looking for tips and tricks on saving data, here's a link to a recent presentation that I did with Power Apps expert Gerard Simpson.

Error - How to fix "Sign-in to continue" loop problem in the model driven app designer

If you encounter the 'Sign in to continue' error in the Power Apps designer, here's what you can do to fix the problem.

Colors - How to convert Power App colors to hex

Unfortunately, there's no way to convert Power App colours to hex. If you need to carry out this task, this post describes a workaround that we can use.

Templates - Discover UI inspiration ideas through community Power App templates on Figma

If you're designing an app and you need some inspiration for UI ideas, you can take a look at some of the free community templates that you can find through figma.com.

Dates - How to calculate UK tax weeks

If you need to convert dates to UK tax weeks or generate a list of the start and end dates for tax weeks in a year, this post describes some formula that you can use.