Connect Power Automate & ChatGPT-4o with Custom Connector

Подписаться 8 тыс.

Просмотров 2,7 тыс.

50% 1

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

Наука

Опубликовано:

19 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@mebangmbourounou3907 26 дней назад

Excellent demo, Andrew. thank's so much

@andrewhess123 26 дней назад

Thanks for watching

@JulianTRamon Месяц назад

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 Месяц назад

Totally agree Julian, thanks for watching!

@pergaminoadmin1768 2 месяца назад

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 2 месяца назад

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

@Mrkeithhunt 2 месяца назад

Excellent demo, Andrew! 😎🤘

@andrewhess123 2 месяца назад

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

@wendelsilva7055 2 месяца назад

Thanks for sharing !

@andrewhess123 2 месяца назад

Thanks for watching Wendel!

@saeedsm57 2 месяца назад

Awesome! Thanks Andrew!

@andrewhess123 2 месяца назад

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 2 месяца назад

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

@hammadyounas2688 Месяц назад

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 27 дней назад

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 27 дней назад

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?

@armankarambakhsh4456 Месяц назад

Awesome

@andrewhess123 Месяц назад

Thanks Arman!

@temidayolonge4566 2 месяца назад

Good Job Andrew

@andrewhess123 2 месяца назад

Thank you Temidayo !!

@WillCooper1 Месяц назад

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 Месяц назад

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.

@AndreyGorbatovs 2 месяца назад

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 2 месяца назад

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 2 месяца назад

@@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 2 месяца назад

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