Tuesday, November 28, 2023

Write formulas from natural language or examples using Copilot


Hello LinkedIn Community,

I'm thrilled to share with you the latest game-changing feature from Microsoft Power Platform that is set to redefine the way we interact with formulas. Say hello to "Write Formulas with Copilot," a cutting-edge feature that allows you to craft complex formulas effortlessly using natural language or examples.


Feature Details

Makers can now use Copilot to write formulas using natural language or by providing examples. This functionality was previously available through Power Apps Ideas and will be updated and combined with Copilot to provide makers with a consistent and unified experience to increase their productivity.


The Copilot Advantage: Bridging the Gap Between Ideas and Implementation

**1. ** Natural Language Formulas:

Have you ever wished you could express your formula ideas in plain English and have them magically translated into functional code? Well, with Copilot, now you can! This feature enables you to write formulas using natural language, making the process of creating complex expressions as simple as putting your thoughts into words. Whether you're a seasoned developer or a business user, the power of Copilot is at your fingertips.


**2. ** Example-Driven Formulas:

Sometimes, the best way to convey your formula logic is through examples. Copilot allows you to provide examples of input and output, and it intelligently generates the corresponding formula. This is a game-changer for those who prefer a more hands-on, visual approach to formula creation. With just a few examples, you can guide Copilot to understand your intent and generate the code for you.


**3. ** Reducing Development Time:

Time is of the essence in today's fast-paced world. With Copilot, Microsoft is not only making formula creation more accessible but also significantly reducing the time it takes to bring your ideas to life. Whether you're working on a complex mathematical calculation or a data transformation task, Copilot is here to accelerate your development journey.


Getting Started with Copilot: Empowering Your Formula Creation

**1. ** Integrated Experience:

Copilot is seamlessly integrated into the Power Platform environment, making it an integral part of your formula creation process. You'll find it across various Power Platform products, ensuring a consistent and intuitive experience.


**2. ** User-Friendly Interface:

Microsoft has prioritized user experience in the design of Copilot. The interface is intuitive, allowing users to effortlessly interact with the feature. Whether you're a beginner or an experienced developer, Copilot's user-friendly design ensures that you can leverage its capabilities with ease.


**3. ** Comprehensive Documentation:

Microsoft understands the importance of supporting users in adopting new features. Copilot comes with comprehensive documentation and guides to help you navigate its capabilities effectively. Whether you prefer learning by doing or delving into detailed instructions, the resources are there to support you.


Unleashing Creativity with Copilot: Transforming Formula Creation

Take advantage of "Write Formulas with Copilot" and embark on a journey where the language you speak is the language your formulas understand. Microsoft Power Platform continues to push the boundaries of innovation, making technology more accessible and empowering users to turn their ideas into reality.

Let's write formulas the way we think, the way we talk, and the way that best suits our unique perspectives. Copilot is here to bridge the gap between ideas and implementation, and the possibilities are limitless!

Example 1: Natural Language Formula

Intent: Sum the values in a column based on a specific condition.

Natural Language Input:

"Create a formula that sums up the 'Sales' column only for rows where the 'Product' column is equal to 'Widget'."

Generated Formula:

=SUMIFS(Sales, Product, "Widget")

Example 2: Example-Driven Formula

Intent: Create a formula to calculate the average revenue per customer.

Example Input:

Example 1: If the Revenue is $500 and the Customer Count is 5, the formula output should be $100.

Generated Formula:

=Revenue / CustomerCount

Learning Resource for Power Platform

Power Platform Self-Paced Course


Instructor Led Live Classes


Recorded Webinars


No comments:

Post a Comment

Thanks for your time reviewing this blog.