Blog - Recent Posts

SharePoint - Filtering lists by User() is now delegable

A common requirement is to filter SharePoint records by the email address of the current user. In the past, this task could be difficult because filtering lists by User().Email was not delegable. The good news is that Microsoft has now improved this behaviour and is post describes what's new.

Dates - How to get the start date from week number

When working with dates, there may be the requirement to derrive the start date of a week based on a week number. This post describes the formula to carry out this task.

Data - How to remove/delete a field from a record

From time to time, it may be necessary to remove or delete one or more fields from a single record. This post describes the formula to carry out this task.

Numbers - 10 examples of how to round numbers

When we work with numbers with Power Apps, a common requirement is to round numbers. This post summarises the formula to carry out some of the most common rounding requirements, including how to round to multiples, how to round to values such as 0.5, 0.99, 0.45, how to round to odd/even numbers, and how to return the integer portion of a decimal value.

Dates - How to check if a year is a leap year

Working with dates, it can sometimes be necessary to work out whether a given year is a leap year. This post describes a technique we can use to carry out this task.

Dates - How to get the week number for a given date

A common requirement is to calculate week numbers. Up till now, this task could be difficult to accomplish but now, Power Apps introduces the WeekNum and ISOWeekNum functions to help simplify this task. This post describes how these two new functions work.

Dates - How to get the nth weekday for a month

When building apps, it can be very useful to determine the nth workday in a month. For example, what's the 2nd Tuesday in a month, what's the 3rd Wednesday for a month, what's the first Monday (etc)? This post describes the formula to carry out this task.

Dates - How to get the last weekday for a month

When building apps, it can be very useful to determine the last workday in a month. For example, what's the last Thursday in a month? This post describes the formula to carry out this task.

Forms - How to calculate values (eg sums and products) and store the results in SharePoint or other datasource

A simple and basic question that often arises is - how do I perform calculations against fields and store the results in SharePoint or a database? This post walks through how to carry out this task with forms.

Sums - How to calculate 'year to date' or running totals

There can often be the requirement to calculate running totals and to display the results in a gallery or data table control. This post describes the formula to carry out this task.

Search - How to filter records by date ranges (eg today, this week, this month, etc)

A common requirement is to search records based on date ranges. Example date ranges could include records that have been entered today, this week, this month, this year, etc. This post demonstrates how to build this type of functionality.

Formula - converting centimeters/meters to feet and inches, and vice versa

When building apps, particularly for audiences that include US and European users, there is often the requirement to convert measurements from centimeters/meters to feet and inches. This post covers the basic formula to carry out this task.

Security - What's Azure ExpressRoute? An introduction

Azure ExpressRoute provides a more secure and reliable way to connect to resources that are hosted in the Microsoft cloud.

SharePoint - How to use radio buttons to set choice column values

To make it easier for users to enter a choice value when adding or editing a record, we can replace the default combobox control on a form with a radio control. This post walks though how to carry out this task.

Performance - Are network settings slowing down Power Apps?

It's useful to understand that the server infrastructure that Power Apps relies upon supports HTTP/2. Devices that fail to connect via HTTP/2 will perform more slowly. This post examines this behaviour in more detail.