PowerAutomate

Mar 29, 20231 min read

Removing Duplicates from an Array in PowerAutomate

A while back, I was using PowerAutomate to automate the creation of individual, personalised Calendar Invites to users based on a set of...

142 views0 comments

Tony Ogilvie

Sep 25, 20221 min read

Escaping Single Quotes in PowerAutomate

I had a requirement recently to remove a single quote from a string in one of my PowerAutomates. Simple enough you might think. Just use...

2,947 views2 comments

Converting Outlook Events to SharePoint Timesheet Entries - a Quick Overview

Tony Ogilvie

Nov 17, 20211 min read

Converting Outlook Events to SharePoint Timesheet Entries - a Quick Overview

In this quick video we are going to see how you can use the Otagem Calendar to Timesheet Flow to convert events in your Outlook Calendar...

159 views0 comments

Auto-filling a SharePoint Timesheet System using the Events in your Microsoft 365 calendar

Tony Ogilvie

Nov 12, 20211 min read

Auto-filling a SharePoint Timesheet System using the Events in your Microsoft 365 calendar

I was recently asked by a customer using a SharePoint list based Timesheet system if it was possible to populate entries in the Timesheet...

144 views0 comments

PowerAutomate - storing separated date and time values in a SharePoint list

Tony Ogilvie

Sep 30, 20211 min read

PowerAutomate - storing separated date and time values in a SharePoint list

Sometimes, as part of a Flow (PowerAutomate is such a mouthful!), you want to store the date something happened in Field A in SharePoint...

69 views0 comments

Create SharePoint Libraries with short URLs using PowerAutomate (Flow) !

Tony Ogilvie

Jul 15, 20212 min read

Create SharePoint Libraries with short URLs using PowerAutomate (Flow) !

If you use SharePoint to create Document Libraries regularly, you'll know that when you use the "Create document library" screen to...

157 views0 comments

Locking down Security on Documents and List Items in SharePoint Online at the point of creation

Tony Ogilvie

Jun 18, 20211 min read

Locking down Security on Documents and List Items in SharePoint Online at the point of creation

In this quick video, we're going to see how you can lock down the security on a Document or List Item as soon as it has been created or...

112 views0 comments

Updating SharePoint List Items and triggering Flows - be careful with timing!

Tony Ogilvie

May 5, 20212 min read

Updating SharePoint List Items and triggering Flows - be careful with timing!

So recently I had a problem with a PowerAutomate (Flow) triggered from a button on a PowerApps form. This Flow just would not fire...

32 views0 comments

Displaying User Friendly Timestamps when working with Power Automate and SharePoint Online

Tony Ogilvie

Apr 23, 20213 min read

Displaying User Friendly Timestamps when working with Power Automate and SharePoint Online

When implementing Approval Workflows using Microsoft Power Automate (aka Flow) and SharePoint Online, a typical requirement is to capture...

542 views0 comments

Sending a Confirmation Email back to the originator of a Flow Process

Tony Ogilvie

Nov 22, 20201 min read

Sending a Confirmation Email back to the originator of a Flow Process

Power Automate is great for sending Email Confirmations to specified users. However, sometimes you need to send a confirmation email...

359 views0 comments

Renaming a SharePoint File via Power Automate

Tony Ogilvie

Nov 22, 20201 min read

Renaming a SharePoint File via Power Automate

One of the glaring omissions in Power Automate is the ability to rename a file in a SharePoint Document Library. I'd seen a few online...

5,509 views1 comment