Learn Power Automate - Tutorials - SharePoint & Power Automate - Only Run When a SINGLE COLUMN Changes!!

Automate Everything: From Beginner Basics to Advanced Workflows with Power Automate

5.0 (0)

3 learners

What you'll learn

Build automated workflows using triggers, actions, and controls.
Integrate data between applications like Excel, SharePoint, and Outlook.
Create and manage approval processes and email notifications.
Automate desktop tasks and data processing with Power Automate Desktop.

This course includes

24.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Power Automate Pragmatic Works Nate Halliwell Flow SharePoint Trigger Conditions Power Automate How-to Power Automate Tutorial power automate sharepoint list power automate sharepoint microsoft flow sharepoint

Full Transcript

Power Automate has no Out-of-the-Box way to only run a Flow when a certain column changes for an Item in SharePoint List. This video shows a creative way around this common headache that Power Automate developers encounter! 👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "NATE30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - https://pragmaticworks.com/pricing/ 00:00 - Introduction 00:32 - Overview of the SharePoint List and the Triggering Issue 01:11 - Requirements for Running the Flow Only on Specific Column Changes 02:16 - Exploration of Trigger Options in Power Automate for SharePoint Lists 03:19 - Selection of "When an Item or File is Modified" Trigger 04:23 - Introduction of the Need for Trigger Conditions due to Limitations 06:18 - Creation of a Trigger Condition to Check Column Changes 08:16 - Testing and Confirmation of the Trigger Condition Setup 11:20 - Introduction of a Second Flow to Update Matching Column Values 13:19 - Manual Test to Demonstrate Initial Flow Behavior 14:36 - Explanation of the Importance of the New Triggered Flow 15:56 - Cautionary Note on Avoiding Infinite Loop Situations 16:28 - Emphasis on the Final Step in the Original Flow to Update Items 17:42 - Final Test to Validate the Entire Flow Setup 18:51 - Conclusion -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks