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
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 🧙♂🔥
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
Жыл бұрын
Appreciate the love, thanks a lot, Ammad ❤️😎
Awesome Tips, thanks for your sharing, Anders! 👍
@andersjensenorg
Жыл бұрын
Thanks a ton, Danny 🙌🥳
Nice video, hi from Curitiba city in Brazil.
@andersjensenorg
Жыл бұрын
Hey William, thanks a lot, from Trørød in Denmark 🙂
Awesome 👍👍👍👍👍👍😎😎😎😎 Thank you 😊😊😊😊
@andersjensenorg
Жыл бұрын
Haha, my biggest pleasure, autobase 🥳🥳🥳🥳🥳😍😍😍😍😎😎😎 Have a great day. Kind regards, Anders
Love your new I Love Automation Shirt 😍❤️👌🏻
@andersjensenorg
Жыл бұрын
Thanks a lot. How about the dance and music at 15:56? 😅
@stineandtherobots
Жыл бұрын
@@andersjensenorg that too - you know I'm proud to say I'm you number 1 biggest fan 😘😘❤❤
Amazing!!!!
@andersjensenorg
Жыл бұрын
Thanks a lot, Carlos 🙂🙌
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
Жыл бұрын
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
Жыл бұрын
Hi Tyson, Samuel Boulanger has a great tutorial on that here: kzread.info/dash/bejne/a51ptamPmdCbZbQ.html
@tysondo3663
Жыл бұрын
@@andersjensenorg I am looking forward to that tutorial. it will benefit the whole team to have chat gpt right inside the team room
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
7 ай бұрын
Hey Julian. Click More (the three dots in the menu) and then Discover 🙂
@andersjensenorg
7 ай бұрын
Oh, you did it yourself. Thanks a lot for coming back 🙌🙂💯
Hi, can you show the setup for power automate desktop?
@andersjensenorg
Жыл бұрын
Sure: kzread.info/dash/bejne/g4Ctm9CDnrzTlZM.html 🙏🙂
@Caleb_Spotz
Жыл бұрын
@@andersjensenorg oh thank you!!!
Sir, is that possible we add speech to text with power virtual agent chat bot
@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
7 ай бұрын
I'm thankful for your valued response@@andersjensenorg
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
Жыл бұрын
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
I will try to configure this to create automate posts for internal Yammer skills education asking to GPT and posting response in Yammer
@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
@anders Jensen: Can you please create a simple/basic app to show how we can integrate this in PowerApps
@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
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
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
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
Is the tokens counted by input or output?
@andersjensenorg
Жыл бұрын
Input 🙂
Anders, when i execute the flow, i'm getting "The model `"text-davinci-003"` does not exist"
@andersjensenorg
Жыл бұрын
Very strange, can you please try again. It should work: platform.openai.com/docs/models/gpt-3-5 Kind regards, Anders
hi, i got below error when i test app in power automate connector Operation failed (500), see response below
@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
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
11 ай бұрын
Hey Demo, can you please check your account? You might not have the $18 free credit. Kind regards, Anders
@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
10 ай бұрын
I have same problem
@edriskazemi
10 ай бұрын
@@demo9535 Did you fix it ? if yes how ?
Isn’t this just GPT and not ChatGPT?
@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