Skip to content

Using Copilot to Create and Explain Formulas – Power Apps

Using the new features – Create a formula (preview) and Explain this formula we can now easily write, edit, and understand formulas in Power Apps.

To enable it, navigate to switch on – Settings >> Updates >> Preview >> Copilot for formulas

Here in the sample app below, we are trying to set the Items property of the Gallery using Create a formula. Here our gallery control is bound to Cases as the data source.

A screenshot of a computer

Description automatically generated

We can describe what formula we need in plain language.

A screenshot of a computer

Description automatically generated

We can see it generating the formula for us. We have the option to Apply, Discard, and Copy it.

A computer screen with a blue background

Description automatically generated

Here we have applied the generated formula.

A screenshot of a computer

Description automatically generated

Another example is where we are setting the Text property.

Here instead of the customer name it considered the Customer Contacted field. So basically we need to review the formula generated.

A screenshot of a computer

Description automatically generated

We can also generate formula from code comments as show below. Simply type the comment and wait for formula to be generated or otherwise press Enter.

The result

Next using Explain this formula we can use the copilot’s ability to explain the formula in plain language.

The result

A screenshot of a computer

Description automatically generated

We can also select specific parts of the formula for explanation.

Below we have selected the Filter keyword and Explain this selection option.

A computer screen with text and arrows pointing to the right

Description automatically generated

The result

A screenshot of a computer

Description automatically generated

Similarly, on selecting SortOrder

A computer screen shot of a computer screen

Description automatically generated

The result

A close-up of a text

Description automatically generated

Get all the details here

Hope it helps..

Advertisements


Discover more from Nishant Rana’s Weblog

Subscribe to get the latest posts sent to your email.

Unknown's avatar

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Nishant Rana originally posted this article on 18 November 2024 at 8:30 PM.

Leave a Reply