Power Automate and ChatGPT: How to Create a Custom Connector

Ғылым және технология

This video tutorial shows how to integrate ChatGPT in Microsoft Power Automate. You'll learn how to create a Custom Connector using the OpenAI API.
📂 My ChatGPT/PA helping text document: drive.google.com/drive/folder...
VIDEOS FOR YOU:
🔹 REST API Calls in Power Automate: • REST API Calls in Powe...
🔹 The Power of ChatGPT in Power Automate Desktop Development: • The Power of ChatGPT i...
POWER AUTOMATE GROUPS:
👨‍👩‍👧‍👦 Discord: / discord
- Join my network with 6000+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!
👩🏻‍🎓 LinkedIn: / 12566435
👨🏻‍💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: and
ersjensen.org/email-newsletter
0:06 Create a Custom Connector
We want to create a custom connector in Power Automate using the OpenAI GPT3 API. Using the ChatGPT logo, it looks super cool.
1:57 Security
We specify the API key authorization in the Security section.
2:31 Definition
In the Definition step, we define the endpoint to OpenAI. We also specify the headers and the body of the HTTP Request. Use the POST method.
5:54 Test the Custom Connector
Establish the new connection by specifying the API Key. Obtain the API key from the OpenAI website. Specify the parameters, and we will test our new ChatGPT connector.
7:52 Response
Specify the structure of your response so Power Automate understands it.
8:18 Default Parameter Values
We don't want to specify the parameter values of the custom connector each time the flow runs, so we specify default values.
10:51 Using the Custom Connector
Our custom connector is now ready to use in any flow we want. Instead of the dynamic output from the connector, we use an expression to save bytes.
#powerautomate #powerplatform #microsoft365

Пікірлер: 50

  • @andersjensenorg
    @andersjensenorg Жыл бұрын

    Network and solve advanced Power Automate problems. Join the I Love Automation discord: kzread.info/dash/bejne/qot63I-MaZm-d9I.html We're more than 6000 RPA developers united 🧙‍♂🔥

  • @ammadkhan4687
    @ammadkhan4687 Жыл бұрын

    Again Saluting you. Man I watched so many video over this theme. The way you solved that problem of apply to each no one has shown this way. Amazing.....

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Appreciate the love, thanks a lot, Ammad ❤️😎

  • @dannyhometown
    @dannyhometown Жыл бұрын

    Awesome Tips, thanks for your sharing, Anders! 👍

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a ton, Danny 🙌🥳

  • @willianrom
    @willianrom Жыл бұрын

    Nice video, hi from Curitiba city in Brazil.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hey William, thanks a lot, from Trørød in Denmark 🙂

  • @autobase16
    @autobase16 Жыл бұрын

    Awesome 👍👍👍👍👍👍😎😎😎😎 Thank you 😊😊😊😊

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Haha, my biggest pleasure, autobase 🥳🥳🥳🥳🥳😍😍😍😍😎😎😎 Have a great day. Kind regards, Anders

  • @stineandtherobots
    @stineandtherobots Жыл бұрын

    Love your new I Love Automation Shirt 😍❤️👌🏻

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot. How about the dance and music at 15:56? 😅

  • @stineandtherobots

    @stineandtherobots

    Жыл бұрын

    @@andersjensenorg that too - you know I'm proud to say I'm you number 1 biggest fan 😘😘❤❤

  • @2010Azabache
    @2010Azabache Жыл бұрын

    Amazing!!!!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, Carlos 🙂🙌

  • @tysondo3663
    @tysondo3663 Жыл бұрын

    Thank you for the tutorial. Can you show us how to make this works via ms team room? We can use a keyword to call out chatgpt and start asking it directly from ms team teams room.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hey Tyson. Certainly possible. I would love to create a detailed ChatGPT/Teams/Power Automate guide soon 🙂 Have a great day. Kind regards, Anders

  • @jibbsautomations

    @jibbsautomations

    Жыл бұрын

    Hi Tyson, Samuel Boulanger has a great tutorial on that here: kzread.info/dash/bejne/a51ptamPmdCbZbQ.html

  • @tysondo3663

    @tysondo3663

    Жыл бұрын

    @@andersjensenorg I am looking forward to that tutorial. it will benefit the whole team to have chat gpt right inside the team room

  • @julianvandenberg2002
    @julianvandenberg20027 ай бұрын

    the data tab appears to be gone since the september 20 ui update, and i have been unable to find the custom connector creation tool ever since edit: if anyone sees this, press more > Discover all and you will be sent to a tab that supports it, or just paste /connections/custom after your logged in power automate url

  • @andersjensenorg

    @andersjensenorg

    7 ай бұрын

    Hey Julian. Click More (the three dots in the menu) and then Discover 🙂

  • @andersjensenorg

    @andersjensenorg

    7 ай бұрын

    Oh, you did it yourself. Thanks a lot for coming back 🙌🙂💯

  • @Caleb_Spotz
    @Caleb_Spotz Жыл бұрын

    Hi, can you show the setup for power automate desktop?

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Sure: kzread.info/dash/bejne/g4Ctm9CDnrzTlZM.html 🙏🙂

  • @Caleb_Spotz

    @Caleb_Spotz

    Жыл бұрын

    @@andersjensenorg oh thank you!!!

  • @zafarshamsi-786
    @zafarshamsi-7868 ай бұрын

    Sir, is that possible we add speech to text with power virtual agent chat bot

  • @andersjensenorg

    @andersjensenorg

    7 ай бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @zafarshamsi-786

    @zafarshamsi-786

    7 ай бұрын

    I'm thankful for your valued response@@andersjensenorg

  • @ammadkhan4687
    @ammadkhan4687 Жыл бұрын

    Anders could you please make some content to get the reply from chatgpt only from the information which I provide. I need to make helpdesk reply but we have our own pdf which should be used to send the reply. I hope I clear my prompt here ;)

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @alejandrozavala6658
    @alejandrozavala6658 Жыл бұрын

    I will try to configure this to create automate posts for internal Yammer skills education asking to GPT and posting response in Yammer

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @iyengar007
    @iyengar007 Жыл бұрын

    @anders Jensen: Can you please create a simple/basic app to show how we can integrate this in PowerApps

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @aninhabitantofcarcosa9345
    @aninhabitantofcarcosa93453 ай бұрын

    In section 2: Security, when I have to choose the Authentication type it only appears: No Authentication, Basic Authentication and Windows Authentication. How can I make API-Key appear among the options?

  • @andersjensenorg

    @andersjensenorg

    3 ай бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @aninhabitantofcarcosa9345

    @aninhabitantofcarcosa9345

    3 ай бұрын

    @@andersjensenorg Hi!! No problem, thanks for answering!!! I found the problem, it was because I was selecting the field "Connecting using a Gateway" in the section 1. After disable that option, it was appearing

  • @rayuduaddagarla5629
    @rayuduaddagarla5629 Жыл бұрын

    Is the tokens counted by input or output?

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Input 🙂

  • @inanozgur1
    @inanozgur1 Жыл бұрын

    Anders, when i execute the flow, i'm getting "The model `"text-davinci-003"` does not exist"

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Very strange, can you please try again. It should work: platform.openai.com/docs/models/gpt-3-5 Kind regards, Anders

  • @McFadyenMarketplace
    @McFadyenMarketplace11 ай бұрын

    hi, i got below error when i test app in power automate connector Operation failed (500), see response below

  • @andersjensenorg

    @andersjensenorg

    10 ай бұрын

    Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders

  • @demo9535
    @demo953511 ай бұрын

    Got this error in the body- { "error": { "message": "You exceeded your current quota, please check your plan and billing details.", "type": "insufficient_quota", "param": null, "code": null } } It didnt work for me atleast once for free..

  • @andersjensenorg

    @andersjensenorg

    11 ай бұрын

    Hey Demo, can you please check your account? You might not have the $18 free credit. Kind regards, Anders

  • @demo9535

    @demo9535

    11 ай бұрын

    @@andersjensenorg I have checked, and previously $18 free credit would be there but its only $5 currently so I am not sure now how to use this $5 wisely, should I reduce the max tokens to 20 or 30 will it work then?

  • @edriskazemi

    @edriskazemi

    10 ай бұрын

    I have same problem

  • @edriskazemi

    @edriskazemi

    10 ай бұрын

    @@demo9535 Did you fix it ? if yes how ?

  • @AzharHossain
    @AzharHossain Жыл бұрын

    Isn’t this just GPT and not ChatGPT?

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    You're right, and I also state it in the video. It will be the same approach once the ChatGPT API becomes available 🙂 Kind regards, Anders

Келесі