Run a flow when a SharePoint column is modified

[@missahfly]

Ms. Dunnam you are amazing! Thank you for being concise and straight forward with your instructions. I'm so tired of people going off topic and talking about other non related "things" in their tutorials. Super impressed, it takes a lot of skills to stay on point and not ramble.

[@AprilDunnam]

Thank you so much for this great feedback :)

[@jmnordman]

I wasn't even on your channel to learn about this feature, but now I can optimize one of my workflows! Thanks!

[@AprilDunnam]

I'm glad that you found this video and it's going to help you optimize your workflow!

[@simondowsett]

Thanks for the update April...thats functionality that I've been trying to get working through a variety of tricky approaches, but the new trigger and action make it super simple. And easy enough to show end to end in less than 10 minutes!!! Great stuff.

[@AprilDunnam]

You're welcome! Same here, I've been waiting for this new trigger and action for awhile now. It's going to make things much easier!

[@brianblack8337]

Incredible and thorough video. I really like that you take the time to show the process and what your clicking on. You also go the extra mile to explain what the options mean. Beyond that you go the extra extra mile to identify possible conflicts with the systems and show the full solution to fix that as well. 10/10 just absolutely amazing! Keep doing what youre doing

[@vladinoo]

This was helpful. Thank you. It is really pleasant to finally hear native speaker with such a nice voice and pronounciation! Thanks again

[@AprilDunnam]

Thank you! 😃

[@radiosonicfan1726]

Thank you exactly what I was looking for. Tip. When building condition logic arguments MS limits to 10 rows. You can add a row below (and click move up) to push arguments past 10 row limit.

[@MrsLaubie]

Your videos are brilliant! The versioning for SP lists alone was a life saver for me!

[@AprilDunnam]

Thanks for watching Sarah - glad this one was helpful!

[@pmaynard]

Thank you for this excellent clear explanation of how to implement this flow. I was searching around for documentation on how to approach this but a video just makes things so much easier. This flow will make a significant impact on how our teams manages our requests in the future. Brilliant!

[@zekimertbarut]

Extremely simple, quick and explanatory. Thank you! I have created my flow at the same time you finished your video.

[@OlegFortun]

Great video, thank you for the step by step! I caught myself putting True instead of true, but fixed that quickly.

[@AprilDunnam]

You're very welcome Oleg! I have also got tripped up with True vs true so you aren't alone!

[@sukanv4271]

THANK YOU! I spent an hour trying to figure this out and this was the problem :)

[@mothercromby]

This video is great. It's much better than the one Microsoft linked to in the original blog post.

[@brendanbowen7097]

Great update! Thanks April. I remember with the old "When an item is created or modified" trigger, you could inadvertently create a loop if you didn't put like a "flag" column to stop it from cycling every-time a change was made by the flow; checking on a condition if that flag column was changed, then stop the flow. At least that was my challenge with it, and it didn't seem to be reliable. I'm going to look at this new trigger now - thanks again!

[@AprilDunnam]

You're welcome Brendan! I think all of us who've built flow's for SharePoint have faced the dreaded endless loop scenario. I'm so glad they've finally released this to help us to we don't have to hack our way through fixing it!

[@brucewayne-tt7ix]

April, i'm SO glad i stumbled across your channel! thank you for your efforts. Content is relevant and presented in a well-constructed manner. Easy to understand. You're eloquent and concise, and your voice is so pleasing on the ears :)

[@AprilDunnam]

Wow thank you so much! Very glad that you stumbled across my channel. Thanks for watching!

[@carlw]

Yes, I just happened to need this functionality yesterday, found the new function and started learning about it. Thanks for your helpful, enlightening video.

[@AprilDunnam]

Thanks for watching Carl!

[@carlw]

@@AprilDunnam Well I have your channel bookmarked as one of my resources.

[@eabrahame]

Thank You Ms. Dunnam. Appreciate it. This helps me a lot. Great walk thru.

[@ithinkmaybethis]

Thanks for the video, April! There don't seem to be a whole lot of videos out there on this new(ish) feature yet! Question: In the email, is there a way to include JUST which fields were updated, and what the old and new value is/was? Thanks for all you do with these videos, you've helped me more times than I can count!

[@stuartharrod4007]

This is fantastic April. I was looking for a way of only breaking permissions and reapplying them if the owners or members change in a canvas app linked to a SharePoint list. This so far seems like the perfect solution. Thank you very much.

[@tauseefshk]

This is Superb April. I really like the way you keep things simple for otherwise complex requirements.

[@AprilDunnam]

Thank you so much 😊

[@JosuaDavidV]

This is the video I've been looking for !!. Thank you, April!

[@AprilDunnam]

You are so welcome!

[@Slash1066]

Very cool, I did it before by duplicating the column and checking for changes each time, this is much better

[@AprilDunnam]

Definitely - no more hacks needed to do something simple...finally!

[@connorsplevins7431]

Thank you April, this is exactly what I needed! Thank you :)

[@AprilDunnam]

Glad it was helpful!

[@JustinBouchardw]

at 8:46 when you edit the table, you selected the row first to edit. If you double-click on the item, there is no save button, so if you were to change the rows separately it creates two separate versions. How would you work around this?

[@zavaidok]

Thank you for the video April! Very helpful! :) Do you know, however, how to mention in the notification email the old field value? Like in your example "changed from 4hrs to 8 hrs"?

[@somesz83]

Well, finally a worthy tutorial! Thank you!

[@AprilDunnam]

Thanks for watching!

[@carlw]

Agreed. If Microsoft could only provide useful, normal, everyday life functional videos. Enough of Contoso.

[@ahmedmoataz1534]

really, you are the best, thanks very much for all your useful videos always

[@AprilDunnam]

You're very welcome - thanks for watching Ahmed!

[@robynlandon3961]

I love u. U just saved me soooo much time. I looked and looked for this and the work arounds were sooooo confusing. Thank u!!!

[@AprilDunnam]

I'm so glad! You're welcome!

[@cristianrojas2885]

This video was incredible. Thanks for sharing this.!!!

[@AprilDunnam]

My pleasure Cristian - glad it was helpful!

[@liktorjanos3376]

Hey! Cool stratocaster on the wall :) And cool flow stuff. Thanks :)

[@AprilDunnam]

Thanks :)

[@pgforest]

This perfect video just earned you another subscriber - thank you!

[@AprilDunnam]

Thanks so much for the sub!

[@kanaan1517]

Thanks a lot for the video April, its really helpful 🤗 I hope you keep doing such amazing videos. The way you explained it is also simple and straight to the point, I loved❤️🤗 it. Keep rocking!! 🔥🌹😉

[@AprilDunnam]

Thank you!!

[@peggylang6999]

BRILLIANT. Just what I was looking for. Thank you!

[@AprilDunnam]

Great to hear!

[@sam-z3l1x]

hi April - great example and easy to follow instructions - sure beats writing workflows in visual studio

[@AprilDunnam]

Thank you!

[@roycecoolidge7135]

Thank you so much for this tutorial its saved a lot of headaches!

[@AprilDunnam]

That's my goal - none of us have time for headaches!

[@ericvelasco5814]

Thanks a lot, super helpful and easy to follow!!

[@AprilDunnam]

Glad it was helpful Eric! Thanks for watching!

[@Shaun-bs9ux]

Great video, very helpful and easy to follow. Nice work and thank you!

[@martylewis9538]

Added this to an approvals workflow. Very handy. Thanks

[@AprilDunnam]

Nice!

[@omarmorales909]

Great video!! Just what I needed, thanks for sharing your knowledge!!

[@AprilDunnam]

Thanks Omar! Glad it was helpful!

[@lionofseaseng]

If the type of column is yes/no, I want to be notified when No chooses. How can we do it?

[@johnbrennan8442]

Use the same formula but use true instead of yes without the single quotes

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

[@DoingGreat]

Awesome...just awesome! Just subscribed. Thank you!

[@AprilDunnam]

Thanks for the sub!!

[@emmanuelmaceda2475]

Thank you, awesome update on Flows and great way of explaining it!

[@AprilDunnam]

Thanks Emmanuel - glad you enjoyed it!

[@simondevries35]

Your videos are so helpful! Thank you!

[@AprilDunnam]

Thank you so much!

[@swastiify]

Too good ! Thankyou Miss Dunnam 😊

[@AprilDunnam]

Thanks for watching!

[@Amithsiji]

Thanks a ton....you saved me 30K Euros......loving your channel.....

[@AprilDunnam]

That's awesome! Thanks for watching!

[@shaikzuber7945]

Thanks April..Is it possible to update Timestamp whenever Status Column Values is Modified and store it as Time taken named column in sharepoint list.

[@IshmaelMothibi]

Thanks April, amazing video of what i was looking for exactly.

[@AprilDunnam]

Glad it was helpful!

[@nikrrr]

Thanks so much! Also love that you sectioned your video - so helpful!

[@AprilDunnam]

Thanks Nicki! Glad that you liked it and it was helpful :)

[@benbo250]

amazing. Easy to understand and you helped me so much.

[@AprilDunnam]

So glad I could help!

[@colineyan8384]

HI April, thank you for this video! It's so helpful. May I know if we can track the changes in content files of attachment as well? I tried to find in dynamic content, but I couldn't find the attachment. Looking forward to hearing from you!

[@hikmetgursoy1532]

Awesome video, Thank you Aprill!!

[@AprilDunnam]

Thanks Hikmet!

[@diegoacevedo1778]

Very pro explanation! thank you!

[@AprilDunnam]

Glad you enjoyed it!

[@markmoscosa2371]

Thanks a lot for making this specific video!

[@AprilDunnam]

My pleasure!

[@darrydarry3244]

Fantastic video, exactly what I was looking for. Thank you so much.

[@AprilDunnam]

Awesome - glad it was helpful! Thanks for watching!

[@iancockcroft9427]

Hi April, awesome work. thanks a ton. I have it working for one particular column field, now i need to run a flow if any field changes. anywhere i can see how thats done?

[@kittydoes7600]

Thank you so much April for another great and helpful video 🤩

[@AprilDunnam]

Glad it was helpful!

[@espiemar1661]

I love your videos!! I do have a question, can I use this flow across 2 different list from 2 different SharePoint sites? I need to update the second list when the first list changes in a couple of specific columns. Thank you!!

[@tnorman3329]

Thank for this breakdown, Sharepoint Siren 😆!!! SUBSCRIBED!!!!

[@AprilDunnam]

Thanks so much for the sub! 🙂

[@ivanpalacios3965]

Awesooooome!! I was strugling using The Switch function, but this solved my issue :)

[@AprilDunnam]

Glad this helped!

[@gunasekar4098]

super April. exactly am looking at this part, finally got an answer from you. also, when the attachment modified, do we have any flow trigger video???

[@WildRover1964]

thank you for this. It's not at all intuitive but I've got my flow working as I wanted. cheers

[@AprilDunnam]

Intuitive or not, I'm glad you were able to make it work and glad I could help. Cheers to your flow!

[@maverick5]

This is great! Question - Is it even possible to send different emails just based on one column changing? I tried to replicate this. So when Mon is selected the first email would go out, tuesday - the second email and so on. The output was when one condition met, it sent 7 emails :) Is the alternative creating several different flows?

[@richygardiner1]

Great video, loving your work, quick question if I may, when using the condition is it possible to add the true for the change and also a criteria condition (ie if value of column is Yes) before sending a mail

[@A8OC]

April this is a great video. But I'm having an issue in that when my flow runs it runs for every column even if I'm only changing 1 of them. So in a single view I have 10 columns, but I only modify one of them, the flow will run 10 times. Do you have any idea why? Thanks, Tony

[@amiryunus1]

Thanks for the video. Is it possible to show only those fields in the email where the value has changed?

[@ashleyh3330]

Thanks so much for showing this feature! I was wondering if this works on the "Title" column or when a document is updated (content or name change). Its seems to be working with all the other columns other than the one that contains the document. Thanks!

[@k1ck82]

Thank you so much for the instruction. This is so helpful.

[@AprilDunnam]

You are so welcome!

[@TheSwedishRocks]

Another great video, thank you! Is there a way to get the changed values and bring them back into the App, almost like the Version History view from within the SharePoint list?

[@krik2579]

Thanks April, your videos are very helpful. Easy to understand and follow compare to some other videos where they talk nonsense for 90% of time. Great work really appreciate, it has helped me a lot. Would you be able to post video for this scenario on power app if I have to pull data from 1 sp list A and submit to data to sp list A and sp list B and default drop down fields to blank when submitting.

[@AprilDunnam]

Thanks! I'll see if I can think of a good scenario for this and add it to my list. But to answer your question you can submit to multiple lists using the Patch() function. When you are using patch you can make a dropdown field blank by mapping it like so: Dropdownfield: Blank()

[@jetvistal]

Thanks for the great stuff, just had a question. Can you provide me steps on how I can able to retrieve the previous value of an updated column in a list? Thank you :)

[@Donzell1Dawson]

Exactly what I am looking for. Thank you! I am subscribing based off of this one (1) video.

[@AprilDunnam]

Glad it helped. Thanks for subscribing!!

[@abihoughton2256]

When I get to the section which is get changed for item and added ID there is no dynamic content? What have I done wrong

[@cbaxter197]

Thanks for this video. What if you want to automatically populate a date column when the status column is changed to “complete” in a SharePoint list?

[@thorstenstoffel3959]

Hi April, very good tutorial. I just couldn't your second step to run. It worked fine, however, when I deleted the second step and jumped straight into the "condition" section. Can you elaborate on the function of your second section a little more, please.

[@lpdowdell]

In this particular example, how do you make sure that the flow only triggers when a new item is modified (you have done that), and when only Monday and Thursday fields change? How do you apply trigger conditions here?

[@bhooshanshinde]

This is an awesome explanation but... What if Monday value is changed i.e. true then (old Value -> New Value) display in mail? In Mail body only show items which are changed (As you hardcoded Moday and Tuesday) but what if only Monday was changed ?

[@Flowmi]

Yes this was amazing! Please keep making more videos! 👽

[@AprilDunnam]

Thanks! I'll definitely keep making videos 😉

[@cristoumanzor3896]

Exactly what I was looking for. Thanks April. :-)

[@AprilDunnam]

Glad it was helpful!

[@mihailskozevnikovs8399]

Thank you!!! Helped me complete my flow !

[@AprilDunnam]

Wonderful! Glad I could help!

[@methewolf]

Hi April, What about the settings in “When an item or file is modified” there is at the bottom a Trigger. Can I set that to trigger only if the Approval Status is "Action Required"? it would not start the flow. or in my case I want to startnly if the Value is Action Required. Thank you, great work you do here on KZbin. Wolf

[@migs4637]

Superb video! Straight forward and very clear instructions! Would you know how to identify/input directly in an added sharepoint list column which columns have been modified/changed? I've been trying to use the same conditions and utilizing "Update Item" when there are changes in specific columns, but I couldn't make it that it will identify the columns with changes.

[@joycemonyhan8694]

This is wonderful and solved a requirement that I was given. Could you also go over how to add the Comments to this process? I mean the comments that you can add with the @ function. thank you so much.

[@stretch233]

Great video April! Can you do an updated one that shows how you can include the before value as well as the updated value in the email? I've been struggling to figure that out!

[@AprilDunnam]

Hey Craig! I just released a follow up video today that walks you through exactly how to do this: kzbin.info/www/bejne/eoWZc6OfrauVfrs

[@stretch233]

@@AprilDunnam You're amazing! I hope to be as good as you some day!

[@cyrsus]

Fantastic video! Thank you so much for showing how to do this! Is there a way to capture what the value was before it changed? Possibly into a running log or append to a OneNote page?

[@carlw]

Tx April, this is all well and good until we start to update a text field based on a lookup then we run into the infamous infinite loop issue

[@tidharniv8218]

Great Videos! thank you so much! totally got a new subscriber ;) If I have a yes/no column and I want to get notified only when the value is "yes" how can I build this workflow?

[@VaidehiSingh]

Thanks, April. This was really helpful. However, I need a little more help here. If I have a multiple choice column in sharepoint having only two choices , 'Yes' and 'No'. Can I get two different trigger emails for each? I do not want any trigger for any other change in the sharepoint list. Will be looking forward to your response.

[@viktordeguerre]

Thx a lot, i search many many day for the soolution and u gave me !!!!!

[@AprilDunnam]

Glad I could help!

[@lakedenk7267]

This video was awesome! I wish I saw this 5 hrs ago. One question, what do I need to do when I want to email more than one person the change?

[@ajfuad]

Is it possible to notify only the columns that has changed. In the above video, you can given 3 OR conditions, so if any one is changed the notification will have values for other two which were not changed

[@christiancrosser6936]

Great video, exactly what I have been searching for! I am currently making a news feed for an employee clock in application and need to give the admin the most recent action. Would this be the best method to return the most recently modified entry? Also like your music setup!

[@AprilDunnam]

Hey Christian - What tool are you using for the employee clock in app? For example - if you're using a Power App tied to a SharePoint list then you can just use a SortByColumns(DataSource, "Modified", Descending) to get the most recent items first. But if you're using another tool then this Flow could be a good way to get the most recently modified data

[@lorddragonmage4432]

Hi April, wonderful walk-through. Thank you! To expand on this a little further, how would I choose a specific dropdown? I have a Status column but only want the email to trigger on the "Not Delegated" selection. Can put the "Not Delegated" in the True field? Or must it have a function to call that selection?

[@belizish2004]

Looking for an answer to this question as well..

[@fuoribondo]

Thanks for the great video. Do you know if there's a way to trigger an action on a file with a specific name or extension when they are created in a sharepoint folder?

[@aquabestindian]

Thanks April. This is great.. But how can we get what was the previous value. For e.g., can we show details in mail which can tell value in Monday was changed from 4 to 8.

[@DanieleRebussi]

kzbin.info/www/bejne/e5yXoIyNhbyZipI

[@anandasanyal]

Hello April, Thank you for sharing new feature. I've question on flow sharepoint item modified trigger. If I use this trigger and send email, Modified by columns is updated by the flow user and in my email it will show - updated by flow user. Where as this items is updated by some other user. How to get the user name, who is actually edited the record in flow. Appreciate any suggestion/ help on this. Thank you.

[@michelles.veloso8357]

Thanks for share with us :)

[@AprilDunnam]

My pleasure!

[@Jorghe80]

amazing April! thanks for sharing

[@AprilDunnam]

Thanks for watching!

[@merichan1509]

Dear Ms, thanks for the tutorial, but could you please help my difficulties, what if i want to sent email to different person? i mean for example when monday updated then it will send an email to Mr. A and when tuesday updated then it will send an email to Mr. B. how to set up that kind of flow ? thank you in advance

[@abbasthegreat5]

When I use Update Item action, It re triggers the flow again and again infinitely. I have tried to resolve the issue using trigger conditions and status column etc but no luck. Can you suggest some solution? I need to update multiple values in this modified trigger.

[@karamcginn4907]

Perfect tutorial, thanks a ton!!

[@AprilDunnam]

Glad you liked it! Thanks for watching Kara!

[@shivkumarsharma9208]

Thanks for sharing this video but my question is similar to this but its bits different ..can we Run a flow when a SharePoint permission is modified? is it possible?