Blog Recent Posts
Blog - Recent Posts
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.
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.
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.
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.
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.
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.
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.
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 - 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.
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.
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.
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 - 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.
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.
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.