Create new group alert using Power Automate

Do you want to know when a new group has been created with for example Microsoft Teams? How do you create a new group alert? Create a new flow Ideally … read the create-new-group-alert-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Create new group alert using Power Automate Do you want to know when a new group has been created with for example Microsoft Teams? How do you create a new group...

Read More

Delegation Warnings in Power Apps

We have all seen them, Delegation Warnings, but what is delegation and how do you clear your Power Apps from these warnings Delegation I’m going to start this post by … read the delegation-warnings-in-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Delegation Warnings in Power Apps We have all seen them, Delegation Warnings, but what is delegation and how do you clear your Power Apps from...

Read More
Verify all the SharePoint sites that belong to Microsoft Teams Private Channels
Nov22

Verify all the SharePoint sites that belong to Microsoft Teams Private Channels

When creating a Microsoft Teams private channel by default, it creates a brand new SharePoint site which will store all the information related to that private channel. This is a special site that contains a couple of settings. I will leave at reference an article that you can check to check those settings. I will share some PnP PowerShell commands that will help us to get this… Continue Reading David Ramalho’s Article on...

Read More

1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time

It can be difficult to get started with the Power Platform, blogs help, training helps, but powerplatformlearn.com can definitely help! Learning Learning can be done in so many ways. Personally … read the master-power-platform-powerplatformlearn post Continue Reading Pieter Veenstra’s Article on their blog 1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time It can be difficult to get started with...

Read More

Compare 2 Excel files using Power Automate

This is such a common scenario. You receive Excel files on a regular basis and you want to compare the files collect the new rows with Power Automate. SharePoint Setup … read the compare-2-excel-files-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Compare 2 Excel files using Power Automate This is such a common scenario. You receive Excel files on a regular basis and you want to compare the...

Read More
SharePoint Syntex – AI powered knowledge management
Nov04

SharePoint Syntex – AI powered knowledge management

One of the highest priorities for Microsoft is how it can apply artificial intelligence to help organisations be more productive. The Microsoft 365 platform enables you to harness the knowledge and expertise of your organisation, empowering everyone to make more informed decisions and take action faster and it has the potential to be even more intelligent. Project Cortex Last year Microsoft announced a new Microsoft 365...

Read More

Rename SharePoint folders using Power Automate in 2 easy steps

Have you ever wanted to rename SharePoint folders with Power Automate? REST API call to use According to the documentation the following two calls are needed to rename SharePoint folders. … read the rename-sharepoint-folder-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Rename SharePoint folders using Power Automate in 2 easy steps Have you ever wanted to rename SharePoint folders with Power...

Read More

Read dates from Excel with Power Automate

To read dates from Excel files can be tricky, as Excel only give you the number of days since 1 January 1900. Dates in Excel I’ve created myself an Excel … read the read-dates-from-excel-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Read dates from Excel with Power Automate To read dates from Excel files can be tricky, as Excel only give you the number of days since 1 January 1900....

Read More

Show 21 – Part 2: Telling Stories

Telling Stories – more than just a great album by the Charlatans, it is a way to share the benefits of tools like those in the Power Platform. This week we are joined by Clarissa Gillingham as she shares her experience of forming great stories and some great tips for creating your own. If you would like to appear on the show, please drop us a line using the form at

Read More
How to know who view files/pages on SharePoint
Nov01

How to know who view files/pages on SharePoint

A couple of days ago I come across a SharePoint feature that is very useful to check who view the file that is a SharePoint document library. This feature can be very useful to check who viewed that particular file. This feature will allow you do understand you saw your meeting records if you’re saving then on SharePoint.  Usually, that feature is deactivated on all the sites…. Continue Reading David Ramalho’s Article on...

Read More

SharePoint 2010 workflows retiring next week!

Are you ready for your SharePoint 2010 Workflows retiring next week? SharePoint 2010 Well SharePoint 2010 seems to be a long long time ago. Note the comment in the post: … read the sharepoint-2010-workflows-retiring post Continue Reading Pieter Veenstra’s Article on their blog SharePoint 2010 workflows retiring next week! Are you ready for your SharePoint 2010 Workflows retiring next week? Well SharePoint 2010 seems to be...

Read More
Remove Microsoft Teams Deleted Teams
Oct26

Remove Microsoft Teams Deleted Teams

A few weeks ago, I was playing with the Microsoft Teams creation using Microsoft Graph endpoint and as expected, a couple of teams were created because of that. Using these endpoints can be extremely useful to automate a process on our organization. However, when you’re doing this it will create a lot of “testing” teams. This is also applicable to Teams that are not… Continue Reading David Ramalho’s Article on their blog...

Read More

Create Distinct filters for Power Apps galleries

So you add a gallery to your app in Power Apps and you want to create some filters (distinct filters of course!). This is the post to read! Galleries I’ve … read the distinct-filters-power-apps-galleries post Continue Reading Pieter Veenstra’s Article on their blog Create Distinct filters for Power Apps galleries So you add a gallery to your app in Power Apps and you want to create some filters (distinct filters of...

Read More

Send push notifications to start your app in Power Apps

Have you ever wanted to send push notification to people’s phones to run a Power App? What do you need? The aim is to send a push notification to user’s … read the push-notifications-start-app-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Send push notifications to start your app in Power Apps Have you ever wanted to send push notification to people’s phones to run a Power App?...

Read More

Patch the Common Data Services with Power Apps

Using the patch Function to update records in the Common Data Services can be easy, but a lot depends on the field types used. Reasons for this post This week … read the patch-common-data-services-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Patch the Common Data Services with Power Apps Using the patch Function to update records in the Common Data Services can be easy, but a lot depends on the...

Read More

Show 20 – Part 2: Just Say No

This week we learn how saying no means that you can actually say yes more often, adding more control to what you do and being more productive with it. We chat about trying not to over commit and work out when you can work most effectively. <!– –> If you would like to appear on the show, please drop us a line using the form at https://www.greyhatbeard.com/upcoming-shows. We’d love to hear… Continue Reading Kevin...

Read More

Deploy Canvas Apps and Flows through solutions

When you deploy Canvas Apps and Flows in Power Apps and Power Automate you can choose to deploy them one by one but adding them to solutions is easier. Solutions … read the deploy-canvas-apps-and-flows-solutions post Continue Reading Pieter Veenstra’s Article on their blog Deploy Canvas Apps and Flows through solutions When you deploy Canvas Apps and Flows in Power Apps and Power Automate you can choose to deploy them one...

Read More

Address Input in Power Apps

When you app needs users to input addresses, you can now use the Address input control. Address Input Control While I’m writing this post the address Input control is still … read the address-input-in-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Address Input in Power Apps When you app needs users to input addresses, you can now use the Address input control. While I’m writing this...

Read More

Get the changes made to SharePoint Items with Power Automate

Recently the Get changes for an item or file action was added to SharePoint. Here a full overview Get changes for an item or file action The Get Changes for … read the changes-sharepoint-items-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Get the changes made to SharePoint Items with Power Automate Recently the Get changes for an item or file action was added to SharePoint. Here a full...

Read More

Better error handling with parallel branches in Power Automate

This post is all about error handling and parallel branches. General error handling in Power Automate In the past I’ve written quite a few posts about the Try-Catch pattern. Which … read the error-handling-parallel-branches-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Better error handling with parallel branches in Power Automate This post is all about error handling and parallel...

Read More

Use Azure Computer Vision to name your images with Power Automate

To recognize images in SharePoint Azure Computer Vision can be a great help. In this post an example. What is Azure Computer vision Azure Computer Vision can be used to … read the azure-computer-vision-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Use Azure Computer Vision to name your images with Power Automate To recognize images in SharePoint Azure Computer Vision can be a great help. In...

Read More

Business Rules in Model Driven Apps

When you develop model driven apps, business rules can be very useful. Introduction to business rules In this posts I will look at the business rules and how they work. … read the business-rules-in-model-driven-apps post Continue Reading Pieter Veenstra’s Article on their blog Business Rules in Model Driven Apps When you develop model driven apps, business rules can be very useful. In this posts I will look at the business...

Read More

Just 3 clicks to disable an action in Power Automate

Have you ever wanted to disable an action in your Power Automate flow? It is just 3 clicks away. Disable an action with Static Result So you have built a … read the disable-an-action-in-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Just 3 clicks to disable an action in Power Automate Have you ever wanted to disable an action in your Power Automate flow? It is just 3 clicks away. So you have...

Read More

Actions function in Power Automate

Most flow developers will know about functions like body and outputs in Power Automate. But how about the actions function? The Actions function The actions function is often forgotten about, … read the actions-function-in-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Actions function in Power Automate Most flow developers will know about functions like body and outputs in Power Automate. But...

Read More
How to customize channel email on Microsoft Teams
Sep21

How to customize channel email on Microsoft Teams

Do you know you can send email to Microsoft Teams channel? If so you are familiar with this feature, you know it generates an email that is far from being friendly. With this blog post, I will show how you can make some configurations to have a friendly email which will be a lot easier for the end-user. If you are not aware of the feature that I’m talking about on this blog post… Continue Reading David Ramalho’s...

Read More
Show/hide the New button from a SharePoint Document Library
Sep20

Show/hide the New button from a SharePoint Document Library

There are some scenarios where the document libraries on SharePoint are used only to upload files. For example, let’s say that you have a sales team that need to upload to a document library an excel every week. Therefore, maybe the new button to have an option to create a new folder or create a new document doesn’t make much sense. So, if click on that button as admin of the… Continue Reading David Ramalho’s...

Read More

Show 18 – Part 1: News and front of mind

While we eagerly await the news to come from Ignite, Peter Rising was kind enough to join us again and share some thoughts on Security and Compliance in Microsoft 365. We first covered some interesting ideas from Facebook, sunken datacentres and debated laptops vs desktops. <!– –> If you would like to appear on the show, please drop us a line using the form at

Read More

Show 17 – Part 1: News and front of mind

After almost two months, the three of us are back together and ready to share the latest info and our thoughts to you all. This week, we think about how you can stay in contact with the latest information, discuss the Microsoft 365 roadmap and our thoughts and wishes for what will be announced at Ignite 2020. First up was the news including why you should backup your Teams chat, the end of… Continue Reading Kevin...

Read More

Show 16 – Part 1: News and front of mind

Have you been using lockdown and the extra time at home during the pandemic to try and pass some Microsoft Certifications? Or perhaps you are just interested in how you can better implement Security and Compliance in Microsoft 365? We were joined by Peter Rising this week as Al and Garry ran the show while Kevin sweltered in a tent on the Isle of Wight. First up was the news including several… Continue Reading Kevin...

Read More

Show 16 – Part 2: Microsoft 365 Security Certification

Have you been using lockdown and the extra time at home during the pandemic to try and pass some Microsoft Certifications? Or perhaps you are just interested in how you can better implement Security and Compliance in Microsoft 365? We were joined by Peter Rising this week as Al and Garry ran the show while Kevin sweltered in a tent on the Isle of Wight. We aimed to cover the following on… Continue Reading Kevin McDonnell’s...

Read More
Add multiple users in a SharePoint site
Aug03

Add multiple users in a SharePoint site

A few days ago, I had a request to add multiple users in a SharePoint site but using the default interface, I can only add one by one. If we have a long list of users that need to be added to the site this tasks can take a while. So I come up with a PowerShell that will do this task based on a CSV file that contains the email that will make this process faster For this PowerShell, I… Continue Reading David Ramalho’s...

Read More

Show 15 – Part 1: News and front of mind

Never let it be said that we turn down a challenge. We were asked by a listener to try and summarise Power Platform licensing and rather than just share what we knew, we managed to bring in one of the Microsoft experts on the subject, the very tattoed and always entertaining Chris Huntingford. Then, by sheer chance, Microsoft decided to drop the bombshell news of Dataflex and we had even more… Continue Reading Kevin...

Read More

Show 15 – Part 2: Getting to the bottom of Power Platform Licensing

Never let it be said that we turn down a challenge. We were asked by a listener to try and summarise Power Platform licensing and rather than just share what we knew, we managed to bring in one of the Microsoft experts on the subject, the very tattoed and always entertaining Chris Huntingford. Then, by sheer chance, Microsoft decided to drop the bombshell news of Dataflex and we had even more… Continue Reading Kevin...

Read More
Discover all the private channels on Microsoft Teams
Jul05

Discover all the private channels on Microsoft Teams

Creating private channels is possible by default on your organisation and probably all organisation will have these types of the channel on Microsoft Teams. But from a governance perspective that can leave the user to create those without any criteria. So on this post, we will share a PowerShell script that will allow getting all the private channels on your organisation. This… Continue Reading David Ramalho’s Article on...

Read More
How to make Microsoft Graph request using PnP and Office 365 CLI
Jun14

How to make Microsoft Graph request using PnP and Office 365 CLI

Information Circuit Board Graphics Concept Microsoft Graph has a lot of commands that you can use to do some tasks. That will require you to manage and built the OAuth and from there make the request to Graph. But you can use the PnP PowerShell to perform this task. The commands will enable all of this and you don’t have to manage anything. The first step is to authenticate with the… Continue Reading David Ramalho’s...

Read More
The required Office 365 role to run PnP Powershell with Scopes
May31

The required Office 365 role to run PnP Powershell with Scopes

Authorized Allowance Permission Permit Approve Concept When installing using PnP PowerShell using the Scope connection, it’s required to connect with an account with some additional permissions and often, we just take the easy route, give or ask Global Admin. With that role, I will be able to do anything with the scopes, but in some organizations granting this type of permissions can take… Continue Reading David...

Read More

Show 11 – Part 1: News and front of mind

This week we have a special guest as Stephan Bisser, MVP for AI with a focus on Conversational AI, joins us to talk about Bots. Part 1 first though, the news as we pick up some of the latest updates following the Microsoft 365 Virtual Marathon and some Power Platform goodness. <!– –> If you would like to appear on the show, please drop us a line using the form at

Read More

Show 11 – Part 2: Here comes the robots

This week we have a special guest as Stephan Bisser, MVP for AI with a focus on Conversational AI, joins us to talk about Bots. We cover three key topics: Why/when would you use a Bot? How do you get started designing then building a Bot? What’s changed recently? Stephan’s post on updates from Build Adaptive Cards Management System Bot Framework Composer General Availability Updates to… Continue Reading Kevin McDonnell’s...

Read More

Show 10 – bonus edition: Microsoft Build 2020

A bonus show this week as Kevin (the Grey), Al (the Hat) and Garry (the beard) discuss the news and their views from Microsoft Build 2020. We cover the big announcements as well as a few interesting ones that may have missed your attention <!– –> General Build On-Demand Sessions Scott Hanselman’s Keynote Satya Nadella’s Keynote Easter Eggs Microsoft 365 News Microsoft Lists Cortex… Continue Reading Kevin...

Read More
Setup an alert when a file is edited on OneDrive
May17

Setup an alert when a file is edited on OneDrive

Photo by Scott Graham on Unsplash When you share the file from your One Drive with external users, often is to collaborate during the lifecycle of the document. There are some scenarios where you may want to know when that file is edited. So we have PowerAutomate where you can create a Flow to detect these changes. However, there are some tricks that you need to use in order to detect… Continue Reading David...

Read More
Schedule a Team conversation on Microsoft Teams
May04

Schedule a Team conversation on Microsoft Teams

With the increasing use of Microsoft Teams new scenarios are raised for the people and a couple of days ago I saw something about how can a user schedule a Team conversation. This option is not available out-of-the-box probably because you can have the app to install this on your phone and can easily create a post whenever is needed. However, there are some people that don’t have any… Continue Reading David Ramalho’s...

Read More

Show 9 – Part 1: News and front of mind

I like that but can it look a bit less like SharePoint? Have you ever heard that said by someone? You might even have agreed. We talk about how true that thought is and if it needs to be done, what are the best ways to do it if you really do have to. This week we also have a special guest joining us so big thanks to Matt Weston for giving us his time and thoughts on SharePoint. Also this week,… Continue Reading Kevin...

Read More

Show 9 – Part 2: I like that but can it look a bit less like SharePoint?

I like that but can it look a bit less like SharePoint? Have you ever heard that said by someone? You might even have agreed. We talk about how true that thought is and if it needs to be done, what are the best ways to do it if you really do have to. This week we also have a special guest joining us so big thanks to Matt Weston for giving us his time and thoughts on SharePoint. Also this week,… Continue Reading Kevin...

Read More
Get notified by email when a news post is created on a SharePoint site
Apr26

Get notified by email when a news post is created on a SharePoint site

Photo by Bram Naus on Unsplash If you looking for publishing news content to your organization quickly and with perhaps looking to SharePoint News should be the way to go. You’ll have access to multiple tools and get for example content displayed from multiple sites. If you have the SharePoint App on your phone, you’ll be notified once something new is published. However, there are some… Continue...

Read More
Notify your Team when a news post is published on SharePoint site
Apr19

Notify your Team when a news post is published on SharePoint site

When a user creates a News Post on a SharePoint site there are a couple of options out-of-box that will send some notifications. However, if an user accesses the Microsoft Teams, for example, he will never know something as been added to the site. So the option shown on this blog post is the most easy and fastest way to get information to Microsoft Teams. This option has some… Continue Reading David Ramalho’s Article on...

Read More

Show 8 – Part 2: How you work and staying focused

How is the world of remote working treating you? Are you able to work well and focus? This week we chat about how to track your work effectively with Microsoft 365 and some techniques for staying focused. How you work and staying focused We kept it to general chit chat this time but covered topics like: Tracking work and prioritising Sticking to one thing Keeping focused with music and… Continue Reading Kevin McDonnell’s...

Read More
How to export a table from Excel to SharePoint list
Apr12

How to export a table from Excel to SharePoint list

A couple of days ago someone asked about how they can create a SharePoint list from an Excel file. There are a couple of methods available to perform this task but on this blog post, I will do the easiest way on my opinion to make this to happen. The required action to be able to export the Excel file to a SharePoint list is to create a table from your Excel file. After that, you… Continue Reading David Ramalho’s Article...

Read More

Show 8 – Part 1: News and front of mind

How is the world of remote working treating you? Are you able to work well and focus? This week we chat about how to track your work effectively with Microsoft 365 and some techniques for staying focused. Part 1 focuses on the news and what we’ve been up to. If you would like to appear on the show, please drop us a line using the form at https://www.greyhatbeard.com/upcoming-shows. We’d… Continue Reading Kevin McDonnell’s...

Read More

Show 7 – Part 1: News and front of mind

Is governance a dirty word to you? Let us persuade you otherwise as we talk about the importance of governance with the Power Platform, sharing why you should do it, how best to do it and when to do it. Part 1 focuses on the news and what we’ve been up to. If you would like to appear on the show, please drop us a line using the form at https://www.greyhatbeard.com/upcoming-shows. We’d… Continue Reading Kevin McDonnell’s...

Read More

Show 7 – Part 2: Governance and the Power Platform

Is governance a dirty word to you? Let us persuade you otherwise as we talk about the importance of governance with the Power Platform, sharing why you should do it, how best to do it and when to do it. Governance and the Power Platform Three topics: What do we mean by governance? – what it is and why you should do it What can you do for the Power Platform? – using the tools and an intro to… Continue Reading Kevin...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.