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 gerry@lightlever.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 gerry@lightlever.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
Sharepoint Tip: How to Make Page Links Open in Same Tab

Tired of SharePoint links opening in new tabs? In this video, Lalo shows you how to easily fix this using a simple JSON code generated by Copilot. No coding experience needed—just follow along as he walks you through the exact steps to make SharePoint links open in the same tab.
What you’ll learn:
✅ How to use JSON formatting in SharePoint
✅ Step-by-step guide to applying the code
✅ Tips for troubleshooting if it doesn’t work immediately
👉 Copy the JSON code from the video here:
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “a”,
“attributes”: {
“href”: “[$FileRef]”,
“target”: “_self”
},
“style”: {
“color”: “#0078d4”,
“text-decoration”: “none”,
“font-weight”: “bold”
},
“txtContent”: “[$Title]”
}
This solution works for modern SharePoint pages and can save you and your team a lot of frustration.
💬 If this video helped you, don’t forget to like, share, and subscribe for more quick SharePoint tips!
Claim the book and helpful tools and tips here: https://sharepointinpractice.com/
#SharePoint #Microsoft365 #JSON #SharePointTips #Copilot #Office365 #ProductivityHacks
Beating Bad WiFi: Remote Work Survival Tips

Working remotely but struggling with bad WiFi? Whether you’re a digital nomad, a remote worker, or just dealing with unstable internet, staying productive can be a challenge. In this video, I’ll share essential survival tips for working online with poor connectivity. From battery backups and direct cables to mobile hotspots and asking hosts for Speedtest results—these tricks will help you stay connected no matter where you are. Don’t let bad internet slow you down!
Top SharePoint Mistakes Costing Your Intranet Project Time and Money!

Are you making these common SharePoint mistakes that could be costing your organization time and money? In this video, we uncover the top pitfalls teams face when building SharePoint intranet sites and how to avoid them. From user training to change management, discover expert tips for creating a simple, effective, and user-friendly intranet.
We’ll cover:
Why planning ahead is crucial for SharePoint success
The importance of training and user engagement
Change management strategies for smooth rollouts
How to avoid overcomplicating your intranet build
Don’t let these mistakes derail your SharePoint project! Watch now and set your team up for success.
👉 Subscribe for more SharePoint tips and Microsoft 365 insights!
Claim your copy of the book here: https://sharepointinpractice.com/
Get in touch with Gerry (Not Jerry =P ): https://lightlever.ca/
—
#SharePoint #Microsoft365 #SharePointTips #IntranetDevelopment #ChangeManagement #UserTraining #SharePointMistakes #BusinessTools #IntranetRollout #ProjectSuccess