daily alerts from excel

Copper Contributor

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. 

3 Replies

@AaronGolasMoveras 

 

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;

 

Screenshot 2020-05-08 at 20.26.40.png

You then have the option to configure email alerts as below;

 

Screenshot 2020-05-08 at 20.27.26.png

 

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.

@PeterRising 

 

I'll try that, much appreciated Sir! 

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/...

Let me know if this helped you.

Kind regards and stay healthy,
Mitchell Bakker