New Power Automate GPT Connector

#gpt3 #powerautomate #powerplatform #lowcode

There are lots of ways to get Chat GPT power into your flows, but before they require OpenAI and a custom connector. But now there is a new connector out of the box and ready to go with no effort.

The Create text with GPT is an AI builder connector, but there are a couple of points to consider

It's in preview so might change
As its preview its free, which is great but we don't know how much it will cost
Requires environment feature ins settings 'AI Builder Preview Models' turned on
This is GPT not Chat GPT, so same model but hosted by Mircosoft not OpenAI
Again as its in preview so little documentation around token limit

That a side, its pretty cool, and it solves problems that only a Human in the Loop could of (Check out my previous blog on why Human in the Loop is so Powerful here)

To use the connector we need to create the prompt we are going to send to the model, we can paste it directly in or, the easier way, use the prompt templates.

The connector has 4 default templates and create from blank.

The templates are based on prompts, and though they cover the most used there are many more.

Summarize Text
Extract Information
Classify Text
Create Blog
All the rest (Create from blank)

1. Summarize Text

As you can see we have 4 main parts of out prompt creator

Prompt
Question/Key Data
Fail threshold and action
Context text

In this template its

Summarize
Less then 2 paragraphs without adding new information
If less than 1 paragraph return 'can't summarise a text that is too short'
#include your text here

So to use it we would change '#include your text here' to our input text.

We can test the model to make sure it's right and make edits to any of the parts.

Context text - https://powerautomate.microsoft.com/en-us/blog/announcing-public-preview-of-customer-managed-encryption-keys-for-power-automate/

Summarized Test - This text announces the public preview of Customer Managed Encryption Keys (CMK) for Power Automate. CMK provides customers with added control over their data, especially for highly regulated industries like Healthcare and Financial Services. It allows customers to leverage an encryption key from their own Azure Key Vault and apply it to any Power Platform environment. Additionally, admins can "lock" an environment to ensure total lockdown of their data.

2. Extract Information

Extract has the same 4 parts, but in this example changed to:

Extract
Container numbers and registration numbers
If less than couple of words, answer that you can't extract information.
We are pleased to inform you that the shipment clearances for....

If we test with the same context text from here https://powerautomate.microsoft.com/en-us/blog/announcing-public-preview-of-customer-managed-encryption-keys-for-power-automate/ we get:

Extracted text - Author: Rakesh Krishnan
Where to send questions and feedback: Power Automate Community

pretty cool 😎

3. Classify Text

You can see the pattern; we just change our main parts, like prompt.

4. Create Blog

Again same pattern, but this one shows how far you can push the 'Question/Key Data' to get as precise as you need.

Context text - https://powerautomate.microsoft.com/en-us/pricing/

Summarized Test - Power Automate is an incredibly powerful tool that can help businesses automate their processes and tasks, saving time and money. With Power Automate, businesses can choose from a variety of subscription plans to best fit their needs.

The per-user plan is great for individuals who want to automate cloud apps, services, and data with digital process automation (DPA). This plan allows people to create and run unlimited flows for just $15 per user/month.

For businesses that need to automate legacy apps on a desktop, the per-user plan with attended RPA is the best option. This plan includes the same capabilities as the base plan, plus the ability to automate legacy apps on a desktop via robotic process automation (RPA) in attended mode for $40 per user/month.

For businesses that want the flexibility to pay only when a person runs a flow connected with premium connectors, the pay-as-

Not bad effort with the notoriously difficult Microsoft Licenses

5. All the rest (Create from blank)

After using it a few times you will find yourself using the blank more often, as you can see the structure is consistent and easy to follow without templates.