top of page
WELCOME
Otagem is here to help you get the very best out of Microsoft 365!
The Microsoft 365 Experts
Otagem is an IT consulting firm based in the UK and Ireland, delivering tailored Microsoft 365 solutions to clients worldwide since 2014.
We provide a comprehensive range of Microsoft 365 consulting services, fully customisable to meet the unique needs of your business.
With deep expertise in Information Management and Automation, we specialise in leveraging SharePoint, Teams, and the Power Platform to help organisations work smarter.
Our key services include:
-
Advanced Content Management with SharePoint and Teams
-
Business Process Automation using Power Apps and Power Automate
-
Understanding your business data using Power BI
-
Effective Online User Training to empower your teams
No matter your challenge, we’re here to make it happen. Get in touch with us today to explore what’s possible.
Recent Blog Posts
Tony's Top Tips - accessing the SharePoint Version History for a List Item from within PowerApps
A nice touch I like to build into my PowerApps is a button which takes the user to the SharePoint Version History for SharePoint list...
Tony Ogilvie
Nov 3, 2024
54 views
1 comment
Tony's Top Tips - How to ensure Document Library Naming Schemes are preserved, even after a rename using Intapp
What's this about? Intapp Documents has a very powerful feature which allows you to specify the naming scheme of a SharePoint Site or...
Tony Ogilvie
Oct 31, 2024
24 views
0 comments
Tony's Top Tips - How to perform a Cache Reset on Intapp Documents via the API
Sometimes, you may wish to perform a Cache Reset on the Intapp Documents service via the Intapp Documents API, rather than via the User...
Tony Ogilvie
Oct 30, 2024
21 views
0 comments
Tony's Top Tips: Advanced Color-Coding for SharePoint Lists
SharePoint lists are great! They are brilliant for many users, allowing much better storage of structured data than Excel spreadsheets. ...
Tony Ogilvie
Oct 16, 2024
118 views
0 comments
Tony's Top Tips: Adding Folder Paths to a SharePoint Document Library View
Sometimes, when working in a SharePoint Document Library, you want to see the Folder Path for each document. This is especially useful...
Tony Ogilvie
Aug 14, 2024
47 views
0 comments
Tony's Top Tips: Creating Permanent Links to Documents in SharePoint Online using the Document ID Service
SharePoint provides a variety of ways to create links to Documents; some of these links can expire, and some of these links depend on...
Tony Ogilvie
Jun 14, 2023
460 views
0 comments
Nice Table Format for PowerAutomate Generated Email Messages
This blog post will be updated shortly! <p>Hi ,<br> <br> Please a new Request has been submitted as follows:<br> <br> <style> table.tb {...
Tony Ogilvie
Apr 6, 2023
47 views
0 comments
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...
Tony Ogilvie
Mar 29, 2023
210 views
0 comments
Making sure Hero Webparts stretch across the full width of a SharePoint Communication Site Page
** The steps in this article only apply to SharePoint Communication Sites! ** The Hero Webpart in SharePoint Online Communication Sites...
Tony Ogilvie
Jan 27, 2023
722 views
0 comments
Registering Pre-Existing SharePoint Objects in Intapp Documents
This video acts as a guide to registering existing SharePoint Sites and Libraries into Intapp Documents using the Intapp Swagger API....
Tony Ogilvie
Jan 26, 2023
34 views
0 comments
Useful Scripts for the Intapp Collaboration and Content Platform
Bulk updates to Item Security Sometimes, you need to run a script to Bulk Update security on a list of Matters in the ICCP Platform....
Tony Ogilvie
Dec 20, 2022
24 views
0 comments
Tony's Top Tips - The Intapp Collaboration and Content Platform
Metadata Defaults in ICCP Forms As of November 2022, When referencing a SharePoint property in the Default Value field in an ICCP form,...
Tony Ogilvie
Nov 29, 2022
32 views
0 comments
Tony's Top Tip: Changing the colour of the Suite Bar in Microsoft 365
That blue bar along the top of your Microsoft 365 sites? That's called the "Suite Bar", and in all standard Microsoft 365 Tenants, it's...
Tony Ogilvie
Nov 22, 2022
616 views
0 comments
Creating custom colour schemes to make your SharePoint Online sites look good!
SharePoint Online comes with a set of standard Color Themes, which you can use to change the look of your site by going to Site Settings...
Tony Ogilvie
Nov 18, 2022
4,046 views
0 comments
Useful Keyboard Shortcuts for Apple Devices 🍏
Below is a selection of really useful Apple Keyboard Shortcuts which I live by!
Tony Ogilvie
Sep 30, 2022
15 views
0 comments
Copying vs Moving Files in SharePoint Online
A quick blog post, showing how to COPY files in SharePoint from one location to another, and how to MOVE files from one location to...
Tony Ogilvie
Sep 26, 2022
136 views
0 comments
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...
Tony Ogilvie
Sep 25, 2022
4,890 views
2 comments
The list of SharePoint Role IDs
Sometimes, when working with SharePoint Security, you want to grant particular roles to users or groups, e.g., - Grant Tony Full Control...
Tony Ogilvie
Sep 11, 2022
4,265 views
0 comments
Using Intapp Documents (Repstor affinity) to auto-file Luggage Tagged Emails from an Archive PST
In this short video, we'll see how you can use Intapp Documents (formerly known as Repstor affinity) to auto-file Luggage Tagged Emails...
Tony Ogilvie
Sep 7, 2022
85 views
0 comments
Pinning Matters for Users using the Intapp Documents API
In this short video, we'll see how you can use the Intapp Documents (formerly Repstor custodian) API to pinning Matters (corresponding to...
Tony Ogilvie
Sep 7, 2022
66 views
0 comments
Reapplying Templates to SharePoint Libraries
In this quick video, we'll see how you can reapply Templates to SharePoint Libraries in Intapp Documents (also known as Reprovisioning). ...
Tony Ogilvie
Sep 7, 2022
39 views
0 comments
Embedding a custodian Web Part onto a SharePoint Page
To embed an Intapp Documents (formerly known as Repstor custodian) Webpart onto a SharePoint page, you can simply use the Embed Code...
Tony Ogilvie
Sep 2, 2022
54 views
0 comments
Custom JSON for use in the Intapp Collaboration and Content Platform
When using the Intapp Collaboration and Content Platform (ICCP, formerly known as Repstor custodian) to create structures in SharePoint...
Tony Ogilvie
Sep 2, 2022
145 views
0 comments
PowerApps Forms defaulting to the first item in a SharePoint List after Submission?
I recently came across a weird issue in PowerApps, which I figured I'd share. I had a PowerApps form, sitting over a SharePoint Data List....
Tony Ogilvie
Apr 4, 2022
2,916 views
0 comments
Passing List IDs from SharePoint to PowerAutomate via PowerApps
A common request from customers using Microsoft 365 is the implementation of Review and Approval Processes across a variety of SharePoint...
Tony Ogilvie
Dec 23, 2021
1,048 views
0 comments
Allowing "Fill-In Choices" on PowerApps Choice Fields
In SharePoint Online, you can set up "Choice" fields, with the option of allowing "Fill-in" choices, which means the user can manually...
Tony Ogilvie
Dec 8, 2021
5,622 views
3 comments
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...
Tony Ogilvie
Nov 17, 2021
167 views
0 comments
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...
Tony Ogilvie
Nov 12, 2021
157 views
0 comments
PowerApps - defaulting a user field to the currently logged on user
Sometimes, you want to be able to create a PowerApps form which has User Fields which default to the currently logged on user. You can do...
Tony Ogilvie
Oct 7, 2021
355 views
0 comments
PowerApps - Formatting Date columns in PowerApps Data Tables
When displaying a Data Table in a PowerApps form overlaying a SharePoint list, you may have noticed that Date Fields display in
Tony Ogilvie
Oct 1, 2021
361 views
0 comments
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...
Tony Ogilvie
Sep 30, 2021
75 views
0 comments
SharePoint - splitting a Date-Time field into separate Date and Time fields
One of the things that can upset people using SharePoint Online is how it displays Date Time stamps. For example, in a list view the...
Tony Ogilvie
Sep 30, 2021
1,288 views
0 comments
PowerApps - formatting and defaulting Date Time fields on SharePoint List Forms
When you use PowerApps form overlaying a SharePoint List, you may have noticed that Date Fields often default strangely, e.g., in this...
Tony Ogilvie
Sep 27, 2021
719 views
0 comments
Using Guided Access Mode on an iPad to give frictionless access to your favourite App
One of the things I like to use my iPad for is taking notes and recording tasks using my favourite app while working on my main computer....
Tony Ogilvie
Jul 19, 2021
37 views
0 comments
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...
Tony Ogilvie
Jul 15, 2021
187 views
0 comments
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...
Tony Ogilvie
Jun 18, 2021
128 views
0 comments
Turning off the "Request Sign-off" feature in a SharePoint Online List
SharePoint Online Lists and Libraries come with a Request Sign-off feature, that can be really confusing for end users, especially if you...
Tony Ogilvie
May 7, 2021
424 views
0 comments
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...
Tony Ogilvie
May 5, 2021
40 views
0 comments
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...
Tony Ogilvie
Apr 23, 2021
590 views
0 comments
Using PowerShell to send a warning email if a long-running script has thrown an error
If you're like me, you may need to run long-running PowerShell scripts to do various things in SharePoint, like updating large SharePoint...
Tony Ogilvie
Apr 10, 2021
268 views
0 comments
Determining which Files & Folders have been shared with External Users in SharePoint Online
SharePoint Permissions can be complex enough - but when you introduce External Sharing (the ability for users to share Folders and...
Tony Ogilvie
Mar 1, 2021
49 views
0 comments
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...
Tony Ogilvie
Nov 22, 2020
388 views
0 comments
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...
Tony Ogilvie
Nov 22, 2020
5,898 views
1 comment
SharePoint Co-Authoring vs Check In Check Out
In this video, we explore the differences between Co-Authoring and Check In - Check Out of files when editing documents in SharePoint Online
Tony Ogilvie
Nov 20, 2020
44 views
0 comments
SharePoint Classic Pages - How do I stop Windows scaling causing problems?
So you've set up your SharePoint Classic Page to display nicely on a certain screen resolution; however, when someone else on a high...
Tony Ogilvie
Oct 28, 2020
158 views
0 comments
How to see the Add button when adding a WebPart in SharePoint Online?
This video shows a quick and easy workaround to a problem which can occur when adding Web Parts to a SharePoint Online Page; this is a...
Tony Ogilvie
Sep 19, 2020
46 views
0 comments
Using Page Tagging in a SharePoint Online Enterprise Wiki
In this video, you'll see how to use Page Tagging in a SharePoint Online Enterprise Wiki
Tony Ogilvie
Aug 30, 2020
45 views
0 comments
Changing the Look and Feel of a SharePoint Online Enterprise Wiki
A quick video showing some basic options for changing the Look and Feel of a SharePoint Online Enterprise Wiki using: Themes Change the...
Tony Ogilvie
Aug 27, 2020
50 views
0 comments
Adding a Table of Contents to multiple SharePoint wiki pages using a WebPart
In this video, we'll see how you can add a simple, auto-generated Table of Contents to a SharePoint Online Wiki Page using a WebPart. ...
Tony Ogilvie
Aug 20, 2020
64 views
0 comments
Adding a Table of Contents to a SharePoint Online Wiki Page
In this video, we'll see how you can add a simple, auto-generated Table of Contents to a SharePoint Online Wiki Page. You can find the...
Tony Ogilvie
Aug 15, 2020
647 views
0 comments
bottom of page