Get started with Power Automate and Smartsheet with a build along solution to send data from a Smartsheet row using Microsoft Outlook.
What You’ll Learn in this Course
- Fundamentals of Arrays and Objects in Power Automate
- Extracting data from arrays and objects that Smartsheet sends to Power Automate
- Send an Outlook email containing Smartsheet data when a new row is added in Smartsheet
Who is this Course for?
Smartsheet users that want to learn how to not be bound by limitations in Smartsheet. More specifically, you’ll see how to use Microsoft Outlook to send a notification from your own company’s domain instead of relying on Smartsheet’s automations which come from Smartsheet’s domain. This allows recipients of your Smartsheet triggered notifications a branded experience, which is even more critical if you wish to send notifications to external recipients! Or, if you just want to impress your colleagues. We won’t let on how EASY it is to do!
This isn’t a Boring Lecture Course, it’s a Hands on Build Along!
The format is a build along, where each step is explained so you can build the same solution in your own Smartsheet and Power Automate environment. To help this build along effort, downloadable assets are available on the appropriate lesson to help jumpstart your solution build out.

Darren Mullen
Instructor
Darren is the founder of Smart Workflow Guru and is ready to guide you on your journey to becoming an expert. He is known for his Smartsheet consulting work under his company brand, Smartsheet Guru. Also under this banner he built a successful group Smartsheet coaching program known as the Smartsheet Guru Elite. Furthermore, he provides, and enjoys, coaching Smartsheet users both in the group setting and one on one.
His love for teaching shows through on his YouTube channel and with his publishing of 2 books on Smartsheet, Smartsheet User Guide for Accelerated Learning and Smartsheet Architecture Solutions. Both of which achieved the coveted orange bestsellers badge on Amazon.
When he’s not busy consulting, creating content or courses, he enjoys spending time with his growing family in the Southern Arizona desert.
Free
Free access to this course.
Course Orientation
Solution Setup: Smartsheet and Power Automate
Building the Solution in Power Automate
What Others Have Said
I just wanted to share how valuable your Power Automate course has been. It is genuinely one of the most useful training resources I have used in my years. I would consider myself somewhere between intermediate and advanced in Smartsheet, but I was very much a beginner in Power Automate. The way you broke down each step and explained the details made the platform much more approachable and gave me the confidence to build dozens of automations. In addition to the course, SSFeatures has saved me hours of work. The ability to quickly copy column IDs, hide and unhide columns, rename columns, and create column templates has been incredibly helpful. These are features that feel essential, and the lack of them out of the box was nearly enough for my company to reconsider using Smartsheet altogether. Thank you for creating tools and training that are both practical and genuinely impactful.

