Creating and explaining formulas with Copilot now even easier

We are excited to announce the launch of the new “Create a formula” preview feature in Power Apps, designed to make building and editing Power Fx formulas easier and more intuitive than ever before.

Copilot can now also explain partial formulas, which is especially useful for longer formulas where you need an explanation on a specific part of the code.

And to top it off, Copilot in the formula bar will now support more languages, enabling most of our worldwide makers to take advantage of these powerful features.

Create a formula with ease

With the new “Create a Formula” feature, you can now generate Power Fx formulas directly from natural language. Simply select the Copilot button, ask it to create a formula, type your desired action in plain language, and the AI will suggest the appropriate formula and append it wherever the cursor was located when the request was made after you click apply.

This functionality is perfect for both seasoned developers and those new to Power Apps, providing a seamless experience for all users. Remember, formulas are specific to the control and property that is selected, and some actions require working across controls and properties.

Additionally, the maker can use the thumb up/down icons to provide feedback that will help to make the product and AI interactions better over time. By sharing the prompt and response along with your feedback, it helps us understand what we can do to improve.

To enable the Create a Formula Capability, turn on the “Copilot for formulas” flag in Canvas App Settings > Updates > Preview.

Explain a partial formula

In addition to creating formulas, we’ve expanded our formula explanation capability to include the ability to explain a partial formula.

By selecting a formula before clicking the Copilot icon, instead of the “Explain this formula” option, you have the option to “Explain this selection” and get a plain language explanation of what the selected portion of the formula does.

The selection does not have to be precise either, as the Copilot knows when to include context surrounding the selection in order to provide an explanation. This is particularly useful for understanding long or complex formulas that benefit from a more granular explanation.

Worldwide expansion

Copilot support in the formula bar now supports 18 languages. To find out if your language is supported, or to learn more, take a look at the product documentation.

Let us know

We hope you find these new features as exciting and useful as we do. We look forward to hearing your feedback and seeing the innovative ways you use them in your apps. Stay tuned for more updates and enhancements in Power Apps!