Skip to main content

Working with Time columns in 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.

» További információ

Defining default values for complex SharePoint types in forms

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.

» További információ

Working with date/time values and SQL Server

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.

» További információ

Support for multi-valued choices in forms

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.

» További információ