Do you want to know how to connect your Power Apps and Power Automate Flows to #openai services like Codex and InstructGPT using a custom connector? This video will show you how to do it from start to finish, including all of the troubleshooting techniques I used along the way to make it work properly. And, as a bonus, I used #chatgpt to help me write the swagger definition for the connector. Lots to learn in this video, and these techniques can be used for creating custom connectors for lots of third-party APIs, not just OpenAI!
If you want to learn more about integrating Power Platform with external APIs, check out the Advanced 401 class from PowerApps911 (my day job) here: https://training.powerapps911.com/courses/advanced-power-apps-and-power-automate?ref=acbc2f
0:00 Intro/Demo
1:58 Getting access to the OpenAI developer portal
4:00 Generating OpenAI API key
5:46 Starting the Custom Connector build
6:10 Overview of ways to create a Custom Connector
7:45 Creating the connector “from Blank”
9:00 Asking ChatGPT to write Swagger
11:08 Iterating on the ChatGPT Swagger
12:55 Porting the ChatGPT Swagger to the Custom Connector
14:00 Iterating on the ChatGPT Swagger again
15:00 Fixing ChatGPT’s mistakes in the Swagger editor
18:35 Setting up the Connector’s authentication to OpenAI
20:30 Buttoning up the Connector’s first action and establishing connection
26:04 Testing the Connector’s first action in the Connector designer
27:15 Adding another action using ChatGPT’s Swagger
30:41 Fixing ChatGPT’s Swagger.. again
32:11 Testing the Image Generation action
33:30 Creating the Canvas App
38:30 Troubleshooting null response data
39:30 Fixing the 200 Response for the Image Generation action
42:20 Testing the Image Generation action after response changes
45:15 Testing the Text Completion action
48:00 Fixing the 200 Response for the Text Generation action
49:45 Testing the Text Completion action after response changes
52:30 Recap of what we’ve achieved
53:58 Final thoughts
