Power Automate - Run a Flow When SharePoint Column is Modified | Get Changes for an Item Action

#powerautomate #sharepoint #getchnagesforitem
PowerAutomate will talk about when a SharePoint Column is Modified then only perform action in PowerAutomate. This can be achived through SharePoint Get Changes for an Item or File Action which will capture if the column value chnaged or not by returning true or false value, I hope you will enioy the video.

[@GeeStyan]

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.

[@krisperkreme6021]

Thank you very much, that was helpful.

[@kavik3282]

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.

[@LernenTech]

Glad you find it useful

[@ArchieW-iv9td]

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

[@smadasamy81]

Hi , Very good and informative Video. I have got some clarification and additional information this Video for my project. Thanks a lot.

[@michaelgorbachepmanurung5491]

Thank you very much. This is really helpful for newbie like me!

[@mkemalsan]

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".

[@UCanDoIt2Mike]

Brilliant! Very nice presentation. Thank you for sharing... just what I needed. Thumbs-Up!

[@LernenTech]

glad you liked it

[@readmycomment4696]

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!

[@LernenTech]

happy to hear that 🙂

[@shubhabratadey]

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

[@geophman]

Will it continue to check the sharepoint for modifications or is this a one off. Once a modification is done does it stop monitoring?

[@steelertributedotcom]

EXACTLY what I was looking to do and you explained it well - thank you!

[@LernenTech]

glad you liked it.

[@pihu2687]

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?

[@LernenTech]

You are looking for one employee? Give your proper ask

[@aubreyweber4367]

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?

[@user-zy6pt1zd8f]

can we create share point list from existing sharepoint template list using power automate by sending http request

[@mikeluhrs4578]

Is there to see what the data was changed from? So, for example, Item was change from "on hold" to "Started"

[@LernenTech]

In this method no but i will create a video on that to fetch data from sharepoint list version history

[@k.ishtiyaque]

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

[@shitalkadam9789]

@k.ishtiyaque, did you find the solution? I am also trying the same

[@weiyaoxu4184]

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

[@LernenTech]

You can do that by getting that column value and apply switch case

[@weiyaoxu4184]

@@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.

[@weiyaoxu4184]

@@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.

[@LernenTech]

@@weiyaoxu4184 kzbin.info/www/bejne/aGjUZ593dpaHd68si=IfIJRpdP7kFNxnpN

[@weiyaoxu4184]

@@LernenTech​​⁠thanks 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.

[@rodneym.9423]

You used the Compose step to "Send a notification", but where is this notification shown? MS Teams? PowerApps?

[@LernenTech]

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

[@mrwhammer]

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

[@LernenTech]

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

[@mrwhammer]

@@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?

[@LernenTech]

@@mrwhammer you can connect over social platforms we can discuss over call

[@saibot293]

Is there a way that when a list item status is changed to complete it moved it to another list?

[@LernenTech]

There is video in channel please go through it

[@saibot293]

@@LernenTech canyou plz send me the link to it directly?