Blog - Recent Posts

Oct 13, 2022

Data - Combine columns from separate tables into a single table

This post describes the formula to merge or combine separate columns from different tables/collections into a single table.

Data
Oct 12, 2022

Microsoft Ignite 2022 - Highlights and summary of Power App announcements

The Microsoft Ignite conference is one of the biggest annual events in Microsoft's calendar. Here's a summary of the top highlights for Power App builders.

Ignite
Oct 11, 2022

Utilities - The best way to peform OCR on images of Power Apps Formulas

If you need to convert images of Power App formulas to text, here's a review comparison of some OCR tools that you can use.

Formula
Oct 10, 2022

Colors - How to get darker or lighter shades of a colour

If you want to calculate a darker or lighter color based on an input colour, this post describes how you can carry out this task with the help of the ColorFade function.

Colors
Oct 07, 2022

PCF Components -  What to do when strange errors occur when calling NPM commands

If you receive strange errors when attempting to call NPM, here's what you can do to try to fix the error.

Pcf
Oct 06, 2022

Controls - How to create multi-line tooltips or multi-line text input control hint text

If you're stuck on how to insert line breaks in tooltips and hint-text for text input controls, here's a quick guide on how to accomplish this.

Controls
Oct 05, 2022

Designer - How to better collaborate with other app builders using the new comments feature

When building apps in Power Apps studio, we can now collaborate with other app builders by adding design time comments to apps. This post walks through this new functionality.

Designer
Oct 04, 2022

Apps - How to open Power Apps MSAPP files - 2022

Following the recent update to the Power Apps Studio UI, here's where to find the menu items to open and save local MSAPP files.

Designer
Oct 03, 2022

Ignite Conference - Receive free Power Platform exam certifications 2022

The Ignite conference returns in 2022 in October and you can pick up some free Microsoft certification exams by registering!

Exams
Sep 29, 2022

Power Apps Studio - Why the sad face?

What's the reason for the sad face icon that can appear in the Power Apps designer and what can we do about it?

Sep 27, 2022

Example - How to use a drop down control to convert currencies

For cases where we want to display values or prices in a different currency, this post describes a simple example of how to use a drop-down box to display the converted value.

Formula
Sep 15, 2022

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.

Formula
Aug 25, 2022

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.

Excel
Jul 20, 2022

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.

Dataverse
Jul 10, 2022

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

Gallery