Learn how to add ChatGPT to Microsoft Teams 05-23-2023 16:58 PM

[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

[ianwuk]

@MFS Can you possibly share how you set these flows up?  I also get the looping as well and I am not sure how to stop it.

Thank you!

[bbruton]

I figured it out, for some reason my HTTP was named 'HTTP 2' and attempting to call 'HTTP' from the expression didn't work because that name didn't exist. Thanks for the video, works great!

[bbruton]

At the very end when I run the flow checker, it gives me this error: 

Correct to include a valid reference to 'HTTP' for the input parameter(s) of action 'Reply_with_a_message_in_a_channel'.

That is using your expression: 

body('HTTP')?['choices'][0]?['text']

When I attempt to just call the HTTP body dynamic, the flow works but it sends me the whole JSON body obviously. But using the expression you provided doesn't want to run at all.

[Ami99]

Here are the screens

Thank you !

[DCovC1]

Can you copy the contents of the boxes with the error messages here? I saw a piece of the code which seemed like you were doing something related to HTML, but I can't quite tell what that is unless I see that.

[Ami99]

Hello,

I seem to have entered the API key correctly as requested.

Bearer sk-ZNjv--------------------------------------QyrwMWd

here on screen 

[DCovC1]

Essentially, you would have to build a back and forth with a JSON capturing the previous information and building on that since there really isn't a 'session' so to speak like there is if you use ChatGPT Plus, etc. We had some success with that, but not using Teams. We've even created a bot which does some amazing things already. I think MS and Open AI need to handle the API better because the tokens get eaten up quickly by building a back and forth with a JSON. We have GPT-4 access through OpenAI and GPT 3.5 Turbo through MS. We're going to write a whitepaper describing some of our use cases to try to get GPT-4 access in MS since "on tenant capability" is needed for the type of work we do. A 'Session ID' would do the trick, but that doesn't exist 'yet' and may cause other issues I'm not aware of.

[Ami99]

Actually it seems to me that the subscription is not active 

[dbustle]

Any chance you have this line figured out with 3.5 turbo?  

"prompt": "@{outputs('Get_message_details')?['body/body/content']}",

[DCovC1]

Not enough information shown. Authorization may be the issue although I didn't translate the text in the images. However, I would suggest making sure Bearer is in from of the API key which is an error I ran into.