Power Automate and ChatGPT: How to Create a Custom Connector

[@andersjensenorg]

Network and solve advanced Power Automate problems. Join the I Love Automation discord: kzbin.info/www/bejne/roipq2CJbpuLfdE We're more than 6000 RPA developers united 🧙‍♂🔥

[@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]

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

[@dannyhometown]

Awesome Tips, thanks for your sharing, Anders! 👍

[@andersjensenorg]

Thanks a ton, Danny 🙌🥳

[@willianrom]

Nice video, hi from Curitiba city in Brazil.

[@andersjensenorg]

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

[@stineandtherobots]

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 😘😘❤❤

[@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]

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: kzbin.info/www/bejne/b5qYhHqMntJoa7M

[@tysondo3663]

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

[@ghulampambudi4606]

Hi Anders, thanks for a nice video. but could we make it but for Microsoft Copilot?

[@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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@pepper_lab]

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

[@andersjensenorg]

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

[@hammadyounas2688]

Great work, Can you please create a tutorial that we give pdf directly to this ChatGPT custom connector, that extract the data from pdf

[@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 12,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@hammadyounas2688]

@@andersjensenorg yeah that much message can you make a tutorial on that?

[@Aamiraps]

i am also looking for the same

[@janardhan559]

Hi Anders Can we use a Custom Connector to Execute the Attended BOTs? My Idea was, that there is a chatbot Application. I want this BOT to list all the current Flows from PAD and when I choose a particular process it should trigger the Flow. Could you please suggest to me the way to achieve this?

[@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 12,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@Caleb_Spotz]

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

[@andersjensenorg]

Sure: kzbin.info/www/bejne/h33caqGAo76gm5I 🙏🙂

[@Caleb_Spotz]

@@andersjensenorg oh thank you!!!

[@2010Azabache]

Amazing!!!!

[@andersjensenorg]

Thanks a lot, Carlos 🙂🙌

[@rayuduaddagarla5629]

Is the tokens counted by input or output?

[@andersjensenorg]

Input 🙂

[@armankarambakhsh4456]

Perfect

[@andersjensenorg]

Many thanks 😊

[@aninhabitantofcarcosa9345]

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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@aninhabitantofcarcosa9345]

@@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

[@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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@AnuragKumar-sz6yw]

Do we need license for this to connect in flow?

[@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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@iyengar007]

@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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@inanozgur1]

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

[@zafarshamsi-786]

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

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@zafarshamsi-786]

I'm thankful for your valued response@@andersjensenorg

[@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]

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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@McFadyenMarketplace]

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

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@julianvandenberg2002]

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]

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

[@andersjensenorg]

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

[@demo9535]

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]

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

[@demo9535]

@@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]

I have same problem

[@edriskazemi]

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

[@AzharHossain]

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