Send email if "status" hasnt changed in 30 days

[Kiara1987]

I have a list of jobs. Each job is assigned a status throughout the life of the job

Can I create a flow to say:

If the status is changed to "Pricing"

and

Stays at that status for 30 days

then

Send an email to <someone>

Can someone assist?

[UshaJyothi20]

Hi @Kiara1987 

when item is created it will have the status pricing??????

I hope this happens...if so 

Capture the date when the item is created and then count 30 days after it and check again the status....

If the status is equal to pricing then send email.....

This is the logic you need...I hope...

If not please mention the detailed requirement and with screen shots.....

So that we can assist

Hope this helps

Usha

[VishnuReddy1997]

Hi @Kiara1987 ,

Where is the Date that Status has changed to Pricing.

Is the Due date = Status Changed Date?

Regards,

Vishnu Reddy

Vishnu Reddy

[Kiara1987]

Hi, No that status would be chosen later on within the process...

[Kiara1987]

Hi @VishnuReddy1997 

The thing is there wont be a date field as such. I want the system to look at the date the "status" was changed to a specific status and then count 30 days from that date and then send an alert.

The alert is to tell someone that a job is sitting at a particular status for too long.

Does this make sense?

[AlexLe256]

So can you have another column that will get the date when the status change so that the flow will just need to calculate the date between that date and today.

[Kiara1987]

how can i do that?. Sounds like exactly what i need.

[AlexLe256]

I just test this way, so I not sure there is any problem with it yet, but here is how I doing it.

First, you will create a column to track the date.

Second, you will create a view in the sharepoint list that only have the status column. Click on the create new view.

 Third is to create the cloud flow that have the trigger and action like this 

In the trigger, click on advance properties and choose the view that you just created. 

and in the action you just need to update the column that track the date with the expression utcNow()

That how I did it.

[Kiara1987]

There isnt an option here in the trigger to "choose the view" as suggested.

What do I do from here?

[Kiara1987]

I also want to apply this flow to two different statuses too

So...

If status is changed to "A" give me the date it changed to Status "A"

If status is changed to "C" give me the date it changed to Status "C"

Maybe you could screenshot me through the whole flow?

[AlexLe256]

So the way I doing it is not right, I will try find another way.