ChatGPT Custom Connector for Power Platform | How to use Chat GPT API in Power Apps & Automate

This ChatGPT and Power Platform step-by-step tutorial video showcases how to build a custom connector that calls the OpenAI Chat GPT API to create custom actions that use Text Completion and Image Generation models within Power Apps and Power Automate.

ChatGPT is a powerful natural language processing API that allows you to generate human-like responses to user input. With a custom connector, you can integrate ChatGPT into Power Platform. You'll learn what custom connectors are and how to create one from scratch to integrate Chat GPT into Power Apps and Power Automate.

I'll start by showing how to set up a custom connector for ChatGPT in Power Platform. Then, I'll demonstrate how to use the connector in Power Apps to call APIs using the DALL.E ("DALL·E" is an artificial intelligence (AI) language model developed by OpenAI, which was trained to generate images from textual descriptions using a GPT-3 based approach) & "Davinci Text Completion" (feature of the GPT-3 language model developed by OpenAI. It is an advanced natural language processing technology that can generate human-like text based on a given prompt) models.

I'll also cover how to leverage ChatGPT custom connector in Power Automate flows. A demo on how to trigger ChatGPT API from Teams conversations will be showcased. You'll learn how to set up a flow that triggers when a user posts a message in a Teams Channel with a specific keyword, use the message body details and call the ChatGPT API to generate a response. This enables calling ChatGPT directly from Microsoft Teams to help answer common queries without human intervention.

By the end of this video, you'll have a good understanding of how to use the ChatGPT API in Power Platform via Custom Connector.

What is a Custom Connector?
While Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps offer over 900 connectors to connect to Microsoft and verified services, you may want to communicate with services that aren't available as prebuilt connectors. Custom connectors address this scenario by allowing you to create (and even share) a connector with its own triggers and actions.

ChatGPT is your friend! ChatGPT is increasing in popularity & with this custom connector implementation we can incorporate it in our Power Apps and Power Automate flows.

#CustomConnector #ChatGPT #OpenAI #PowerAutomate #PowerPlatform #PowerApps #GPT #GPT3 #AI

Table of Contents:
00:00 - Introduction to ChatGPT Custom Connector for Power Platform
00:39 - Custom Connector
01:06 - ChatGPT Image Generation API
01:51 - Create a custom connector for ChatGPT DALL.E model (Image from Text)
07:33 - How to use a custom connector in Power Apps
11:04 - Call custom connector (API) in Power Automate flows
11:51 - Build a Custom Connector for Text Completion API (Davinci model)
15:06 - Call ChatGPT API from PowerApps
16:27 - Call ChatGPT API from Power Automate
16:47 - Call ChatGPT API (Custom Connector) from Teams Channel chat via Power Automate flow
19:00 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[chadalthaus]

I love this, Reza. This is really opening up possibilities with ChatGPT. As always, incredible video tutorial, and many thanks for the content.

[dougydoe]

What more can I great video tutorial but more importantly, exposing us to the possibilities of how we can extend ChatGPT in a very simple but impactful way is brilliant!! Thank you for sharing. I'll definitely make time to replicate this in my environment to master custom connectors.👍🙏

[MrHaider]

Amazing demonstration Reza, apart from the video content the way you make things simple is amazing. And for the content, a huge thumbs up!

[AbhinavJain-rqfl]

Just watched your video and I must say, it was fantastic! Your clear explanation and demonstration of how to integrate Chat GPT with Power Platform was extremely helpful and informative. I appreciate how you walked through the steps of setting up the necessary connections and configurations, making it easier for everyone to follow along and implement it. Looking forward to watching more of your content in the future!

[WillCooper]

This is melting my brain. So many possibilities. Thanks Reza!

[AssassinUK]

Great video. I've been meaning to switch over to this from my Flow, so thanks for this!! Currently have a flow doing all this, being used by a few Apps. I've got it actually holding full conversations (with memory to hold and continue multiple conversations) just like in ChatGPT but I hide the initial prompt as that could hold propriety information the business might not want all users to see, plus users can email out the convo or a message to themselves or others. Aint done the images yet, that looks great!
Might do a video myself on how to hold and keep conversations with GPT3.

[kumailnaqvi]

Great video Brother, 1st step towards AI ChatGPT with powerapps, is very helpful.

[ramseszh]

Amazing video as always. Very interesting, efficient solution and easy to understand. Thank you Reza👍🏼

[superlbc]

That is great content! Thank you!

How do you create a gallery showing all the image responses at once without the need for a drop down index to determine the image to show? I want to see them all at once.
I am trying parsing the response and creating a collection but I struggling to make it work. Any ideas?

[lstgeorge]

Reza all i can say is WOW Awesome video thank you..

[UncleBubba]

Another excellent video, Reza. Huge possibilities here.
Thanks

[saslamofficial]

Hi Reza, thanks for your insights. Did you use US tenant? I tried the MS Teams connector in AU tenant and it seems not working. Thanks,

[kaushar.]

Great post. You always simplify the things to do. I have one question, why does it show the customer connector as premium? Are all custom connectors treated as premium?
Thank you Reza, you are champ.

[esai_toolkit]

Thanks Reza this was great. For some reason I keep getting lost in the "prompt" variable when building the app and txtChat.Text is coming up as an error with improper use of "." Any idea why?

[shaikhfirdos]

Amazing video and the information.. Thanks Reza..for such good videos..👍👏👏

[tonyralph]

Amazing Reza, is it possible to make the Power app search a SharePoint site using the ChatGPT Connector?

[saeedsm]

Watching this video is necessary to every PowerApps developers. Thanks Reza and hope you find more time to make video like this. I was wondering if you could let us how to create action in custom connectors which accept --form multipart/file as well to can create custom control for speech to text OpenAI api(Whisper). Thanks again.

[mandygray]

Great video, Reza! Have you done any videos on how to create pre-defined prompts that the user answers to create an app that generates a very specific output? For example a CV/resume or anything? Many thanks - I love your videos.

[yenumulavenkatesh]

Hey Reza, thanks for exploring new things and showcasing to us....

[giorgiopesciullesi]

Excellent content Reza. Is there simple way to share the app and the connector across the same org each using one API key? currently if I share the app other users are requested to provide a key. thank you