Trigger Power Automate Flows Manually from SharePoint via a Button! (List & Library Tutorial)

Tired of Power Automate flows running automatically when an item is created or modified? Learn how to take control and trigger your automations exactly when you need them! This step-by-step tutorial shows you how to add custom buttons directly into your SharePoint lists and document libraries to manually run Power Automate flows for selected items or files. Perfect for scenarios like sending invoices, user guides, or initiating processes only when you're ready, saving you time and providing precise control over your workflows. We'll cover everything from setting up the button using SharePoint column formatting (JSON) to building the Power Automate flows and even using Microsoft Copilot to help generate the necessary code! 🚀 In this Power Platform tutorial, you'll learn: How to add a custom button column to a SharePoint List and Document Library. How to use JSON column formatting to create interactive buttons. Leveraging Microsoft Copilot to write and refine JSON for advanced button logic (conditional visibility, text, and color based on status!). Building Power Automate instant flows using the "For a selected item" and "For a selected file" triggers. Getting the unique Flow ID and linking it to your SharePoint button. Fetching item/file details within your flow using 'Get item' and 'Get file properties'. Sending emails dynamically, including file attachments from document libraries. Passing input parameters (like email addresses) from the SharePoint button click to your Power Automate flow. Updating SharePoint item status automatically after the flow runs. Making input fields in your flow optional or required. Customizing the run flow panel header and button text. Whether you're new to Power Automate or looking to enhance your SharePoint automation skills, this low-code tutorial provides practical techniques you can implement immediately. ⏰ Timestamps: 0:00 - Intro: Why trigger flows manually with buttons? 0:44 - Configuring SharePoint & Use Case Overview (Lists vs Libraries) 2:23 - Adding the Button Column to a SharePoint List 2:40 - Using JSON for Column Formatting (Creating the Button) 3:57 - Building the Power Automate Cloud Flow (Trigger: For Selected Item) 4:57 - Getting Additional List Item Data with 'Get Item' 5:56 - Updating the SharePoint Item Status from Power Automate 6:46 - Connecting Your Flow to the SharePoint Button (Using the Flow ID) 7:15 - Testing the Flow Trigger from the SharePoint List 8:13 - Using Microsoft Copilot to Write Conditional JSON (Button Logic/Style based on Status) 9:51 - Refining Conditional Logic with Copilot (Disabling the Button when not Ready) 11:37 - Triggering Flow from a Document Library (Sending File Attachments) 12:00 - Building Flow (Trigger: For Selected File) with Input Parameters (Email) 12:32 - Getting File Content and Properties for Email Attachments 14:08 - Sending Email with Dynamic Recipient & File Attachment 15:52 - Connecting the Document Library Flow & Testing 16:17 - Modifying Header and Run Button Text (JSON Customization) 17:47 - Bonus Tip: Making Input Fields Optional or Required 18:36 - Outro & Further Ideas (e.g., Draft Emails) 🔗 Resources Mentioned: Button Formatting JSON Sample: https://damobird365.gumroad.com/l/SharePointCustomColumnFormattingFlowButton Microsoft Docs - Create a Button: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-advanced#create-a-button-to-launch-a-flow Watch: How to Generate Draft Emails with Power Automate: https://youtu.be/DkR3jmYCSro 👍 If you found this tutorial helpful, please give it a thumbs up and subscribe for more Power Platform, Power Automate, Copilot, and Low-Code tutorials! Let us know in the comments how you plan to use custom flow buttons in SharePoint! #PowerAutomate #SharePoint #PowerPlatform #LowCode #Automation #MicrosoftCopilot #Tutorial #SharePointList #DocumentLibrary #JSON #Flow #Microsoft365 #Office365 #AI #Productivity #WorkflowAutomation #PowerPlatformTutorial Got an idea or a video request? Drop me a note here: https://forms.office.com/e/WAV1iF2Wis 👍 Want to buy me a coffee? https://www.buymeacoffee.com/DamoBird365 ☕