Learn how to add ChatGPT to Microsoft Teams 04-12-2023 11:06 AM

[Adam_deMont]

ChatGPT is a revolutionary Artificial Intelligence (AI) technology that has the power to change the way we work. Now that Microsoft has invested heavily in OpenAI, it’s only a matter of time before their capabilities are built into the Microsoft 365 and Azure platforms. By using Power Automate to integrate that technology into Microsoft Teams, you can effortlessly access those AI capabilities directly from a Teams channel now without having to wait for Microsoft. You will only need one OpenAI account in order for everyone in that channel to use ChatGPT from within Teams. Anyone with access to that channel can simply post a question to ChatGPT, and an automated cloud flow will trigger. The flow will get the message details from the user and pass the question, as a variable, to an HTTP POST request to ChatGPT. Once the request returns the answer response from that site, it is used as a variable to reply to the user who asked it in the thread where it was asked.

https://fortechsupport.com/blog/learn-how-to-add-chatgpt-to-microsoft-teams/

Please let me know what you think.

watch?v=U00hiV1I_S0

[krzyazn]

I don't see automated cloud flow in my O365 gov tenant.

[arosarioFDS]

Never mind, I realized I had clicked on the HTTP search result which presented me with those three HTTP options I mentioned.  After clicking on the HTTP PREMIUM, I was able to see the textboxes w/ those properties in your video.

[arosarioFDS]

I was able to get as far as adding the HTTP action, but I don't see any of the properties shown in your video there.  It just shows HTTP, HTTP + Swagger, and HTTP Webhook all with the word "PREMIUM" next to it.  My guess is my company doesn't have access to Premium.

[arosarioFDS]

I found it now.  I could have sworn I tried that earlier and wasn't seeing it.  I may have been in the Templates tab instead.  I will try it out now, thanks.

[Adam_deMont]

What options do you have when you click "Create" in Power Automate?

As of right now, my options are still: Automated cloud flow, Instant cloud flow, Scheduled cloud flow, Describe it to design it, Desktop flow, and Process advisor.

[arosarioFDS]

As of this writing, the "Automated Cloud Flow" template is not available.  My guess is MS removed it as part of the work they are doing to integrate ChatGPT into Teams.

[Adam_deMont]

Hi. Thanks for checking it out! 

It is probably just a matter of time before more OpenAI capabilities will be included in all the M365 apps.

I created another video covering how to setup custom connectors for the different OpenAI models so they can be used in Power Automate flows. If you use the gpt-3.5-turbo model, you can make use of the different roles (system, user, assistant) and that might help you accomplish what you are trying to do. You can probably use the Dropbox content to grab the content of that book, then send it using the custom connector for the gpt-3.5-turbo model (ChatGPT model). Here is the link to that other video in case you want to try that approach. https://www.youtube.com/watch?v=iVxKY2LJ1Dg 

[blusanders]

Hi. Thanks for this. Is it possible to train Chat GPT against a Sharepoint knowledgebase for example?Is that where CoPilot is headed?

When I've played around w a screenplay for example I gave Chat GPT a Dropbox link to consume my book. Then it could answer related questions.

Thanks!

[Adam_deMont]

Thank you @KengSeongLim99 for adding all that additional information I left out in the recording!

Also, I created another video that shows how to build Power Automate custom connectors for DALL-E, GPT-3, and GPT3.5 (ChatGPT)

https://www.youtube.com/watch?v=iVxKY2LJ1Dg

[KengSeongLim99]

Hi everyone!

Tested & worked perfectly! ✅ Thanks for your sharing @Adam_deMont 😊🤝

How I had configured in Power Automate: 

1. 
2. 
3. 
4. 
5. 
   

   Once you successfully called the API from OpenAI, you will notice that your OpenAI Account Usage Dashboard has reflected the charges. 
   
   

Key things to take note 📝: 

• You need to purchase some credits from Billing overview - OpenAI API. if you do not have Free Trial.
  • $5 ~ $10 USD is sufficient for testing investment 😀
  • More details: Pricing (openai.com)

• The solution owner required to purchase x1 Microsoft Power Automate Per User Plan
  • Reason:  HTTP Action in Power Automate required Premium Connector that included in paid license plan. 
  • More details: Pricing | Microsoft Power Automate