Power Automate: Template Archive

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.

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.

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 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.

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.

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.

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.

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.

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.

Download it here