Answered

Send notification if a collumn is a certain value for a certain time

(0) Share

Report

Posted on by Community Power Pla...

Hi All !

I need a flow that sends an email to a predefined user when a collumn is a value for longer then two week.

So when the value for collumn ""phase" is set to 2, the flow needs to send an email to this user if the collumn doesn't change into another value in two weeks. Does anyone knows the solution for this?

Thanks:D

Kindly regards,

Tex

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Send notification if a collumn is a certain value for a certain time

Hi v-LilyW-msft,

What I was looking for is exactly this but then for a collumn in dataverse (model driven app). This has everything to do with my unclear description.

Since your solution corresponds exactly to the problem I described, I will definitely mark your response as the solution!

Kindly regards,

Tex
Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Send notification if a collumn is a certain value for a certain time

Hi @Anonymous

Is your phase column of choice type?

Do you want to trigger Flow when the value of phase is changed to 2, and then judge whether the phase column is changed to another value within 14 days?

I set up a flow, you can refer to below screenshots to see if it helps.

This is my test list.

First determine whether Flow is triggered because the value of phase is changed to 2.

Then add another Get changes for an item or a file (properties only) action to determine whether the value of phase has been modified within 14 days, apart from this modification.

Expression1:

addDays(utcNow(),-14,'yyyy-MM-ddTHH:mm:ssZ')

Expression2:

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

If the value of Has Column Changed: phase is not equal to true, it means that it has not been changed then send an email.

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.