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”
» Mehr dazu lesen 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”
» Mehr dazu lesen 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. …
» Mehr dazu lesen 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.
» Mehr dazu lesen 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? …
» Mehr dazu lesen 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…
» Mehr dazu lesen Get your app started faster by preloading collections in parallel with the new Concurrent function.
» Mehr dazu lesen 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…
» Mehr dazu lesen 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.
» Mehr dazu lesen 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.
» Mehr dazu lesen