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”
» Дополнительные сведения 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. …
» Дополнительные сведения 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.
» Дополнительные сведения
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.
» Дополнительные сведения Have you noticed that when you create a custom field in the Common Data Service for Apps that all the fields are all prefixed with cr5ca_ or some other random string and spaces are stripped? …
» Дополнительные сведения Over the summer we made it easy to walk Many-to-One relationships. With a single dot you can walk across a relationship from one entity to another. First(Orders).Customer.Name is all that…
» Дополнительные сведения
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.
» Дополнительные сведения Want to learn how to build PowerApps, but don’t know where to start? This how-to guide will take you step-by-step through the process of building various Microsoft Office components in PowerApps.
» Дополнительные сведения
Hi everyone. In our latest release, you can now automatically format your formulas! You can take all those very compact formulas, that can be very difficult to read and understand, and make them…
» Дополнительные сведения 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.
» Дополнительные сведения