Blog - Recent Posts

Dec 16, 2021

Formula - Boolean And / Or operators - What is the order of precedence?

When we construct expressions that include the Boolean And and Or operators, which operator takes precedence? Find out in this post.

Formula
Dec 08, 2021

SQL - Storing timezone independent time values with datatimeoffset

In cases where it's necessary to store timezone independent time values in SQL Server, we can accomplish this by using the datetimeoffset data type. This post describes how this data type works with Power Apps.

Sql Datetime
Nov 29, 2021

Dates - How to display or convert Excel date serial numbers

Microsoft Excel stores dates as serial numbers. This post describes this behaviour and shows the formula to convert and display Excel date serial numbers in Power Apps.

Dates
Nov 28, 2021

Text - How to convert a character to its ASCII numeric value

There's no built-in function in Power Apps to convert a character to its ASCII value. This post describes how to carry out this task.

Text
Nov 23, 2021

Text - Examples of how to use the Char function, and a reference of ASCII codes

A very versatile function is the Char function. This post highlights example use case scenarios of how to utilise this function and provides a reference guide of ASCII codes.

Nov 22, 2021

Calendar - An easy way to add events to Google calendar

For cases where we want to add events to a Google calendar, we can carry out this task through a simple technique that avoids the more complex alternative of calling the Google Calendar connector. This post describes this method in more detail.

Google
Nov 16, 2021

Controls - How to set the data source of a Combo Box to a comma separated string

There may be a need to set the data source of a combo box control to a comma-separated list. This post walks through how to carry out this task.

Formula
Nov 11, 2021

Learning - Ignite Power Platform Developer Challenge - Chance to obtain a free exam this November 2021

Following from the Ignite conference earlier this month, a highlight is the "Cloud Skills Challenge". This offers a free certification exam for those who complete the challenge, and this post provides more details.

Learning
Nov 08, 2021

Microsoft Ignite 2021 - Highlights and summary of Power App announcements

The Microsoft Ignite conference is one of the biggest annual events in Microsoft's calendar. If you missed it, here's a summary of what we learned, including the top highlights for Power App builders.

Nov 01, 2021

Outlook - How to add, edit, delete, and list Outlook calendar events

By integrating apps with Outlook calendars, we can create far more powerful apps, particaularly in the case of scheduling applications. This post describes how to integrate with Outlook through the Office 365 Outlook Connector Including tasks that include adding, editing, deleting, and searching Outlook calendar events.

Outlook
Oct 27, 2021

Apps - Migrating OnStart formula to use App.StartScreen/ Fixing existing apps that implement deep linking

A recent update to Power Apps now prohibits the use of Navigate in App.OnStart. Existing apps that call Navigate in App.OnStart will show the error 'Navigate is not permitted in OnStart. Use the StartScreen property instead.' How do we fix this problem? The post describes some of the possible solutions.

Formulas
Oct 21, 2021

Calculations - What mistakes can happen when we fail to use round brackets correctly in calculations?

What can go wrong when we fail to use brackets correctly in mathematical calculations? This post provides an example.

Formulas
Oct 19, 2021

Walkthrough - Solving maths puzzles with Power Apps

For learning purposes, it can be useful to see a practical example of how to carry out mathematical tasks with Power Apps. This post walks through a demonstration of how to answer a quiz question using Power FX functions that include ForAll, Sequence, and Mod.

Formulas
Sep 27, 2021

Error - Unable to modify Dataverse tables with error message, Language id should not be null

Au unusal problem you may encounter is the inability to modify Dataverse tables. During any attempt to modify or to save a table, the designer shows the error 'Language ID should not be null'. Here's what to do if you experience this problem.

Dataverse
Sep 23, 2021

Formula - Transposing/converting rows to columns- an almost impossible task?

A common requirement is to transpose records in Power Apps - in other words, to convert rows to columns or columns to rows. This post discusses this topic and provides an example of how to carry out this task.

Data