daily alerts from excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1375026%22%20slang%3D%22en-US%22%3Edaily%20alerts%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375026%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20have%20a%20solution%20for%20adding%20an%20alert%20to%20a%20group%20email%20from%20an%20excel%20sheet%20in%20Teams%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20have%20a%20spread%20sheet%20that%20group%20A%20will%20input%20data%2C%20and%20I%20would%20like%20an%20alert%20to%20be%20emailed%20to%20group%20B%20that%20this%20data%20is%20outstanding%20and%20needs%20action.%20once%20the%20action%20is%20done%20group%20B%20will%20check%20it%20off%2Fmark%20it%20done%20and%20it%20will%20be%20removed%20from%20the%20email%20alert%20setup.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1375026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAlerts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEmail%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESettings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1375197%22%20slang%3D%22en-US%22%3ERe%3A%20daily%20alerts%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661234%22%20target%3D%22_blank%22%3E%40AaronGolasMoveras%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20possible%20very%20basic%20way%20of%20doing%20this%20could%20be%20to%20open%20the%20Teams%20folder%20in%20SharePoint%20view%2C%20then%20click%20the%20ellipsis%20and%20choose%20the%20Alert%20Me%20option%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-05-08%20at%2020.26.40.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190250iFBADB30B0796B2F3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-05-08%20at%2020.26.40.png%22%20alt%3D%22Screenshot%202020-05-08%20at%2020.26.40.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20then%20have%20the%20option%20to%20configure%20email%20alerts%20as%20below%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-05-08%20at%2020.27.26.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190251i903CAFEAC76ADA1A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-05-08%20at%2020.27.26.png%22%20alt%3D%22Screenshot%202020-05-08%20at%2020.27.26.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20user%20would%20need%20to%20set%20this%20up%20though.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20isn't%20going%20to%20go%20far%20enough%20for%20you%2C%20then%20I%20would%20look%20at%20the%20option%20to%20create%20a%20Flow%20with%20Power%20Automate.%20%26nbsp%3BHope%20this%20gives%20you%20some%20ideas.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1375223%22%20slang%3D%22en-US%22%3ERe%3A%20daily%20alerts%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616707%22%20target%3D%22_blank%22%3E%40PeterRising%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20try%20that%2C%20much%20appreciated%20Sir!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1375562%22%20slang%3D%22en-US%22%3ERe%3A%20daily%20alerts%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375562%22%20slang%3D%22en-US%22%3EHi%20Aaron%2C%3CBR%20%2F%3E%3CBR%20%2F%3ELooks%20like%20someone%20already%20had%20the%20same%20question%20you%20are%20having%20%3B)%3C%2Fimg%3E%3CBR%20%2F%3EYou%20can%20use%20Power%20Automate%20to%20send%20a%20Teams%20message%20when%20a%20file%20has%20been%20updated.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20guess%20this%20link%20can%20help%20you%20out%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FExcel-File-Updated-Send-Teams-Message-Email%2Ftd-p%2F316196%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FExcel-File-Updated-Send-Teams-Message-Email%2Ftd-p%2F316196%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ELet%20me%20know%20if%20this%20helped%20you.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%20and%20stay%20healthy%2C%3CBR%20%2F%3EMitchell%20Bakker%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

Highlighted

@PeterRising 

 

I'll try that, much appreciated Sir! 

Highlighted
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