Blog - Recent Posts

Formula - What to try when numbers don't format correctly

A frustrating problem that app builders sometimes encounter is the inability to format numbers correctly. This post examines what to try if you find yourself in this situation.

Controls - How to convert HTML to Text

A frequent requirement is to convert HTML to text. This issue arises frequently when app builders attempt to display values from SharePoint rich text columns. This post summarises the methods to display rich text content in Power Apps, and how to convert HTML to text.

Mapping - how to annotate map regions with shapes

The map control offers the ability for users to annotate maps with shapes and labels. This post provides a summary of how this feature works, including how to save and to retrieve shapes from a data source.

How to document a canvas app

When building apps professionally, an important step is to document our work. This post examines how the "Power Apps Review Tool" can assist this process.

Data - How to move SharePoint sites, lists, and data

SharePoint is a very popular data source with Power Apps. A common requirement is to move data and lists between sites, or different tenants or organisations. In this post, we'll walk through how to use PowerShell to carry out this task.

Model driven apps - how to display how much time remains until a milestone date

On a model-driven app form, it's possible to display a countdown timer that shows the remaining time until some milestone event. This post walks through how to use this control.

Troubleshooting - What to do when mobile app users can't login?

In situations where users can't login through the mobile or Windows apps, the most likely fix for the problem is to reset the Power Apps player. This post shows where we can find this setting.

Tips - How to improve productivity with shortcut keys

In the canvas app designer, we can use shortcut keys to perform tasks more quickly.  Here's a summary of some of the more useful shortcut keys that can help improve productivity.

Model driven app - How to calculate working days

With model driven apps, it can be very difficult to calculate working days. The classic way to perform this task is to use a workflow. In this post, we'll examine this technique in more detail, and walk through an example of how to add a set number of working days.

Formulas - how to return all days between two dates

There are some scenarios where we need to return all the days between a given start and end date. This post describes the formula to build a table of sequential, consecutive days.

Data - How to save and retrieve Google calendar entries

Power Apps provides a connector to retrieve and to add Google calendar entries. The syntax for this connector isn't very obvious so in this post, we'll walk through an example of how to display contacts in a gallery control, and how to add contacts to a Google account.

Charts - How to extend canvas apps with additional chart types

If you find the built-in charts types are too limiting, it's possible to access a range of additional chart types chart types by using the Canviz Power Apps Chart Components. This offers several additional chart types that include radar, funnel, scatter, candlestick, and gantt charts.

Model Driven App - How to apply an input mask to a text input field

Unlike canvas apps, a feature of model driven apps is the inclusion of a masked input control. It may not be obvious how to apply this feature so in this post, we'll walk through the steps.

Data - How to save and retrieve Google contacts

Power Apps provides a connector to retrieve and to add contacts that are stored in Google. The syntax for this connector isn't very obvious so in this post, we'll walk through an example of how to display contacts in a gallery control, and how to add contacts to a Google account.

Media - How to rotate images on screen

To make it easier for users to view images that are displayed in an image control, we can add buttons to rotate the display image. In this post, we'll walk through the formula that enables us to carry out this task.