Skip to main content
Headshot of article author Greg Lindhorst

If you live in Mexico or the United Kingdom you may have noticed that Canvas apps don’t quite get the international settings right.   We have lacked a consistent map of languages and regions across the Studio, the web player, and the mobile players. With the release coming next week (v3.19032) we have fixed this.  As […]

» 閱讀更多
Headshot of article author Greg Lindhorst

Canvas app authors have new tools for working with Common Data Service for Apps relationships: Relate and Unrelate functions. Many-to-Many relationships Since December, you have been able to read Many-to-Many relationships using the experimental and then preview CDS connector.  But it has been impossible to relate or unrelate two records and the join table is […]

» 閱讀更多
Headshot of article author Greg Lindhorst

Some big news!   Or at least much bigger news. Canvas app SaveData and LoadData functions are now only limited by the amount of available app memory and local storage on a device.  The previous limit of a few megabytes no longer applies.   This is a huge improvement that will increase the stability of any app that […]

» 閱讀更多
Headshot of article author Greg Lindhorst

For regular readers of this blog, you may recall a blog post by Carlos Figueira on working with SQL server time values.  In it, Carlos used the Mid, Find, Substitute, and other functions to parse an ISO 8601 duration string such as “PT2H1M39S” which represents 2 hours, 1 minute, and 39 seconds. Carlos’ solution works great […]

» 閱讀更多
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 […]

» 閱讀更多
Headshot of article author Greg Lindhorst

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 […]

» 閱讀更多
Headshot of article author Greg Lindhorst

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 […]

» 閱讀更多
Headshot of article author Greg Lindhorst

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. …

» 閱讀更多
Headshot of article author Greg Lindhorst

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.

» 閱讀更多
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.

» 閱讀更多