How To Integrate ChatGPT With Microsoft Outlook Using Power Automate

No video

How To Integrate ChatGPT With Microsoft Outlook Using Power Automate

Рет қаралды 72,694

Күн бұрын

In recent months, the popularity of AI tools has risen significantly, and ChatGPT is one of them. These tools offer a range of benefits, including the ability to automate repetitive tasks, analyze data, and provide personalized recommendations. By leveraging the power of AI, organizations can streamline workflows and improve productivity.
Furthermore, AI tools can help identify patterns and insights that would be difficult for humans to detect, leading to more informed decision-making. In this tutorial, Henry is going to demonstrate how you can integrate ChatGPT with Microsoft Outlook using Power Automate.
****Video Details****
00:00 Introduction
00:25 Use case
02:57 How the API works
05:53 Power Automate flow
07:02 HTTP request
09:17 Parsing JSON
10:06 Connecting to Outlook
11:11 Saving the flow
11:24 Executing the flow
12:32 Fail condition
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand - app.enterprisedna.co
Enterprise DNA Subscription - app.enterprisedna.co/pricing
Enterprise DNA Events - www.enterprisedna.co/events
#EnterpriseDNA #PowerAutomate #PowerAutomateTutorial #ChatGPT #MicrosoftOutlook #AI

Пікірлер: 39

@EnterpriseDNA Жыл бұрын

Check out our FREE courses: bit.ly/3N00AJw

@KarlSwift Жыл бұрын

This is the sort of tutorial video that I can actually follow for a change. Thank you

@EnterpriseDNA Жыл бұрын

Hi Karl, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@planck8181 2 ай бұрын

Can you elaborate more on the fail condition please because it is working for me but I am getting the trimmed email sent mulitple times. Thanks!

@emangarrison Жыл бұрын

This is worth a try. I also need a way to manage my email as data by file name, creation dat, etc. anything to manage actions, tasks that the sender requires.

@EnterpriseDNA Жыл бұрын

Hi @emangarrison, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

@SouthmoorCPE Жыл бұрын

Hi, thanks for sharing this; however, you lost me at PostMan..... do you have any other videos to walk through the API / PostMan sections please?

@EnterpriseDNA Жыл бұрын

Hi SouthmoorCPE, I'm afraid we don't have that title yet. But we'll include this in our list of possible topics for our future videos. Cheers!

@carlosnazario8346 Ай бұрын

Great tutorial but can you elaborate more on the fail condition please? I accidentally left the loop running and got billed significant amount on the api usage

@mohammadalkhatib5541 2 ай бұрын

Great example, thanks. I do have a question though, how should i stop it from sending emails over and over. Also, can it be deployed for all users for example, a chatbot in Teams

@TonyMontana-dq8sr Жыл бұрын

Any idea how to format the JSON/text so it looks better, instead of a 1 line raw data?

@textclever 11 ай бұрын

Great tutorial but the tokens never seem to be enough (4097). Even for the most basic email to summarize the key points. Am I doing something wrong?

@GuardiansFortress2-rr6tu 7 ай бұрын

I'm trying to get shorter responses back from ChatGPT. Do I do that with fewer tokens? When I set the max_tokens to 100, the response cuts off and isn't complete. The response stops mid-sentence.

@polaroidsky Жыл бұрын

In the final step under the Reply to Email section, there is no Parse Json text option under dynamic content. The only json option available is the body option. Why might this be?

@humbugable 7 ай бұрын

Great video. Is there a way to auto forward instead of manually forwarding every email?

@rifujin6269 6 ай бұрын

Maybe with a Rules from Outlook directly ?

@polaroidsky Жыл бұрын

If anyone experiences the error below, you need to go to billing and set up your card to be charged (minimally) for tokens: "You exceeded your current quota, please check your plan and billing details."

@EnterpriseDNA Жыл бұрын

Thanks for the tip!

@ZayXVII Жыл бұрын

it gives me monthly and annual, 19$, 39$ etc. where is the minimal charge?

@polaroidsky Жыл бұрын

@@ZayXVII You don't actually purchase anything. You just connect your card to your account. That's all.

@ZayXVII Жыл бұрын

it says in order to connect my card to my account, I need to buy the membership thing@@polaroidsky

@mohamedelaminesoltani3045 Жыл бұрын

where did you get the link that you past in authorization please

@sarkhanmammadli9673 Жыл бұрын

thanks a lot!

@EnterpriseDNA Жыл бұрын

Hi Sarkhan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@shawnbennett4663 Жыл бұрын

Could this be triggered with an exception for character count? If exceeds x amount, THEN summarize key points?

@BluntzDK Жыл бұрын

I get this error: "type": "insufficient_quota". Any idea why that is? I have ChatGPT+

@TahsinNazimTahsin Жыл бұрын

same here

@TahsinNazimTahsin Жыл бұрын

@EnterpriseDNA, what is the solution?

@bpwebsites2766 4 ай бұрын

What about Uber Iets?

@israelgalindo3328 Жыл бұрын

hey buddy got it work all the way through but testing even the simple 3 sentence messages, i get this in every test: This model's maximum context length is 4097 tokens, however you requested 9984 tokens (7984 in your prompt; 2000 for the completion). Please reduce your prompt; or completion length. Any thoughts? i did test with the most simple emails that had very few words

@koong447 Жыл бұрын

I am facing the same issue. Even with very short sentences, the same token error occurs. How can I fix this? It seems like you were successful with much longer sentences in the video.

@BARDOK76 Жыл бұрын

I've the same problem. Is there any solution ready?

@zultanerz Жыл бұрын

Same here

@nich2533 Жыл бұрын

The ChatGPT model is limited to 4,097 tokens. Tokens are something like words (2 tokens per word) and the limit refers to the total words used in the prompt + words used in the response. So if you have a really wordy prompt, then ask for 4,000 tokens back, its going to say you're exceeding the limit. Fix it by limiting the length of your prompt, and changing the token threshold to a smaller number, like 3,000.

@adamsnow1447 Жыл бұрын

@@nich2533 My prompt is "please summarize the following email", but it says my prompt is 6097 tokens. I'm guessing the test email message that Power Automate is sending is too long - but can't really know for sure.

@dooshakhaboosha2573 11 ай бұрын

Forward to yourself? Might as well copy and paste into chat gpt

@EnterpriseDNA 11 ай бұрын

Hi @dooshakhaboosha2573, the suggested solution is for those with who wouldn't want to do the copy+paste route. This is especially helpful if you're dealing with high volume of emails. Hope this clarifies!

@TheSnoopaloop86 Жыл бұрын

Came here to seek efficient and consistent e-mail productivity. Brb. Now seeking another GPT to write code and generate flow. Maybe, I’ll just hit “reply” and knock out that super tasking email.

@EnterpriseDNA Жыл бұрын

Hi @TheSnoopaloop86a, we hope you find AI tools helpful so far!