Using Power Automate to Send Reminder Emails Based on SharePoint Status and Date Columns 

Great question. You could do it a few ways, but I'd add columns for the manager email (possibly name as well if you wanted to address the email to the manager) and then the date sent to the manager. I would then edit the logic within the loop where there is already a "Date Last Notified." After checking if a week has gone by, I would check if the "Manager Date Last Notified" is blank. If so, I would send the email to both and then update both dates. If the "Manager Date Last Notified" is not blank, it should be the same date as the "Date Last Notified" and thus you would keep sending to both from then on. Hope this helps.

@@jeffrhodes I have tried but looks like my logic is not working. The first time when notification is supposed to go only to team members but it is also going to to manager's as well. I am not sure where my logic is wrong. I would appreciate it if you could provide more guidance or do a small vided to add an escalation process. I am attempting a flow where we have various teams under different manager's and if a team lead doesn't update the status then in the next reminder a cc email should go to their manager as well. Thank you very much in advance I am following the model of your other video here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YYOcPrgAAyg.html I have columns in this sequence. ID First Name Last Name Email First Name 1 (For Managers) Last Name 1 (For Managers) Email1 (For Manager's) Status DateLastNotified Notes M_DateLastNotified (For Managers) M_Notes (For Manager's)

@@nomirehman - I will put this on my "to do" list for a video on this. Hopefully this upcoming weekend.

@@jeffrhodes Great !! I ll be looking forward to it. I appreciate all the support. Thank You

It sounds like your SharePoint list has one or more required columns where you are not providing a value. If that's the case, then just select the current value of the column as the value. For example, at around 25 minutes into the video, I write the ID column and select the current ID value as pare of Update Item. If you have others like Title, you will need to write the current value. Hope this helps.

It sounds like your logic to compare the current date/time with the last time the notification was sent is not working. I would go to around 17 minutes into the video and make sure your varTicksLastNotified variable is being set correctly. You can check the values and do the math yourself to see what might be going wrong. Hope this helps.

@@jeffrhodes Thanks for your quick response. Currently, while setting the varTicksLastNotified variable I did faced a issue which is - While typing values, I selected function and typed ticks () then when I tried to search for Date Last Notified from Dynamic content, it was not present in the drop down to select from as it was only showing body & Value under Get files( properties only) ....Using Get files( properties only) because I am creating flow for library. If I do not type ticks() under function, then Date Last Notified is displayed in drop down under Get files (properties only).... Hence I typed manually" ticks(items('Loop_Through_Items')?['Date_Last_Notified']) and it's saving the flow without error If I try to type ticks(items('Apply_to_each')?['Date_Last_Notified']) , then flow is showing error stating - "Flow save failed with code"Invalid Template " and message ' The template validation failed: the repetition action(s)' Apply_to_each ' referenced by' inputs' in action ' Set_varTicksNotified' are not defined in the template'... Please help as unable to proceed 😭

@@jeffrhodes Thanks for your quick response. I tried to check the values but unable to help myself resolving the same Would like to share that while typing values in varTicksLastNotified variable I did faced a issue which is- While typing ticks () in function and then tried to select Date Last Notified from Dynamic content, couldn't find in the drop down as it only showing body and Values under Get files (properties only).... Get files (properties only) because I am creating flow for a library. If I remove ticks() from function then can find Date Last Notified under Get files ( properties only) drop down. Hence I typed manually in the function- ticks (items ('Loop_Through_Items')?['Date_Last_Notified']) and flow is getting saved without any error. But if I try typing ticks(items('Apply_to_each')?['Date_Last_Notified']) then it's showing the error while saving which is Flow save failed with code 'Invalid Template ' and message ' The template validation failed: ' The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action ' Set_varTicksLastNotified' are not defined in the template'... Please help me to achieve the same

@jeffrhodes Thanks for your quick response. I tried to check the values but unable to help myself resolving the same Would like to share that while typing values in varTicksLastNotified variable I did faced a issue which is- While typing ticks () in function and then tried to select Date Last Notified from Dynamic content, couldn't find in the drop down as it only showing body and Values under Get files (properties only).... Get files (properties only) because I am creating flow for a library. If I remove ticks() from function then can find Date Last Notified under Get files ( properties only) drop down. Hence I typed manually in the function- ticks (items ('Loop_Through_Items')?['Date_Last_Notified']) and flow is getting saved without any error. But if I try typing ticks(items('Apply_to_each')?['Date_Last_Notified']) then it's showing the error while saving which is Flow save failed with code 'Invalid Template ' and message ' The template validation failed: ' The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action ' Set_varTicksLastNotified' are not defined in the template'... Please help me to achieve the same

@@subhadas9852 - I've run into issues like that with formulas. You might try creating a new variable for the Date Last Notified and then use that variable in the formula. I've had that work before.