Connect Power Automate & ChatGPT-4o with Custom Connector

No video

Connect Power Automate & ChatGPT-4o with Custom Connector

Рет қаралды 3,602

Күн бұрын

In this video we integrate Microsoft 365 Power Automate with ChatGPT-4o. This video does not just show you the obvious things to create the connector but you can repurpose this for any AI API model.
Integrating Power Automate with ChatGPT enables seamless automation of conversational workflows, enhancing productivity by automating responses and task handling. By connecting these tools, businesses can create sophisticated chatbots that handle customer inquiries, schedule appointments, and provide real-time data insights. Power Automate's robust connectors allow ChatGPT to interact with various applications, ensuring a unified and efficient workflow. This integration empowers users to streamline processes, reduce manual efforts, and improve overall operational efficiency.
Compose Statement for Outputs: outputs('Parse_JSON')?['body']['choices'][0]['message']['content']
Chapters:
0:16 Get an API Key
1:30 Starting with Power Automate
2:32 The Configutation of the Custom Connector
6:45 Explaining Important Advanced or Internal
7:55 ChatGPT API Pricing
9:15 Visuallizing your Connector
11:30 Creating a Power Automate Flow with GPT4o
12:50 Using our API Key and Configuring
16:20 Output Message from ChatGPT 4o
19:00 Correcting our Error
20:00 Conclusion

Пікірлер: 30

@JulianTRamon 2 ай бұрын

Andrew, great stuff!!! I really enjoyed this video and will be using it as well as having my team reference it. I like that you worked through real world issues that come up. I don't count it as "mistakes", this is what happens when you are building out flows. It is hardly ever perfect at the first go. Thanks!! Keep them coming.

@andrewhess123 2 ай бұрын

Totally agree Julian, thanks for watching!

@pergaminoadmin1768 3 ай бұрын

Incredible, great explanation of using ChatGPT in Power Automate. I have 1 question and a suggestion for a next video if possible. 1. How can you preserve the context of each Chat so you can continue asking about other related things? sending the previous answers every time? 2. A next video explaining how, through this Power Automate flow, you can load a document, for example, from SharePoint and have the questions answered on the document. An equivalent to creating your own ChatGPT. Thank you so much

@andrewhess123 3 ай бұрын

Ahh yes, 1. I have done this and it's actually how ChatGPT and Copilot work too, literally everytime you ask a question to chatgpt or copilot you don't send 1 prompt, you send all your prompts before and the responses. The LLM then queries those responses and people think oh the LLM is learning from me, but nope, it's sending the entire conversation. It's really neat how it works on the back-end. But yes we can do this! 2. Yes I have done this too! And we will be doing this very soon! Thank you Pergamino. 3. I think we will do pictures and audio too! I have all of those working. Can't wait super excited!!!

@mebangmbourounou3907 Ай бұрын

Excellent demo, Andrew. thank's so much

@andrewhess123 Ай бұрын

Thanks for watching

@Mrkeithhunt 3 ай бұрын

Excellent demo, Andrew! 😎🤘

@andrewhess123 3 ай бұрын

Mr Keith Hunt my Microsoft friend! Thank you! Hope life is treating you extraordinary!

@wendelsilva7055 3 ай бұрын

Thanks for sharing !

@andrewhess123 3 ай бұрын

Thanks for watching Wendel!

@hammadyounas2688 2 ай бұрын

Andrew, excellent work! Could you create a tutorial for using ChatGPT to extract details such as degrees, years of experience, and skills from resumes attached in PDF format?

@fromtoyama Ай бұрын

Andrew, Thanks for your great video. I'm afraid, I'm kind of stuck at the point where the compose function is inserted' I inserted exactly the same code like you but I keep on getting this error message. ""The action 'Compose' contains an invalid reference to 'Parse JSON' in its input parameters. Correct the input parameters to include a valid reference to 'JParse JSON' for the 'Compose' action."

@andrewhess123 Ай бұрын

Hi fromtoyama, Did you change the name of your Parse JSON? If you notice in the compose statement it uses the exact name of that step outputs('Parse_JSON')? Just a guess?

@saeedsm57 3 ай бұрын

Awesome! Thanks Andrew!

@andrewhess123 3 ай бұрын

Thank you Saeed! Your name reminds me of one of my favorite characters from the TV show "Lost". His name was Sayid though, but was a great actor/character!

@saeedsm57 3 ай бұрын

@@andrewhess123 Thank you! That's interesting to hear. I haven't seen Lost myself, but I'll take it as a compliment!😉

@SaikrishnaMaila Ай бұрын

Hi Andrew, can you make a video connecting enterprise GPT with O365.

@AndreyGorbatovs 3 ай бұрын

Thanks for sharing, Andrew. Are there any advantages of making the user connector comparing with using common HTTP module for connection with ChatGPT in a flow? DId you compare the speed of answer which sometimes an issue while using ChatGPT4-th in case of large promts?

@andrewhess123 3 ай бұрын

No comparison for speed that I know of but... making a connection is much easier for your other users at your company who may not be IT. With 4o I have had 0 issues with speed of the answer in the prompt. Those prompt responses are flying! 😁

@AndreyGorbatovs 3 ай бұрын

@@andrewhess123 thanks for your answer. my flows show me the answer of 4o between 7 and 11 seconds at average unfortunately. Hope your way of using custom connection will gives better result..

@andrewhess123 3 ай бұрын

@@AndreyGorbatovs Interesting my flows are around 4 - 7 seconds. Consuming a 3 minute voice .mp3 file took 13 seconds.

@temidayolonge4566 3 ай бұрын

Good Job Andrew

@andrewhess123 3 ай бұрын

Thank you Temidayo !!

@WillCooper1 2 ай бұрын

I want to learn how to upload a document to Chat GPT and then get a response based on a prompt about the file content...

@andrewhess123 2 ай бұрын

Hi Will, there's many ways to do it. You can easily do it in ChatGPT and create a custom GPT upload there and ask questions on it, Doing it specifically from a SharePoint library you need use Power Automate to convert the document to plain text and then send it to ChatGPT. And get a response back. Another way and one of the easiest ways is to use Copilot Studio and point the Custom Copilot to the sharepoint library that contains the documents.