Skip to main content

Power Fx: Experimental error handling update

Headshot of article author Carlos Figueira

Error handling is almost done. Before we complete it, we are making some small changes to how Blank is handled by the Value functions. All changes are under the experimental “Formula-level error management” switch and will not impact the vast majority of apps. We are also introducing a new home for experimental feature documentation and feedback in the community forum.

» Przeczytaj więcej

Converting the Shoutouts template to SQL Server

Headshot of article author Carlos Figueira

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”

» Przeczytaj więcej

Working with Time columns in SQL Server

Headshot of article author Carlos Figueira

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.

» Przeczytaj więcej

Defining default values for complex SharePoint types in forms

Headshot of article author Carlos Figueira

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.

» Przeczytaj więcej

Working with date/time values and SQL Server

Headshot of article author Carlos Figueira

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.

» Przeczytaj więcej

Support for multi-valued choices in forms

Headshot of article author Carlos Figueira

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.

» Przeczytaj więcej