Run a flow when a SharePoint column is modified

122,564
0
2020-09-15に共有
#PowerAutomate #SharePoint
Power Automate and SharePoint can be combined to create numerous automations to match your business needs. Up until recently, there was no built-in trigger to kick off a Flow when an item is modified in SharePoint 😢

In this video I'll walk through a NEW Trigger and Action in Power Automate that makes it possible to trigger a Flow when an item is modified AND check to see what column values were modified! 😮

Link to Blog Post: flow.microsoft.com/en-us/blog/run-a-flow-when-a-sh…

Table of Contents:

00:00 - Intro
00:50 - Feature Overview
01:54 - Creating the Flow
03:45 - Checking what Columns Changed
07:52 - Enabling Versioni

コメント (21)
  • @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!
  • 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
  • Extremely simple, quick and explanatory. Thank you! I have created my flow at the same time you finished your video.
  • 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 :)
  • 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.
  • @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.
  • I wasn't even on your channel to learn about this feature, but now I can optimize one of my workflows! Thanks!
  • @vladinoo
    This was helpful. Thank you. It is really pleasant to finally hear native speaker with such a nice voice and pronounciation! Thanks again
  • @MrsLaubie
    Your videos are brilliant! The versioning for SP lists alone was a life saver for me!
  • This is Superb April. I really like the way you keep things simple for otherwise complex requirements.
  • 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.
  • 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!
  • 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.
  • @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.
  • This video is great. It's much better than the one Microsoft linked to in the original blog post.
  • 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!! 🔥🌹😉
  • This is the video I've been looking for !!. Thank you, April!
  • 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!