Send Email Reminders Through Power Automate

%3CLINGO-SUB%20id%3D%22lingo-sub-3086318%22%20slang%3D%22en-US%22%3ESend%20Email%20Reminders%20Through%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086318%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERequest%20your%20help%20with%20the%20following%20task%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeed%20to%20send%20Daily%20Reminders%20with%20pending%20tasks%20to%20the%20individual.%20I%20was%20able%20to%20send%20individual%20emails%20for%20each%20item%2C%20however%20would%20like%20to%20send%201%20email%20to%20each%20user%20with%20list%20of%20all%20their%20pending%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20data%20is%20stored%20in%20Excel%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22634%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2254%22%3ESL%20No%3C%2FTD%3E%3CTD%20width%3D%22116%22%3EDepartment%3C%2FTD%3E%3CTD%20width%3D%22116%22%3ETask%3C%2FTD%3E%3CTD%20width%3D%22116%22%3EOwner%3C%2FTD%3E%3CTD%20width%3D%22116%22%3EStatus%3C%2FTD%3E%3CTD%20width%3D%22116%22%3EEmail%20Address%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EFinance%3C%2FTD%3E%3CTD%3ETask%201%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3EDone%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EFinance%3C%2FTD%3E%3CTD%3ETask%202%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3EPending%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EOperations%3C%2FTD%3E%3CTD%3ETask%203%3C%2FTD%3E%3CTD%3EXYZ%3C%2FTD%3E%3CTD%3EPending%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EOperations%3C%2FTD%3E%3CTD%3ETask%204%3C%2FTD%3E%3CTD%3EXYZ%3C%2FTD%3E%3CTD%3EPending%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3EOperations%3C%2FTD%3E%3CTD%3ETask%205%3C%2FTD%3E%3CTD%3EXYZ%3C%2FTD%3E%3CTD%3EDone%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3EFinance%3C%2FTD%3E%3CTD%3ETask%206%3C%2FTD%3E%3CTD%3EABC%3C%2FTD%3E%3CTD%3EPending%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AEmail%20address%20removed%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEmail%20address%20removed%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEg.%20ABC%20should%20get%20an%20email%20of%20SL%20No%202%20and%206%20(in%201%20email)%20and%20XYZ%20should%20get%20an%20email%20of%20SL%203%20and%204.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3086318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3090279%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20Email%20Reminders%20Through%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3090279%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290961%22%20target%3D%22_blank%22%3E%40sharadbajaj%3C%2FA%3E%2C%20once%20you%20got%20the%20items%20follow%20the%20steps%20below%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20an%20array%20variable%20for%20storing%20all%20the%20Owners%3C%2FLI%3E%3CLI%3ELoop%20through%20the%20items%20and%20then%20store%20all%20the%20Owners%20in%20the%20above%20array%20variable.%3C%2FLI%3E%3CLI%3EUse%20Union%20method%20with%20the%20above%20array%20variable%20to%20get%20the%20unique%20Owners%20and%20store%20it%20on%20the%20same%20variable.%3C%2FLI%3E%3CLI%3EUsing%20apply%20with%20the%20Owners%20array%20variable%2C%20use%20the%20filter%20action%20with%20the%20items%20and%20then%20filter%20for%20each%20owner%20and%20send%20the%20consolidate%20list%20to%20the%20respective%20owner.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EPlease%20try%20it%20out%20and%20let%20me%20know%20if%20you%20have%20any%20clarifications.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

Request your help with the following task:

 

Need to send Daily Reminders with pending tasks to the individual. I was able to send individual emails for each item, however would like to send 1 email to each user with list of all their pending items.

 

My data is stored in Excel Online.

 

SL NoDepartmentTaskOwnerStatusEmail Address
1FinanceTask 1ABCDoneEmail address removed
2FinanceTask 2ABCPendingEmail address removed
3OperationsTask 3XYZPendingEmail address removed
4OperationsTask 4XYZPendingEmail address removed
5OperationsTask 5XYZDoneEmail address removed
6FinanceTask 6ABCPendingEmail address removed

 

Eg. ABC should get an email of SL No 2 and 6 (in 1 email) and XYZ should get an email of SL 3 and 4.

2 Replies

Hi @sharadbajaj, once you got the items follow the steps below

  1. Create an array variable for storing all the Owners
  2. Loop through the items and then store all the Owners in the above array variable.
  3. Use Union method with the above array variable to get the unique Owners and store it on the same variable.
  4. Using apply with the Owners array variable, use the filter action with the items and then filter for each owner and send the consolidate list to the respective owner.

Please try it out and let me know if you have any clarifications.

Hi Sudarshan,

I have been unable to do this. Can you please help me with a detailed tutorial or point me to a already existing one.