Learn how to add ChatGPT to Microsoft Teams 03-05-2023 20:40 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

[jamestippen]

@Adam_deMont , any thoughts on how to improve the flow to continue the conversation with chatgpt instead of getting a single response?

[GCM]

This is resolved now. I have re-created the workflow.

[GCM]

Hi, I am getting the same message. It is getting repeated. Any ideas to fix this?

[kolombangara]

Hi Jimbluesky, I get the exact same message. The process works but this is the output from each query in the Team channel with no further explanation. The Flow shows success. 

[kolombangara]

Hi Jimbluesky, I get the exact same message. The process works but this is the output from each query in the Team channel with no further explanation. The Flow shows success. 

[kevinngoh]

I'm getting the following error and the flow is failing/taking a long time to fail everytime I put in a new prompt

"You exceeded your current quota, please check your plan and billing details."

Now that openai has introduced a premium feature is this the reason why it's not working? Do I need to start paying the sub-fee?

[Mackert_UK]

Any idea about what could be the issue?

We could not parse the JSON body of your request. (HINT: This likely means you aren't using your HTTP library correctly. The OpenAI API expects a JSON payload, but what was sent was not valid JSON. If you have trouble figuring out how to fix this, please send an email to support@openai.com and include any relevant code you'd like help with.)

[jimbluesky]

followed the steps and did it again. the workflow worked this time 

[Wentry]

Those are errors for invalid input,

review your steps, those must be in the same step, multiple actions than multiple steps, otherwise the variables for the HTTP input will be lost, thus empty.

*Ref to Adam's guide.

[jimbluesky]

thanks Adam. I followed your steps but got following when chat with the bot:

package com.example.demo.controller;

import com.example.demo.model.User; import com.example.demo.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController @RequestMapping("/user") public class UserController {​​

@Autowired
private UserService userService;

@GetMapping("/all")
public List<User> getAllUsers(){​​
    return userService.getAllUsers();
}​​

@PostMapping("/add")
public void addUser(@RequestBody User user){​​
    userService.addUser(user);
}​​

@PutMapping("/update")
public void updateUser(@RequestBody User user){​​
    userService.updateUser(user);
}​​

@DeleteMapping("/delete/{​​id}​​")
public void deleteUser(@PathVariable int id){​​
    userService.deleteUser(id);
}​​

}​​

Any idea why? 

thanks,