hi @Chriddle @microsoft Truly appreciate of your feedback. Yes - i have changed my mind, request users to update details in Excel (assume to be stored in SharePoint), rather than send them a link in an email.
Let's me give you details about my current scenario & expectation:
base on the excel link below, let's assume it was now saved In SharePoint. All users are expected to update the necessary dates in Column J – L (excel attachment above - to be stored in SharePoint).
https://docs.google.com/spreadsheets/d/1MJ5T4vroPisyDfSAQ0kCAFfVz3nSndIr/edit?usp=sharing&ouid=105639232592416502396&rtpof=true&sd=true
Rule:
Each auto notification emails will sent out on daily basis, start from [Reminder date - Column B], until the End day when “Completion status” in Column M has tagged as “Completed”.
In other words, notification emails would kept sent out indefinitely, if “Completed” status forever not reflect in Column M.
Format of Auto notification emails:
- Email header – refer from Column G
- Email body message – refer from Column H*
- Upload Object Attachment (if any) in email – refer to Column I
- Who to email? – refer to Column D
- Who to cc In email? – refer to Column F
- Who is the sender email – refer to Column E
Note: For email body message ->
If the pending task hasn’t reach deadline (refer to column C), email body message would be “Hi Sir/ Madam, you have pending task awaiting for your action” (refer to Column H)
However, if the pending task exceeded deadline date (eg: 13/11/2023), the email body message to be sent on 14/11/2023 should be “You have 1 day overdue task. Kindly action from now”.
On 15/11/2023, the email body message “You have 2 days overdue task. Kindly action from now”.
On 16/11/2023, no more notification email to send out, as the task has eventually completed on that respective day.
Truly appreciate of your guidance on how to do it (steps by steps) from beginning to the end in Power Automate
(Sorry, i am totally new here)
