Trigger Power Automate based on status change in SharePoint

Building on previous videos, instead of manually triggering a workflow, you can trigger it just by changing data in a cell. In this case, changing a status.

[@BigBoyBigPloy]

DUUUUDE! You rule. I've been trying to figure this out for 2 days then I stumbled across this video today. I love you

[@LaRubia62]

thank you sooooo much for this tutorial. I have been struggling with the triggers on this and this is exactly the workflow I was looking for. amazing

[@marieraymond6512]

this worked first time, thank you.

[@manuelsahinoglu392]

Thank you so much - greetings from Germany!

[@Need4Loop]

This saved my life!! Thank you soooo much buddy!

[@JenMayB]

This is perfect. And so simple. Thank you!

[@rodrigotonetto9402]

Awesome video! Thank you Trevor!

[@ShahbazAlam-y7l]

Perfect. Huge Thanks for the help.

[@blakeaspears]

Thank you I have been looking for this!

[@TrevorBeck]

There’s so much you can do using the status change as a trigger! :-)

[@zaliqable]

very helpful with my error.. tqsm

[@Romaine.L]

Hi Trevor, I see comments from you stating you have retired. Just wanted to let you know that your work continues to help people like myself. Hope you are enjoying retirement. Cheers!

[@TrevorBeck]

Thank you! One of my goals before retiring was to create a number of these videos. I’m glad to hear the effort wasn’t wasted. 😊

[@rafaeldeyta6863]

Clear and concise

[@gslvqz8812]

In this case, you really do not need the 'Get Changes..' action. Because you are not using any of the output from that action. If you were to use it in the email or in some other way, then it would be necessary. In your example, you can delete that action and the flow will still run.

[@DanielaIancu-ks6ye]

So helpful - thank you!

[@TheDavidbacon1980]

Hi Trevor - how do you limit the trigger to the line you have just changed? In the example when one status changes it will send emails to every line with the "send to faculty" status.

[@TrevorBeck]

@@TheDavidbacon1980 Sorry, I’ve been retired for a few years so can’t help you. However, try Google AI Studio. You can share your screen so it can see what you’re doing and you can ask it for help! 😀

[@dpose6525]

This is great! Exactly what I needed. Question. How to you make the URL clickable in the email that is sent so the end user does not have to copy and paste the URL. Thank you Sir

[@TrevorBeck]

Ideally, the email client should recognize it, but you could always try using HTML code for a link.

[@kv3382]

But if you will work in the file , every couple of minutes it will save it and consider it modified.

[@Scarface1337_]

Even when I change other fields it still sends the email, and I followed this to the T.

[@JenMayB]

I’m having the same issue.

[@Scarface1337_]

@@JenMayB can't remember exactly how I fixed it now but it's possible

[@ritubeohar8769]

Can i do the same if i want to send mail when list item is deleted to the person who created the item?

[@JessicaLely-z4v]

Hey Trevor, I find your video very useful but would you mind making this but with the recurrence trigger? Thank you in advance!

[@TrevorBeck]

@@JessicaLely-z4v Unfortunately I’m retired now and no longer have access to the tools. :-(

[@theearth6248]

Helpful 👍

[@MrDijvar]

Hello, I have a question The condition did not work for me, I have a wrong result in the expression every time. When I check it with the get Changes property, I see that the status of the column has been changed as True. Do you have any idea? What I can say is that I configured another action, I don't send email, I make new items in another list, but it fails from the beginning to get the condition to True.

[@TrevorBeck]

Sorry, I’m retired now and don’t have access to these tools. However, April Dunham on KZbin is a great resource. :-)

[@malexanderr1]

This works but title is a little misleading. The overall flow triggers every time any field in the list is modified ... not just when that specific field is modified. The flow once running then checks if the specific field is updated. Ideally we would only want the flow to trigger if the field itself is modified.

[@ArchieW-iv9td]

Hi, I'm facing the same exact issue. Been trying to find a solution for days on how to fix this. Have you gotten a solution for this? Thanks

[@MrThuralion]

@@ArchieW-iv9td Have you tried adding in the Condition section, that "Has column changed: State" is equal to true, and made it an "AND" function? So the function checks both that has the column value changed, AND is the column the desired state to send the email. Then it wont inform everytime any field is modified since the column value "state" has had to change in the modification.

[@Romaine.L]

@@MrThuralion This is perfect and the correct solution. Thanks for taking the time to leave it here. This should have probably been shown in the video, but this comment will do! thanks.

[@venkatagavili6249]

Hi Trevor, really helpful, this works fine when we make changes to status, how can power automate go thru the list and send emails for the statuses that have already been made changes to please let me know. Thank you

[@TrevorBeck]

Unfortunately I’ve recently retired and don’t have access to the tools. However, I would think that as part of the changes you could have a different status field that you could creat a second flow to work on.

[@lp8064]

I have a lists column as choice, yes or no. I want to send one email to those we change to yes and a different email to those we change to no. Can you do a video on this?

[@TrevorBeck]

Unfortunately I’ve retired and no longer have access to the tools. 😢

[@dpose6525]

Hi Trevor, this actually does not work. I set this up exactly as you did but emails are getting sent for ANY change to the document, and also any changes to the status column. Any thoughts?

[@TrevorBeck]

Unfortunately I’m retired now and don’t have access to the same tools. :-(

[@jl1399]

What about with list columns and using switch statements?

[@TrevorBeck]

LOL - beyond me. I retired a year ago and haven't been accessing Power Automate since then.

[@bilalh847]

Hi, Why is Get Changes for an item or a file (properties only) needed?

[@TrevorBeck]

I’m not an expert, but in my testing it’s like a two step process. Step 1: identify the file you’re interested in. Step 2: get some info about it. In this case, it’s the meta data (i.e. data in the columns). Once you have that data, you can then do something with it. 🤓