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 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
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, 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!
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?
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.
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?
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 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.
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 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
this worked first time, thank you.
Thank you so much - greetings from Germany!
This saved my life!! Thank you soooo much buddy!
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!
Perfect. Huge Thanks for the help.
Awesome video! Thank you Trevor!
Thank you I have been looking for this!
There’s so much you can do using the status change as a trigger! :-)
very helpful with my error.. tqsm
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.
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. :-)
Can i do the same if i want to send mail when list item is deleted to the person who created the item?
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. 😊
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.
So helpful - thank you!
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. :-(
Clear and concise
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.
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. 😢
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. 🤓
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.
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.
Helpful 👍