Unanswered

power Automate - email flow when choice field hasn't changed

(0) Share

Report

Posted on by paulnorris1979

Hi,

I'd like to create a flow that generates an email to a given user if a column field has not changed for a given amount of days.

So, then field in question is "Status" and this is just a choice field. The people I want to email are either the submitter or the person assigned (this bit I'm ok with).

When an item enters the list, it first has a status of "Draft" or "Pending", if the status is unchanged (by some form of user action) in say 3 days time, I'd like an email to be sent to the relevant person, and then every 3 days until it is not the same status.

There are then other status's that I'd like to apply the same principle to, but if I can get one working I can copy across and apply the same logic/flow.

Any help would be most appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Re: power Automate - email flow when choice field hasn't changed

Hi @paulnorris1979

I would suggest to try this approach (first one)

https://techcommunity.microsoft.com/t5/sharepoint/get-date-modified-of-individual-columns/m-p/3938778

using calculated columns would help to find the date in which it has been modifed. Not sure whether the via formula we can calculate the date of modified for a particular column in sharepoint, if yes in the flow use scheduled flow which checks difference b/w dates and if days>3, send an email.

Hope this logic helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
paulnorris1979 4 on at

Like (0)

Report
Re: power Automate - email flow when choice field hasn't changed

Hi Nived,

I should have mentioned that I tried this approach already, when I try the formula:

=IF([Column A]=[Column A_PreviousVersion],"",[Modified])
I get an error - "List Column Doesn't Exisit", I've checked and triple checked by typing and it definitely exists. I've seen a couple of other posts that have recommended this approach and had the same issue as me.

I've simply replaced "Column A" in both instances in the formula with my column name, which happens to just be "Status".

So, unless I'm doing something wrong it's not playing ball!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Re: power Automate - email flow when choice field hasn't changed

Hi @paulnorris1979

Hmm ok, i got one more approach, not sure how would it go, see below

1. Let's create two different flows, one flow will record the time for column updation

Flow 1-

this flow will trigger when item is modfiied, then using Get changes in item/file, check whether Status column has changed, if yes, record the current datetime as modified in a excel sheet

Then create another flow which runs in scheduled manner which checks the excel file and take the difference b/w the value and current time to check the number of days in between, if it is given number of days, send an email to concerned person 🙂

Hope it would helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
paulnorris1979 4 on at

Like (0)

Report

Re: power Automate - email flow when choice field hasn't changed

Ok, we can give that a go.
Would you be able to send some slightly more detailed instructions (like write the whole thing for me!! lol 🙂 or point me in the direction of another case study doing similar?

Paul.

Was this reply helpful? Yes No