Skip to main content

Converting the Shoutouts template to SQL Server

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”

» Leia mais

New CDS capabilities for Canvas apps enter Preview

For the last few months we have been rolling out new features for Canvas apps when connected to the Common Data Service for Apps: One-to-Many relationships Option sets Many-to-Many relationships Aggregate delegation We have been doing this work under an Experimental switch, off by default for all apps: Thank you for playing with these features and … Continue reading “New CDS capabilities for Canvas apps enter Preview”

» Leia mais

Delegation of Aggregate functions for CDS

Sum, Min, Max, and Average functions in Canvas apps are aggregate functions that can reduce a large amount of data down to a single value.   For example, Average could be used to find the average age of a class of students using Average( Students, Age ). These functions can also be used with the Filter function … Continue reading “Delegation of Aggregate functions for CDS”

» Leia mais

Option Sets and Many-to-Many Relationships for Canvas apps

We continue to expand our Canvas support for the Common Data Service for Apps, on the road to CDS + Canvas = Awesome. With this installment we have refined how Option Sets and Two Option data types work and have added support for Many-to-Many relationships. These features are available now with the CDS Experimental Connector. …

» Leia mais

Fun with GUIDs!

For those who work with primary and foreign keys on CDS and SQL Server, we have added GUID as a first class data type. Although not common, you may want to beat the rush and start updating any formulas that use literal GUID strings.

» Leia mais

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.

» Leia mais

Announcing the PowerApps how-to video series

Over the next two months, we’re continuing to roll out a series of deep-dive videos on the Official PowerApps YouTube channel. These videos teach a wide variety of app building concepts and provide examples from our PowerApps Office templates so you can get hands on.

» Leia mais