Blog - Recent Posts

Feb 04, 2022

Walkthrough - How to support multiple languages on model driven app pages

This week, Microsoft released in preview, support for localized model driven app pages. This post describes this feature by walking through the simple example of how to localize a text label.

Localization
Feb 03, 2022

Search - Applying multiple AND/OR conditions to the Search function- Workaround

The search function performs a partial match against multiple fields based on a single search term. Where we want to combine additional search terms with a logical 'And' or 'Or', there's no way to do this alone with the search function. This post describes a workaround to perform this task.

Search
Feb 02, 2022

Data - Creating a list of country names and codes

If you need a list of countries for use in drop down or other data controls, this post contains formula to create a collection of countries with associated 2 and 3 digit codes.

Feb 01, 2022

Formula - How to trim/remove leading or trailing characters from strings

There's often a need to strip or to remove specified characters from the start or the end of a string. This post summarises a selection of functions to carry out this task.

Jan 26, 2022

2022 Release Wave 1 - The best new features planned for Power Apps 2022

The 2022 Release Wave 1 plan describes Power Platform features that are scheduled for release between April 2022 and September 2022. What features have been planned for Power Apps? In this post, I summarise the notable enhancements that are planned for Power Apps.

Jan 25, 2022

Data - How to create a drop down list of US States

This post provides the formula to create a dropdown list of US States, including a walkthrough of how to setup an edit form to accept data entry through the dropdown.

Dropdown
Jan 21, 2022

Bug - Internal error in the AND/OR function Canceled Canceled

A recent update to Power Apps can cause the unexpected error "Internal error in the AND/OR function Canceled Canceled" to appear. This post provides a summary of this issue.

Bug
Jan 20, 2022

Dates - How to detect overlapping times / scheduling conflicts

When building apps, there can often be the need to detect overlapping times. This post describes the methodology and formula to carry out this task.

Dates
Jan 19, 2022

Excel - What to be aware of when building apps with Excel - Service Rate Limit

If you use the Excel Online Business Connector, here's an occasional glitch that's worth being aware of.

Excel
Jan 06, 2022

SharePoint - What to do when there's a mismatch between times in Power Apps and SharePoint

If the daytime values from a SharePoint list don't correspond to the values that you see in Power Apps, this post describes the most likely cause.

Sharepoint
Dec 17, 2021

Formula - What to do when the If statement doesn't work?

A question that arises on occasions is - why doesn't my If statement work? This post walks through one of the most common causes and highlights the possible workarounds.

Formula
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