Skip to main content
  1. Blog
  2. Formulas

Power Fx: Column names escape double quotes

Headshot of article author Greg Lindhorst

, Principal PM Architect, Wednesday, April 10, 2024

We are making a small syntax change to how column names are specified in AddColumns, DropColumns, ShowColumns, RenameColumns, Search, GroupBy, Ungroup, and DataSourceInfo functions.  Today they need to be wrapped in double quotes as a text string, but tomorrow they will not.  We will automatically update the syntax in existing apps to reflect the new syntax.  The change makes these functions consistent with other uses of column names, easier to use by no longer requiring logical names, and consistent with other Power Fx 1.0 hosts such as Copilot Studio, Power Automate Desktop, and Cards that have been using this new syntax for the last year.

» Read more

Leverage Power Fx 1.0

Headshot of article author Greg Lindhorst

, Principal PM Architect, Wednesday, September 6, 2023

We are pleased to announce the general availability of open-source Power Fx 1.0. “1.0” means that the language definition is now stable and breaking changes will be managed and communicated. It is now ready for you to integrate in your production work loads. It will be coming to Power Apps later this year.

» Read more

Direct Power Fx Dataverse actions support now in preview

Headshot of article author Lance Delano

, Principal Program Manager, Wednesday, June 21, 2023

We are excited to announce direct access to Dataverse actions in Power Fx formulas as Preview feature (default on.) As a part of the Power Fx language, authors can now directly invoke a Dataverse action within a formula. A new Power Fx ‘Environment’ language object that authors can add to their app enables access to […]

» Read more

Delegation improvements – Async, UpdateIf, and miscellaneous functions

Headshot of article author Lance Delano

, Principal Program Manager, Tuesday, June 6, 2023

We are excited to announce that several key delegation improvements will roll out this month that should improve your app’s performance and correctness and significantly reduce formula authoring confusion. Today, when you author a Power Fx query expression to get data, for instance a Filter, Power Apps will show a double blue underline to indicate […]

» Read more

Try the new Power Fx Formula Bar in Power Apps Studio

Headshot of article author Chris Baldwin

, Principal Product Manager, Power Apps Studio, Monday, March 20, 2023

A new Power Fx editing experience Today we are announcing a new Power Fx formula editing experience in Power Apps Studio.  The new formula editor is available an experimental feature that we encourage you to turn on in your apps and try out!  The new editor is based on the powerful Monaco shared code editor […]

» Read more

Call Dataverse actions directly in Power Fx

Headshot of article author Lance Delano

, Principal Program Manager, Thursday, February 16, 2023

We are excited to announce direct access to Dataverse actions in Power Fx formulas as an Experimental release. As a part of the Power Fx language, authors can now directly invoke a Dataverse action within a formula. A new Power Fx ‘Environment’ language object that authors can add to their app enables access to Dataverse […]

» Read more

Power Fx: Error handling graduates to preview

Headshot of article author Greg Lindhorst

, Principal PM Architect, Monday, August 15, 2022

Reliable error handling moves to preview for Power Fx and Power Apps. You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools. And, bonus, you can also now write blank (or null) values to databases.

» Read more

Power Apps Ideas: New enhancements and increased capabilities

Headshot of article author Norah Liu

, Principal Product Manager, Tuesday, January 11, 2022

After we announced public preview of Power Apps Ideas, including writing Power Fx formulas with natural language and generating formulas from examples, we continued tuning the design and improving our AI model to make Ideas work better for you. Today, we’re happy to share some of the latest updates on Ideas with you.

» Read more
×

Let’s get started

Please enter your work or school account to get started.

Email *

By signing up, you agree to the terms of service.

Privacy statement