Excluding weekends and holidays in date differences in PowerApps

The DateDiff function allows an app to calculate the difference between two dates – a simple calendar operation. However, in many business applications, one needs to remove weekends when getting the difference – the app needs to know how many business days are between two given dates. There are a few threads in the forums…


Supporting multi-valued “listboxes” in PowerApps

One the current limitations of PowerApps is the lack of support for multi-valued fields – a column in a data source that can take zero or more of a predefined set of values. One example is a Choice column in SharePoint that allows multiple selections, which is a required scenario for some users. – if…


Building multilingual apps in PowerApps

PowerApps is localized in many languages – depending on the language of your computer, you’ll see the authoring experience in the appropriate language (if the language is supported). For example, if I set my browser (Chrome) language to French, I’ll see the authoring Studio in that language. If we want to make an app that…


Formatting fields in PowerApps data tables

The Data table control in PowerApps is an easy and quick way to display data in a tabular format on an app created in the platform. It has been released a couple of months ago, and it still has many features coming up over the upcoming versions (listed in the control reference page). One of…