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”
» 閱讀更多 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.
» 閱讀更多 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…
» 閱讀更多 Get your app started faster by preloading collections in parallel with the new Concurrent function.
» 閱讀更多 A quick note. A few months ago we introduced a new ShowError function that could display a banner error message. We heard from the community that they liked it but wished they could display…
» 閱讀更多 You can now capture errors, display custom error notifications, and most importantly write Null values to databases. This is an experimental feature that you will need to opt-in to as we continue improving this feature over the months ahead.
» 閱讀更多 The newest update for PowerApps (version 680) can delegate the Sum, Average, Min, and Max functions to SQL Server. We provide an example of summing a million records in a few seconds and show how it can be used to provide the grouped sum of order line items in an order entry system.
» 閱讀更多