Create Automated workflows with Power Automate

Automation is a hot topic right now. It’s up there on the list of tech buzzwords right next to Big Data, Machine Learning, and Blockchain. On a more basic level, have you ever thought about how much easier your life would be if you could automate certain repetitive tasks? Enter Power Automate….

In this episode of “Today I Learned” I am going to walk you through how to use Microsoft’s Power Automate to create automated workflows to streamline processes and allow you to focus on value-adding tasks. There is a free desktop version available but for the purposes of this example, we’re going to use the licensed application. 

Log in to

There are three options to create a flow and we’ll walk through an example of each.

Start from Blank

This option allows you to create a completely custom flow.

Here we are going to create a workflow to send a weekly message to a Slack channel.

As with any process or code, you have to test it to make sure it works. The proof is in the pudding!

Start from a Template

This option allows you to leverage the hundreds of workflow templates as a starting point, with the option to customize as you go. 

Here we are going to trigger a daily motivational email reminder.

Start from a Connector

This option allows you to link together everyday apps for task automation.

Here we are going to trigger an email to be sent when certain keywords are mentioned in a tweet.

My Flows

This is your workflow repository. You can edit the workflow properties including Flow Name and Description. You can also edit the flow criteria. It’s really easy to pause workflows as well.

Why Automate?

Besides eliminating repetitive tasks, the goal of automation is to save time. And time saved = money saved.

Here’s how:

If it takes one hour a week to complete a task, at a rate of $55 per hour, for a company of 40 people, you’ve saved 2,080 hours which in turn creates $114,400 a year in company savings. 

Call to Action

Start thinking of ways to automate tasks within your organization. For instance, apply a patch to a known software issue, upsert records in a database in real time, send notification of a critical ETL job failure, process recurring accounts payable entries like office rent, publish website/blog updates to your company’s social media, or send out orientation packets when a new member joins your board.

Want to Learn More?

Have any questions, comments, or curiosities? Feel free to reach out to me on Twitter or LinkedIn.

About Tessellation

We are a modern analytics consultancy. We enable and manage organizations’ analytics and self-service teams by educating people, optimizing technology, developing world-class products, and providing sustainable results. Curious to know how we can level up your organization’s analytics? Click here!

Interested in joining the Tessellation Team as a data analyst, Tableau expert, dashboard designer, or data scientist? We’re hiring! Check out our latest job listings on our website and on our Linkedin page!

Subscribe to Our 'Data Cap' Newsletter!

Want a monthly insights from the Tessellation Team with tips, tricks, and secrets to improve your analytics?

Sign up below and we'll deliver articles, events, and how to's straight to your inbox.
Comments are closed.