Need to send an email notification on weekly basis to remind project complete date to PM?

[Deepika61]

Hi All,

Actually i have requirement that  need an email notification to be sent to me on project complete  date to the project manager on weekly basis untill all stories marks as complete

And Email notification to include link to agile board 

I have idea that create a schedule job in that

1. need to check that project end date 

2. if end date not completed then need to check if stories are complete or not

3. if stories are still not complete then we need to trigger an event

These are the steps to follow, so i need schedule script to achieve this?

Please help me to achieve this 

Thanks

Deepika

[Mark Roethof]

Hi there,

Can you share what you already tried and is not working, or where you are stuck?

[Deepika61]

@Mark Roethof 

Thanks for the response

Actually i have an idea that this is to done by schedule job, but i am stuck with code ,can you please provide me the code for my requirement ?

And coming to the notification, how to should i include a link that redirect to Agile board?

Thanks

Deepika

[Mark Roethof]

Why code? Have you considered a (Scheduled) Flow instead? Looking at what you are describing, most likely zero code involved. 

[Dr Atul G- LNG]

Hi @Deepika61 

You can create a Flow

Trigger --> Repeat or schedule

Action

Looks Up records

where

Project date are less than 1 week ( an example)

Run Loop

Action

Send Notification use dot walk.