Trigger Power Automate based on status change in SharePoint
HTML-код
- Опубликовано: 27 мар 2022
- 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.
![Eminem - Houdini [Official Music Video]](http://i.ytimg.com/vi/22tVWwmTie8/mqdefault.jpg)
This saved my life!! Thank you soooo much buddy!
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
DUUUUDE! You rule. I've been trying to figure this out for 2 days then I stumbled across this video today. I love you
Thank you so much - greetings from Germany!
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!
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. 😊
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.
This is perfect. And so simple. Thank you!
Awesome video! Thank you Trevor!
Perfect. Huge Thanks for the help.
very helpful with my error.. tqsm
So helpful - thank you!
Thank you I have been looking for this!
There’s so much you can do using the status change as a trigger! :-)
Clear and concise
Helpful 👍
Can i do the same if i want to send mail when list item is deleted to the person who created the item?
Even when I change other fields it still sends the email, and I followed this to the T.
I’m having the same issue.
@@JenMayB can't remember exactly how I fixed it now but it's possible
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
Ideally, the email client should recognize it, but you could always try using HTML code for a link.
Hi, Why is Get Changes for an item or a file (properties only) needed?
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. 🤓
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
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.
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.
Sorry, I’m retired now and don’t have access to these tools. However, April Dunham on RUclips is a great resource. :-)
What about with list columns and using switch statements?
LOL - beyond me. I retired a year ago and haven't been accessing Power Automate since then.
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?
Unfortunately I’m retired now and don’t have access to the same tools. :-(
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?
Unfortunately I’ve retired and no longer have access to the tools. 😢
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.
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
@@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.
@@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.