Trigger Conditions in Power Automate (Stop Flows from Running Unnecessarily!)
Tired of Power Automate flows running when they shouldn’t?
In this tutorial, I’ll walk you through how to use trigger conditions in Power Automate to ensure your flows only run when certain conditions are met. This not only saves flow runs (and headaches) but also helps avoid infinite loops, cluttered emails, and unnecessary updates.
▶️ We’ll look at:
How trigger conditions work
Why they’re essential in SharePoint-based flows
A real-life example using a Projects list
How to build a proper OData expression (and why CoPilot sometimes gets it wrong)
By the end, you’ll know how to confidently add conditions like “Only run this if Status = Started and Project Manager is not blank.”
🛠 Want more help? Drop your scenario in the comments or reach out—I’d love to help you get unstuck.
✅ Like this content? Subscribe for more Power Automate, SharePoint, and Microsoft 365 tips.
#PowerAutomate #Microsoft365 #SharePoint #TriggerConditions #OData #PowerAutomateTips #Automation #FlowTutorial #MicrosoftPowerPlatform #ProductivityTools
The Best Way to Set Up SharePoint Permissions for Small Teams
No IT department? No problem. Here’s how to keep your files secure and your team productive. Why SharePoint Permissions Matter (Especially for Small Teams) When you’re running a small business or nonprofit, the last thing you need is a team member accidentally deleting files, accessing the wrong documents, or getting locked out of what they […]
How to Build a SharePoint Intranet in 15 Minutes (Even Without an IT Team)
Can You Really Build a Company Intranet in 15 Minutes Using SharePoint Online? Yes — if you’re a small business or nonprofit, and you don’t have an IT department, you can build a company intranet with Sharepoint in under 15 minutes. No coding. No tech degree. No stress. This guide walks you through the steps […]
Power Automate Tutorial for Beginners: Send Emails Automatically in SharePoint
Learn how to create your first Power Automate flow in Microsoft 365—no coding required. In this beginner-friendly tutorial, Gerry Brimacombe walks you through the exact steps to automatically send emails from a SharePoint list when a project status changes.
🚀 You’ll discover:
How to use the new Power Automate designer
What triggers are and how they start flows
How to conditionally send an email using dynamic SharePoint fields
The importance of choosing the right data fields (yes, including the tricky “status.value” lesson!)
Bonus tips to troubleshoot, test, and zoom around your flows like a pro
If you’re new to Microsoft Power Automate and want to simplify your daily workflow, this video will get you started fast.
📍In this example:
We build a simple flow that sends an automatic email to a project manager when the status of a project list item changes to “Started.”
🛠 Tools shown:
Power Automate (basic license)
SharePoint Online
Microsoft 365 apps
🎓 Perfect for:
Project managers
IT admins
SharePoint users
Microsoft 365 power users
Anyone who wants to save time by automating repetitive tasks
🔔 Don’t forget to like, subscribe, and comment with your Power Automate questions. Gerry answers them personally!
—
#PowerAutomate #Microsoft365 #SharePoint #WorkflowAutomation #GerryBrimacombe #TechTutorials #NoCodeTools
SharePoint Guest Access FIX – New Login Link for Toolkit Buyers
Microsoft recently made changes to SharePoint that affect how guest users are added—making it harder for many small business and nonprofit users.
If you’ve purchased the SharePoint Toolkit, there’s now a direct login link inside the book. Or send me an email at ge***@********er.ca and I’ll send you the fix, so you can login.
🔗 Get the toolkit: https://lightlever.ca/product/sharepoint-intranet-build-toolkit/
Questions? Drop them below and I’ll help.
How to Invite Guest Users to SharePoint with Power Automate | Full Tutorial + HTTP + Approval Flow
Learn how to invite guest users to your SharePoint site using Power Automate! In this step-by-step tutorial, I walk through building a fully automated solution to manage guest user access, including:
Using anonymous forms to collect email submissions
Triggering approval workflows
Sending guest invitations via Microsoft Graph API
Adding users to SharePoint groups after authentication
Handling infinite loops with conditions and control flags
Monitoring user acceptance with a retry loop
Perfect for SharePoint admins, Power Platform developers, and anyone automating Microsoft 365 processes.
💬 Have questions or stuck on a similar setup? Drop a comment or reach out—happy to help!
Or get the books now – everything you need to setup your Sharepoint! https://sharepointinpractice.com/
—
#SharePoint #PowerAutomate #Microsoft365 #PowerPlatform #SharePointTutorial #GuestAccess #AutomateWorkflows #MicrosoftGraph #FlowTutorial #ITAdmin
Automate Microsoft Forms to SharePoint with Power Automate | Guest User Access Made Easy
Learn how to automate Microsoft 365 guest user onboarding using Microsoft Forms, Power Automate, and SharePoint! In this hands-on tutorial, you’ll see how to:
Create a Microsoft Form for collecting email and purchase info
Design a SharePoint list to store responses
Build a Power Automate flow to sync form submissions to SharePoint
Customize form fields and settings
Test the entire process from start to finish
This video is perfect for Microsoft 365 admins, consultants, and digital workplace builders looking to streamline toolkit distribution and guest access management.
🔗 Useful tools mentioned:
Microsoft Forms
Power Automate
SharePoint Online
👍 Like, Subscribe & Comment to support more M365 automation content!
📩 For training, consulting, or speaking inquiries, contact me directly at ge***@********er.ca
—
#Microsoft365 #PowerAutomate #SharePointOnline #MicrosoftForms #Automation #DigitalWorkplace #GuestAccess #PaperlessOffice #TechTutorial
Mastering SharePoint Permissions: Full Tutorial on Groups, Inheritance & Teams Integration (2025)
Unlock the secrets of SharePoint and Microsoft Teams permissions with this complete, beginner-to-advanced guide from Lightlever! 🚀 In this 27-minute tutorial, expert Gerry Brimacombe walks you through the complexities of site-level permissions, groups, inheritance, document-level settings, and Microsoft Teams integration — all using live demonstrations in SharePoint Online.
✅ Topics Covered:
SharePoint Permissions Structure: Who Can Do What to What
Group vs. Individual Access
Inheritance & Unique Permissions Explained
Teams Permissions vs. SharePoint Permissions
Practical Demos on Setting and Managing Permissions
Real-World Use Cases + Best Practices
🔗 Resources:
Lightlever Sharepoint Development and Training: https://lightlever.ca/
SharePoint Books & Tools: https://sharepointinpractice.com/
📩 Questions? Drop them in the comments or reach out directly!
👍 Like, subscribe, and stay tuned for more SharePoint mastery.
—
#SharePointPermissions #Microsoft365 #Lightlever #SharePointTutorial #TeamsIntegration #Office365Training #DocumentManagement #SharePoint2025 #TechTraining #DigitalWorkplace
How to Build a Microsoft 365 SharePoint Intranet in 15 Minutes (Beginner’s Guide)
Want a quick way to build your first Microsoft 365 SharePoint Intranet? In this beginner-friendly tutorial, Gerry shows you how to create a simple and professional SharePoint site in just 15 minutes — perfect for small teams or first-time users.
You’ll learn:
How to set up a SharePoint Communication Site
Basic customization tools
How to create lists and site pages
How to manage permissions
🎯 No fluff, just the essentials to get you started fast.
👍 Like the video if it helped, and subscribe for more Microsoft 365 tips!
Learn more here: https://sharepointinpractice.com/
#SharePoint #Microsoft365 #SharePointTutorial #Intranet #Office365 #SharePointIntranet #ProductivityTools #BeginnersGuide #DigitalWorkspace
Seeking Approval In Microsoft Sharepoint
Learn how to manage and request approvals efficiently in Microsoft SharePoint. This tutorial walks you through the steps to set up approval workflows, manage permissions, and collaborate effectively with your team using SharePoint’s built-in features. Ideal for beginners and professionals looking to streamline document management processes.
🔔 Don’t forget to like, share, and subscribe for more Microsoft 365 tips!
Claim Your Copy Here: https://sharepointinpractice.com/
—
#SharePoint #Microsoft365 #WorkflowAutomation #DocumentManagement #SharePointApproval #Office365 #SharePointTutorial