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.
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!
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.
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?
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. 🤓
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
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.
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 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.
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?
DUUUUDE! You rule. I've been trying to figure this out for 2 days then I stumbled across this video today. I love you
this worked first time, thank you.
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
Thank you so much - greetings from Germany!
This saved my life!! Thank you soooo much buddy!
Awesome video! Thank you Trevor!
This is perfect. And so simple. Thank you!
Perfect. Huge Thanks for the help.
Thank you I have been looking for this!
There’s so much you can do using the status change as a trigger! :-)
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.
very helpful with my error.. tqsm
So helpful - thank you!
Clear and concise
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. 😊
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 UA-cam is a great resource. :-)
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
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. :-(
Hey Trevor, I find your video very useful but would you mind making this but with the recurrence trigger? Thank you in advance!
@@JessicaLely-z4v Unfortunately I’m retired now and no longer have access to the tools. :-(
But if you will work in the file , every couple of minutes it will save it and consider it modified.
Can i do the same if i want to send mail when list item is deleted to the person who created the item?
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. 🤓
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.
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,
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.
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.
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. 😢
Helpful 👍