How To Automate Teams Messages into an Excel Sheet

Question

How To Automate Teams Messages into an Excel Sheet

Luz 45

Hello! I want to update an Excel sheet whenever someone posts in a specific Teams channel. I need to capture who made the post, the post itself, any @ mentions, and the date it was posted so that I can create a report on that data.

Currently I have to manually copy and paste each and every one, but from what I've seen it looks like Power Automate can handle this. The problem is that I haven't been able to find clear documentation on how to do this. I've seen plenty of documentation on Excel to Teams but not the other way around. If anyone could give me guidance or point me to good documentation/ a tutorial it would be greatly appreciated!

Tess 25 Reputation points

2026-05-28T09:06:39.16+00:00

Hello @Luz or @Francisco Montilla - thanks for the Q&A - I am doing this from a group chat so use a slightly different trigger but same process it seems. How did you map your fields?

"Map PostedBy to the sender display name, Message to either the plain text preview or the HTML body as you prefer, Mentions to the variable you built, and PostedAt to the created date from the trigger or the details action "

I understand what this means but have no option to map such fields. Ref the attached image. Should i be initalizing and setting variables or something prior to this step?

Note i dont need the mentions columns just the sender, date and message.
Tess 25 Reputation points

2026-05-28T09:08:38.5233333+00:00

Hello @Luz or @Francisco Montilla - thanks for the Q&A - I am doing this from a group chat so use a slightly different trigger but same process it seems. How did you map your fields?

"Map PostedBy to the sender display name, Message to either the plain text preview or the HTML body as you prefer, Mentions to the variable you built, and PostedAt to the created date from the trigger or the details action "

I understand what this means but have no option to map such fields. Ref the attached image. Should i be initalizing and setting variables or something prior to this step?

Note i dont need the mentions columns just the sender, date and message.

Answer accepted by question author

0 additional answers

Your answer

Tess 25 Reputation points

2026-05-28T09:06:39.16+00:00

Hello @Luz or @Francisco Montilla - thanks for the Q&A - I am doing this from a group chat so use a slightly different trigger but same process it seems. How did you map your fields?

"Map PostedBy to the sender display name, Message to either the plain text preview or the HTML body as you prefer, Mentions to the variable you built, and PostedAt to the created date from the trigger or the details action "

I understand what this means but have no option to map such fields. Ref the attached image. Should i be initalizing and setting variables or something prior to this step?

Note i dont need the mentions columns just the sender, date and message.
Tess 25 Reputation points

2026-05-28T09:08:38.5233333+00:00

Hello @Luz or @Francisco Montilla - thanks for the Q&A - I am doing this from a group chat so use a slightly different trigger but same process it seems. How did you map your fields?

"Map PostedBy to the sender display name, Message to either the plain text preview or the HTML body as you prefer, Mentions to the variable you built, and PostedAt to the created date from the trigger or the details action "

I understand what this means but have no option to map such fields. Ref the attached image. Should i be initalizing and setting variables or something prior to this step?

Note i dont need the mentions columns just the sender, date and message.

Answer 1

Francisco Montilla 30,715 Independent Advisor

Hello,

First prepare the Excel file. Store it in OneDrive for Business or SharePoint, then create a table with columns such as PostedBy, Message, Mentions, PostedAt. Make sure it is a real Excel table, not just a range, or Power Automate will not find it. (learn.microsoft.com)

Create an automated cloud flow and choose the Microsoft Teams trigger named When a new channel message is added. Select your Team and Channel. Note that this specific trigger does not fire for replies to an existing thread

Right after the trigger, add the Teams action Get message details. Feed it the Message Id from the trigger. If you do not immediately see the properties you want, run one test post and look at the action outputs in the run history, then map from there.

To collect the @ mentions into a single cell, initialize a string variable named Mentions to empty, then add an Apply to each over the mentions array from Get message details. Inside the loop, Append to string variable with the display text of the current mention plus a comma and a space. After the loop, optionally remove the trailing comma and space with a small expression, or leave it as is. If your message does not include mentions, this variable will stay empty, which is fine.

Finally add the Excel Online Business action Add a row into a table. Point it to your file and table, then map fields. Map PostedBy to the sender display name, Message to either the plain text preview or the HTML body as you prefer, Mentions to the variable you built, and PostedAt to the created date from the trigger or the details action. Save the flow and post a quick test in the channel with one or two @ mentions to validate the output.

If you want, I can adjust the mappings and the mention loop to the JSON your tenant returns. Share a redacted screenshot of the Get message details outputs for one sample message and I will give you the exact expressions to drop into the flow.

Luz 45 Reputation points

2025-12-24T17:39:34.24+00:00

Thank you so much! This worked! But I am having a bit of trouble with the @ mentions. Following your instructions I was able to update the excel sheet with everything except for the mentions. When trying to build out the mentions, I try to choose the right input for the Apply to Each but no matter what I choose I end up getting an error message when I try to save or test. Do you know where I might be going wrong?
Luz 45 Reputation points

2026-01-05T19:00:23.1+00:00

@Francisco Montilla From what I've seen it should be an expression like "@body('Get_message_details')?['mentions']" but none of the versions I've tried have worked.

HsM 0

While I have a successful flow, the response is not properly captured as how the text was in the Teams chat channel. Can you please help me decipher?

{"value":[{"subscriptionId":"66a7d60e-155e-4eeb-a267-7b94440a73fd","changeType":"created","clientState":"secretClientValue","subscriptionExpirationDateTime":"2026-06-04T23:02:19.3515523+00:00","resource":"chats('19:meeting_ODE1OTFkYTMtNzVmOC00ZjBkLWIxZWQtN2I1YzFkMGU1MjQ3@thread.v2')/messages('1780355505425')","resourceData":{"id":"1780355505425","@odata.type":"#Microsoft.Graph.chatMessage","@odata.id":"chats('19:meeting_ODE1OTFkYTMtNzVmOC00ZjBkLWIxZWQtN2I1YzFkMGU1MjQ3@thread.v2')/messages('1780355505425')"},"encryptedContent":null,"tenantId":"d2033364-dec3-4a1c-9772-3f41ca7c4b75","conversationId":"19:meeting_ODE1OTFkYTMtNzVmOC00ZjBkLWIxZWQtN2I1YzFkMGU1MjQ3@thread.v2","messageId":"1780355505425","linkToMessage":"https://teams.microsoft.com/l/message/19:meeting_ODE1OTFkYTMtNzVmOC00ZjBkLWIxZWQtN2I1YzFkMGU1MjQ3@thread.v2/1780355505425?tenantId=d2033364-dec3-4a1c-9772-3f41ca7c4b75&context=%7B%22contextType%22:%22chat%22%7D"}]}