Forum Discussion
daily alerts from excel
Does anyone have a solution for adding an alert to a group email from an excel sheet in Teams?
I have a spread sheet that group A will input data, and I would like an alert to be emailed to group B that this data is outstanding and needs action. once the action is done group B will check it off/mark it done and it will be removed from the email alert setup.
- Hi Aaron,
Looks like someone already had the same question you are having 😉
You can use Power Automate to send a Teams message when a file has been updated.
I guess this link can help you out:
https://powerusers.microsoft.com/t5/Building-Flows/Excel-File-Updated-Send-Teams-Message-Email/td-p/316196
Let me know if this helped you.
Kind regards and stay healthy,
Mitchell Bakker One possible very basic way of doing this could be to open the Teams folder in SharePoint view, then click the ellipsis and choose the Alert Me option;
You then have the option to configure email alerts as below;
Each user would need to set this up though.
If this isn't going to go far enough for you, then I would look at the option to create a Flow with Power Automate. Hope this gives you some ideas.
