This has been so helpful! I've been trying to find a way to check if a specific column has changed for ages and so many tutorials don't seem to cover this so you get spammed with emails! Thank you.
Top class - I was struggling with exact same scenario and I was able to complete the flow with watching your video just once - I was able to add 'Send an Email' function under the condition - > Switch -> Case -> 1st scenario where the column condition was met. I added 'Send an Email; after the Compose. Thank you so much!
Excellent explanation of the steps necessary. Only thing I could see that was partially wrong was that your condition checked against "true" as a string instead of the boolean true (inserted as an expression). But it still works because boolean false would never equal "true" as a string, whereas boolean true would equal any string including "true".
Thank you for this, however, when I update any other column for the same item, it activates the trigger for the status. How do I prevent this? Thank you in advance
Great video. Can you also add here what if once I update the value to 'In Progress', how can I fetch its relevant values from another SharePoint List. Lets say, the other SP List has 2 or more columns of data against 'In Progress' and I would like to fetch it here in the Master SP List once it changes
Excellent videos with helpful hands on tutoring. Been watching for months. What if we want to send an email when Not Started changes to Completed while not send any email when In Progress changes to Completed? Thanks
@@LernenTechthanks for reply. See your point here to create some criteria. But May I know how to get the old value when the item is modified with an automated workflow? Say “Not Started” changed to “Completed”, and get item would bring “Completed” rather than “Not Started”. Thanks again.
@@LernenTechsay 3 situations under Status column: Not Started, In Progress, Completed. The goal is to send email A when Not Started becomes Completed, or when In Progress becomes Completed; send email B when Completed becomes Not Started; no action when Not Started becomes in Progress / when Completed becomes In Progress. Hope this better illustrates question. Thank you.
@@LernenTechthanks again. Yes…that was also another video i watched earlier while i research on this topic. Logically should be a easy criteria setup: when previous value = “Completed” AND new value = “Not Started”, send email B; however followed method in that video and wrote replace(split(item(), ‘:’)[1],’’”,”) = “Completed” as a Condition to express Previous Value = “Completed” but error msg says No Input. May I know what’s wrong with my workflow / could you kindly share how to write Previous Value = Completed? Thank you again.
Hello! My flow is working, and it is showing that it is only applying when the status has changed and then it sends the email. However, I am still getting email status changes for all the other items in the list. Do you know why this would be?
Hi There, thank you for all your videos on power automate they are really helpful. Can you pls do a video on how to map employee data from the responses to its org hierarchy and then the results to power bi? Is it doable?
Hi, Thanks for creating such a informative video. Actually I need your help in order to create a flow for one of my project wherein I have created a SharePoint site which contains multiple folders and added a column name with "Delivery Status". Now I need a flow which will send reminder email to users until the "delivery status" updated to "Delivered". Could you please help me with that? Thanks
Hi is it possible to keep the flow running until it is no longer that specific value? because it doesnt look like it applies to current flows but only to future flows, i want it to be able to apply to both flows, both future and current. Say for example a do until checks if it is the same execute this until it is no longer that value and then eventually terminates when that column value changes
Brother the trigger point is every time your item modified so you don’t have to worry about that, whenever you change that flow will automatically pic that. Hope it answer your question
@@LernenTech unfortunately it doesnt do that i tried. It just starts another flow and doesnt check if its still the same. Would i need to do a do until loop with a get item so it updates it?
This has been so helpful! I've been trying to find a way to check if a specific column has changed for ages and so many tutorials don't seem to cover this so you get spammed with emails! Thank you.
I spent my whole day in trying to find solution on my own. Thankfully i watched this video and got the answer. Thanks a lot.
Glad you find it useful
Top class - I was struggling with exact same scenario and I was able to complete the flow with watching your video just once - I was able to add 'Send an Email' function under the condition - > Switch -> Case -> 1st scenario where the column condition was met. I added 'Send an Email; after the Compose. Thank you so much!
happy to hear that 🙂
Excellent explanation of the steps necessary. Only thing I could see that was partially wrong was that your condition checked against "true" as a string instead of the boolean true (inserted as an expression). But it still works because boolean false would never equal "true" as a string, whereas boolean true would equal any string including "true".
Thank you very much, that was helpful.
EXACTLY what I was looking to do and you explained it well - thank you!
glad you liked it.
Brilliant! Very nice presentation. Thank you for sharing... just what I needed. Thumbs-Up!
glad you liked it
Thank you very much. This is really helpful for newbie like me!
Thank you for this, however, when I update any other column for the same item, it activates the trigger for the status. How do I prevent this? Thank you in advance
Hi , Very good and informative Video. I have got some clarification and additional information this Video for my project. Thanks a lot.
Great video. Can you also add here what if once I update the value to 'In Progress', how can I fetch its relevant values from another SharePoint List. Lets say, the other SP List has 2 or more columns of data against 'In Progress' and I would like to fetch it here in the Master SP List once it changes
Excellent videos with helpful hands on tutoring. Been watching for months. What if we want to send an email when Not Started changes to Completed while not send any email when In Progress changes to Completed? Thanks
You can do that by getting that column value and apply switch case
@@LernenTechthanks for reply. See your point here to create some criteria. But May I know how to get the old value when the item is modified with an automated workflow? Say “Not Started” changed to “Completed”, and get item would bring “Completed” rather than “Not Started”. Thanks again.
@@LernenTechsay 3 situations under Status column: Not Started, In Progress, Completed. The goal is to send email A when Not Started becomes Completed, or when In Progress becomes Completed; send email B when Completed becomes Not Started; no action when Not Started becomes in Progress / when Completed becomes In Progress. Hope this better illustrates question. Thank you.
@@weiyaoxu4184 ua-cam.com/video/27q6lAA1TAM/v-deo.htmlsi=IfIJRpdP7kFNxnpN
@@LernenTechthanks again. Yes…that was also another video i watched earlier while i research on this topic. Logically should be a easy criteria setup: when previous value = “Completed” AND new value = “Not Started”, send email B; however followed method in that video and wrote replace(split(item(), ‘:’)[1],’’”,”) = “Completed” as a Condition to express Previous Value = “Completed” but error msg says No Input. May I know what’s wrong with my workflow / could you kindly share how to write Previous Value = Completed? Thank you again.
Hello! My flow is working, and it is showing that it is only applying when the status has changed and then it sends the email. However, I am still getting email status changes for all the other items in the list. Do you know why this would be?
Hi There, thank you for all your videos on power automate they are really helpful. Can you pls do a video on how to map employee data from the responses to its org hierarchy and then the results to power bi? Is it doable?
You are looking for one employee? Give your proper ask
You used the Compose step to "Send a notification", but where is this notification shown? MS Teams? PowerApps?
i didn't send notification i was just testing with compose, you can use email or teams trigger as per your need, i hope it's clear now
Is there to see what the data was changed from? So, for example, Item was change from "on hold" to "Started"
In this method no but i will create a video on that to fetch data from sharepoint list version history
Will it continue to check the sharepoint for modifications or is this a one off. Once a modification is done does it stop monitoring?
Hi, Thanks for creating such a informative video. Actually I need your help in order to create a flow for one of my project wherein I have created a SharePoint site which contains multiple folders and added a column name with "Delivery Status". Now I need a flow which will send reminder email to users until the "delivery status" updated to "Delivered". Could you please help me with that?
Thanks
@k.ishtiyaque, did you find the solution? I am also trying the same
can we create share point list from existing sharepoint template list using power automate by sending http request
Hi is it possible to keep the flow running until it is no longer that specific value? because it doesnt look like it applies to current flows but only to future flows, i want it to be able to apply to both flows, both future and current. Say for example a do until checks if it is the same execute this until it is no longer that value and then eventually terminates when that column value changes
Brother the trigger point is every time your item modified so you don’t have to worry about that, whenever you change that flow will automatically pic that. Hope it answer your question
@@LernenTech unfortunately it doesnt do that i tried. It just starts another flow and doesnt check if its still the same. Would i need to do a do until loop with a get item so it updates it?
@@mrwhammer you can connect over social platforms we can discuss over call
Is there a way that when a list item status is changed to complete it moved it to another list?
There is video in channel please go through it
@@LernenTech canyou plz send me the link to it directly?