App templates in PowerApps are a great way to jump start the creation of an app that can be deployed in your tenant. Those templates create a polished, finished app, and in many cases it creates an Excel file so that the app can be used right away – and in most scenarios the app … Continue reading “Converting the Shoutouts template to SQL Server”

When we connect an app to a SQL Server table that has a column of type time, the values don’t show in a user-friendly format by default in PowerApps. In this post we’ll go over some expressions that can be used to improve the experience for the app users, by converting from the duration format to a more natural hh:mm:ss one.

PowerApps connecting to SharePoint allows you to build complex scenarios without having to customize the formulas, however there are times when you have specific business rules that need to be addressed. We noticed a few questions that appeared in the community on how to set default values new items in forms, especially complex SharePoint columns like Choice, Lookup and Person, so this post will show how you can do that.

SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume that in PowerApps. This post explains why this is the case, and walks through ways to make your app work with all kinds of date/time representations.

PowerApps currently doesn’t support out of the box multi-valued fields – columns in a data source that can take zero or more of a predefined set of values. This post shows a workaround to enable this scenario, by using a group of checkbox controls to toggle the selection of the possible items.