Automatically update an Excel Sheet to track data shared in a Teams Conversation post?

Question

Automatically update an Excel Sheet to track data shared in a Teams Conversation post?

Cox,Andy 0

I work for a university residence hall and I am seeking a way to easily keep track of what rooms have had noise complaints. Right now, our RAs post a message each morning into a Teams Channel with an outline of their duty shift, and I want to connect these messages to an excel spreadsheet. When a room number is shared in a message, I want that to add a line to an Excel sheet. Any ideas on how to do specifically this? I am struggling with getting the specific room number into the excel sheet rather than the ENTIRE message.

1 answer

Your answer

Answer 1

LiweiTian-MSFT 24,890 Microsoft External Staff

Hi @Cox,Andy

Teams does not currently have the ability to automatically extract certain text from channel messages and upload it to Excel.

I suggest you use PowerAutomate to implement this function. According to your needs, using PowerAutomate to achieve this requirement has the following prerequisites:

a. The message sent to the channel must have a fixed format (for example, the text before and after the room number is the same every day)

b. There must be a table in Excel to store the room number (PowerAutomate can only add data to the table but not to the Sheet)

I made a test for your reference:

Daily duty outline: There are noise complaints in room A203, please deal with them in time.

User's image

In the expression last(split(first(split(triggerOutputs()?['body/body/content'],',')),'room')) used in the room number field:

triggerOutputs()?['body/body/content'] gets the messages sent in the channel.

Functions like last, first, split are designed to get the room number.

This document guides the use of PowerAutomate functions. If you meet the above two conditions but do not know how to write expressions, please provide the text format you receive every day so that I can help you better.

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.

LiweiTian-MSFT 24,890 Reputation points Microsoft External Staff

2023-08-07T08:07:53.4233333+00:00

Hi @Cox,Andy

I am checking the status of this case. Please let us know if you would like further assistance.
Meanwhile, if the reply is helpful to you, please try to mark it as an answer to help others who encounter the same issue and read this thread.
Thank you for your understanding and patience!
LiweiTian-MSFT 24,890 Reputation points Microsoft External Staff

2023-08-09T08:45:44.88+00:00

Hi @Cox,Andy

I am checking the status of this case. Please let us know if you would like further assistance.
Meanwhile, if the reply is helpful to you, please try to mark it as an answer to help others who encounter the same issue and read this thread.
Thank you for your understanding and patience!
Grant Jenson 0 Reputation points

2023-12-06T21:07:43.5666667+00:00

Hi @LiweiTian-MSFT - I came across this thread trying to implement a way of generated a Meeting Recap (via Copilot) and then uploading each Meeting Recap to an excel file.

I have a weekly meeting that I would like to retain the history of on an excel doc. At the completion of each meeting, I copy the transcript over to Copilot and asked for a "Meeting Recap", starting with the first line as a title of "Summary, <MeetingName>, <Meeting Date/Time>"

Would there be a way of automating this process using a similar work flow to the one you have suggested above?

The goal would be to monitor a specific team chat, trigger on the creation of a new Transcript file --> Feed that file into Copilot for a Summary (with the same prompt from a reference file if needed) --> Put this meeting summary into an existing Excel table --> send a message in the specific team chat that a "Summary has been added to <excel file name>"

The meeting series is not apart of a channel, but is a recurring meeting that a Transcript file is posted into at the completion of each meeting automatically.

I think this work flow you have provided is very interesting and would appreciate any help or guidance on this, thank you so much!

Share via

Automatically update an Excel Sheet to track data shared in a Teams Conversation post?

1 answer

Your answer