Write to MS Teams users based on a CSV

Question

Hello everyone, is it possible to write to users via MS Teams based on a CSV file?

I have a CSV file that contains the users that need to be contacted. I would like to write a text to these users via MS Teams. This way I want to avoid having to write to individual users.

Answer 1

Hi @St

There is no out-of-the-box way to get data from a CSV table in Teams, you need to use PowerAutomate to achieve this.

You need to use PowerAutomate to parse the data in the CSV table and extract the contact column. Here's how to get the data in the CSV table and extract the contact column (if your file is saved in Teams, the file is essentially saved in OneDrive).

After obtaining the data, you only need to add an action called Post message in a chat or channel in the last step, and use the contact column parsed in the previous step in the recipient field.

If you don't know enough about the use of PowerAutomate, in order to better help you, you can also post in the PowerAutomate community for further help.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---