New Power Automate GPT Connector

wyattdave

david wyatt

Posted on July 17, 2023

New Power Automate GPT Connector

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.

create text with GPT

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.

ai connector

The connector has 4 default templates and create from blank.

gpt prompts

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

  1. Summarize Text
  2. Extract Information
  3. Classify Text
  4. Create Blog
  5. All the rest (Create from blank)

1. Summarize Text

create prompt

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.

test prompt

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 info

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

extract info demo

pretty cool 😎

3. Classify Text

classify text

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

categorise

4. Create Blog

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.

blog demo

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)

blank prompt

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.

find demo

I use 'Find' for answering questions like above for https://powerautomate.microsoft.com/en-us/pricing/

You can also translate

translate demo

Count/Sum

sum demo

and much much more, you are only limited by the prompts you can think of.

code demo

Yep it even writes code, that works too 😎


Chat GPT was democratized AI, I think Create text with GPT connector democratizes AI to Low Code and Power Automate Developers


Further Reading

💖 💪 🙅 🚩
wyattdave
david wyatt

Posted on July 17, 2023

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related