Blog - Recent Posts

Formula - How to parse JSON in Power Apps- 4 examples

Following the introduction of the ParseJSON function, we can more easily parse JSON for use from within Power Apps. This post highlights the formula to parse 4 typical JSON structures that we may encounter.

How to use formulas to perform calculations in Excel and to display the results in Power Apps

This post walks through how to perform calculations with formulas in Microsoft Excel, and how to return the results to Power Apps using Power Automate and Office Script.

Dataverse - What are the benefits, and how to create formula columns

Yesterday, Microsoft announced the preview release of formula columns for Dataverse. This post summarises the benefits of formula columns and walks through the steps of how to define a formula column.

Example - How to build hard-coded/data driven menus

Building data driven menu structures can be very beneficial. They can improve app performance, and we can better customise menus by filtering items by user, or by storing the menu item in data source. This post walks through an example of how to build a data driven menu structure

Forms - How to set the value of a field to todays date for new records only

A common requirement is to set the default value of a form field to today's date, only when a user enters a new record. In edit mode, the field value should remain the same. This post walks through how to carry out this task.

Flow - How to delete 'Ask in PowerApps' parameters in Flow

When building Power Automate flows for use with Power Apps, a frustrating issue is that it isn't obvious how to delete unwanted 'Ask in PowerApps' parameters. This post describes how to carry out this task.

Screens - How to copy screens between apps

This post walks through the technique that we can use to copy screens between canvas apps.

Dates - How to display minutes as hours/minutes, and days/hours/minutes

If you need to convert an input value in minutes into hours and minutes, this post describes the formula to carry out this task.

Updates - How to find the dates and details of upcoming Power Apps feature releases and updates

For planning purposes, it's very useful to know the dates and details of upcoming Power Apps updates. The new Release Planner portal makes this task easy.

Apps - How to create an app from a hand drawn image

One of the most exciting announcements at the Build Conference was Express Editor - the feature that builds apps from PDF or hand drawn documents. How does this feature work and how well are theresults? In this post, we'll find out.

What cost savings can corporate organisations achieve with Power Apps and the Power Platform?

If you're thinking of adopting Power Apps and the Power Platform in your organisation and you want to make a business case as to the potential economic benefits that the platform can add, the following Forrester studies may help you.

Microsoft Build 2022 highlights

Here's a brief summary of the main highlights of the Microsoft Build 2022 conference.

Certifications - Free Microsoft exam vouchers May 2022

If you're looking to learn about the latest news and innovations from Microsoft and receive a free Microsoft certification in the process, you should join the Cloud Skills Challenge at Build 2022. This post describes what's on offer and how to register.

Apps - What happens to canvas apps when the owner/employee leaves an organisation?

When an employee leaves an organisation, what happens to the apps that they've built? Can other employees continue to edit and access the apps?

Dataverse - How to sort the available choice items from a choice column

With Dataverse choice columns, there's often the need to sort dropdowns in alphabetical or custom sequences. This post describes how to carry out this task.