Skip to main content

Formula Bar Changes

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.

» Læs mere

What is Microsoft Power Fx?

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.

» Læs mere

Enhanced component properties

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.

» Læs mere

Source code files for Canvas apps

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.

Læs mere

Formulas: ThisRecord, As, and Sequence

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.

» Læs mere

Formulas: Notify timeout and Exit sign out

You can now set the timeout for the Notify function, controlling how long the banner appears, from 1 millisecond to infinity. And you can now sign out the current user with the Exit function, important in situations were devices are shared such as health care.

» Læs mere

Introducing Monitor to debug apps and improve performance

You now have a new tool to better understand, debug, and improve your apps.  Similar to a network trace, Monitor provides a running list of all the activity within your app.   You can examine what data requests are made from your app, how long they took, how much data was returned, and which resulted in an error. 

» Læs mere

Faster data entry with the SetFocus function

Welcome the SetFocus function to Canvas apps!  You’ve got data to enter.  Get it done fast by having the app position the cursor in the input field where we should begin.  And when you go to validate, the app can take you directly to the offending entry, even if it scrolled off screen.

» Læs mere

Simplify formulas with the With function

Welcome the With function to Canvas apps!  You can now simplify large formulas by dividing them into named sub-formulas, eliminate redundant sub-formulas, and easily work with functions that return records.  All while staying declarative and automatically responding to dependency changes.

» Læs mere