Additional file-related features and issues within Microsoft Teams for business
Dear Zilean Quinn,
Files shared in a Microsoft Teams channel are stored in the associated SharePoint document library. While Excel provides features such as Show Changes and version history, these features require you to open the workbook and review the activity manually. Microsoft Teams and Excel do not currently offer a native option that automatically sends a Teams notification containing the editor’s name and modification time each time the file is updated.
Microsoft used to have Classic SharePoint Alerts, but it is no longer recommended because they have been retired in SharePoint Online. SharePoint Rules may support basic notifications, but Power Automate provides better control over the specific file, message format, destination, and duplicate-notification handling.
For this requirement, the recommended solution is to create an automated cloud flow in Power Automate. The flow can be configured to:
- Monitor the SharePoint document library where the Excel file is stored
- Filter activity to the specific Excel workbook
- Capture the name of the user who last modified the file
- Capture the date and time of the modification
- Post a notification to a selected Microsoft Teams chat or channel
In this case, please reach out to Microsoft Power Platform Community Forum Thread. The reason I am asking you to post a new discussion is that in the Questions – Microsoft Q&A, we have limited resources and very few resources to test this feature and in Microsoft Power Platform Community Forum Thread, you will get the most qualified group of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.
Thank you for your cooperation and understanding. Feel free to post your questions in the Microsoft community and we'll always do our best to help you!
Have a good day!