Error handling is almost done. Before we complete it, we are making some small changes to how Blank is handled by the Value functions. All changes are under the experimental “Formula-level error management” switch and will not impact the vast majority of apps. We are also introducing a new home for experimental feature documentation and feedback in the community forum.
» Scopri di più
We’re thrilled to announce a new feature under Power Apps Ideas, example to formula or also known as programming by example, is now available in public preview!
» Scopri di più
Excel’s Int, Trunc, WeekNum, and ISOWeekNum functions are now available for use in Power Fx formulas.
» Scopri di più The standard Canvas formula bar is better than ever, including more natural Enter and Tab key behavior and a scrollbar. The previously experimental formula bar is being retired.
» Scopri di più Microsoft Power Fx is the low code language for expressing logic across the Microsoft Power Platform. It is the same language that is at the heart of Microsoft Power Apps canvas apps today and is inspired by Microsoft Excel. It enables the full spectrum of development from no code to pro code with no cliffs in between, enabling diverse teams to work together and saving everyone time and money. We are very excited to bring it to more of the Power Platform and to share it with everyone as open source. Only through a strong user community can a language grow and flourish.
» Scopri di più Enjoy two new experimental features for formula based components. Behavior properties enable a component to fire a custom event into its container, such as OnChange. Property parameters enable the passing of arguments for a property evaluation, providing our first steps toward formula based user defined functions.
» Scopri di più Imagine using GitHub and Visual Studio Code with the text formulas of a Canvas app. Teams can collaborate on apps: they can work on private branches, diff changes, create pull requests for review, and merge into master. We are very pleased to announce the experimental release of a tool that enables these modern miracles. It is but the first step as we make application lifecycle management easier for formulas and Canvas apps.
Scopri di più You can now refer to the whole record in ForAll and other record scope functions with ThisRecord. You can even name that record with the As operator, allowing you to clarify formulas and work with all the records in nested ForAll and Gallery controls. And finally, we’ve added Excel’s Sequence function to generate a table containing a sequence of numbers, perfect for iterating a specific number of times with ForAll.
» Scopri di più
We are happy to announce the availability of column comparisons. This has been a common ask from our MVPs and ISVs for a while now and it’s exciting to provide this functionality.
» Scopri di più