[su_panel color="#F73F43" border="1px solid #F73F43" radius="3" text_align="center" url="https://manueltgomes.com/power-automate-cookbook/"]This article is outdated. I've created a new section to track everything. Please refer to the "Cookbook" section.[/su_panel]
Welcome to our Microsoft Power Automate template archive created by Manuel Gomes and with contributions from other people.
This list contains some of the templates that we find useful. Microsoft has a much more extensive template library, but I want to give you some that I create and think it would be helpful for you.
I'll post updates frequently and Tweet about so be sure to follow me @manueltgomes for any updates.
Email
Total number of templates: 11
Last update: 3rd August 2020
Archive
Jump to the section:- Outlook
- Microsoft Forms
- Actions
- Data Types
- Triggers
- Management
- Other
Outlook
Calendar
Generate an ICS file
Generate dynamically an ICS file based on any parameters.Add a buffer after meetings
Adds a 15-minute buffer as soon as you create a new appointment.Move all emails to a folder that arrive after working hours
If you receive an email between the defined working hours, it's moved to a folder until the next Power Automation picks it up, during working hours, and transfers it back.Move back the emails to the inbox at the start of the day
At the beginning of the day, move all emails that arrived outside working hours and move them back to the Inbox.Microsoft Forms
Parse choice elements
Parse multi-choice element to insert into SharePoint
This template provides a full Flow that gets the information from Microsoft Form and parses it so that we can insert it into a SharePoint choice column. I wrote an article explaining all the processes so, if you have any questions, you can check it here.Actions
Excel
Access Excel Using a Custom Path
How to go around the limitation where you can't access an Excel with a Dynamic Path. This template works as a "function" so you can import it and use it in multiple Power Automates.CSV
CSV Parser with no external dependencies
How to have a CSV parser without any external dependencies. This template works as a "function" so you can import it and use it in multiple Power Automates. I wrote a step-by-step tutorial in how I built this template that you can find here.Data Types
Date
Convert timestamp into a date
This template provides a formula that you can convert a timestamp to date and not much more. We've only focused on demonstrating the overall workflow and how you can use it. The template can be used, for example, when integrating with APIs that, usually, return timestamps. Note: that this template is only to demonstrate the formula’s usage, so please adjust it to your needs. Also, you'll see in Microsoft's documentation description of timestamps as objects like '2019-10-28T10:10:10Z'. Intentionally I'm calling these Dates and keep the UNIX concept of the timestamp to avoid confusion.Convert Excel number into a Date
You can use this template as a "function" where you can call it from anywhere, and it will return the information that you want. Please note that I'm returning a String in UTC format so that it's easier to convert it then to your timezone.Triggers
Request Triggers
Example of a Get Trigger
This template provides a simple Flow that demonstrates how to call a Request trigger using the Get method. To be able to test it, you need to add your destination Flow's URL, but you can check the Parse Information section for an example. I wrote an article explaining all the processes so, if you have any questions, you can check it here.Management
Agile / Scrum
Standup/Daily Random Talk Order
Want to have a smooth Standup/Daily? Randomize the order that people will talk about and post it in a channel. Then people know when to speak and, since it's different every day, people don't complain about the order. This template is part of an article so, if you have any questions, you can check it here.Other
Parsing Information
Parse UTM Parameters
This template provides a full Flow that gets a URL and parses the UTM values into individual variables. I wrote an article explaining all the processes so, if you have any questions, you can check it here.Parse UTM Parameters With Request Trigger
This template provides a full Flow that gets a URL and parses the UTM values into individual variables. It's similar to the one above but uses the Request trigger so that we can re-use the logic in other Flows. If you don't know how to call a request Flow, please check the Request Trigger section for an example. I wrote an article explaining all the processes so, if you have any questions, you can check it here.Sorting
Numeric array sorting
This template provides you with a way for you to sort a numeric array. I designed it so that you can re-use it in your Power Automates without the need to duplicate the code.How to use the templates
You can use my step-by-step tutorial in how importing and exporting works. It’s super easy with only some minor things to take into consideration. You can also check our articles on Microsoft Power Automate to learn more about the tool and know-how to create your own. I encourage you to download the templates and adapt them to your needs. Don’t worry about attribution. It’s not necessary, but I appreciate it if you do.Have a cool Power Automate Template?
Awesome, send it my way via email with a simple explanation of what it does so that I can include it. I’ll attribute submitted templates, so please include any information you want to be displayed. I’ll test them first to ensure quality and that they don't do anything strange. I'll only post them if I find that there's something worthwhile that others can benefit from. It can also take me a while depending on the workload that I have at the time, but I promise to look at all of them. Don’t submit any template:- That depends on private APIs
- that collect information from the user of any sort.
- Needs another template or flow to run.
No comments yet
Be the first to share your thoughts on this article!