May 08 2020 11:30 AM
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.
May 08 2020 12:30 PM - edited May 08 2020 12:47 PM
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.
May 08 2020 02:46 PM