Calculate the Sum for a SharePoint column in Power Automate

Last week Shane Young asked me about calculating the Sum for a SharePoint column in Power Automate. In this post the super fast solution to calculating totals. Background When you … Read More Continue Reading Pieter Veenstra’s Article on their blog Calculate the Sum for a SharePoint column in Power Automate Last week Shane Young asked me about calculating the Sum for a SharePoint column in Power Automate. In this post the...

Read More
Send a message to Microsoft Teams using Microsoft Graph in SPFx
Feb28

Send a message to Microsoft Teams using Microsoft Graph in SPFx

A few days ago, I got a challenge that required me to send a message from a SharePoint page into a Microsoft Teams chat and that can be achieved using Microsoft Graph. I created a blank SPFx project and this post will go to the most important elements. You can also take a look at a sample webpart that I built using this process. First, you need to add to the package-solution.json… Continue Reading David Ramalho’s Article...

Read More

Object must implement IConvertible in Power Apps

In Power Apps when you do a Patch to create a new item or to update an existing item you migth have found the error Object must implement IConvertible Object … Read More Continue Reading Pieter Veenstra’s Article on their blog Object must implement IConvertible in Power Apps In Power Apps when you do a Patch to create a new item or to update an existing item you migth have found the error Object must implement IConvertible...

Read More

Get started with adaptive cards in Power Automate

Getting started with adaptive cards can be difficult. In this post i have written some guidelines to get you started. Adaptive cards You might have seen these cards in Microsoft … Read More Continue Reading Pieter Veenstra’s Article on their blog Get started with adaptive cards in Power Automate Getting started with adaptive cards can be difficult. In this post i have written some guidelines to get you started. You might...

Read More

Create PDF documents from data in Power Automate

In this post I will look at how to create PDF documents from data. Use cases In the example that I’m using in this post I will generate a quotation … Read More Continue Reading Pieter Veenstra’s Article on their blog Create PDF documents from data in Power Automate In this post I will look at how to create PDF documents from data. In the example that I’m using in this post I will generate a quotation document...

Read More

Unnest nested arrays in Power Automate

We all know this problem, you have a nested array in Power Automate but how do we unnest these arrays? It is not easy! Nested Arrays Nested arrays can appear … Read More Continue Reading Pieter Veenstra’s Article on their blog Unnest nested arrays in Power Automate We all know this problem, you have a nested array in Power Automate but how do we unnest these arrays? It is not easy! Nested arrays can appear in many places....

Read More
Create multiple SharePoint sites using CSV file
Feb07

Create multiple SharePoint sites using CSV file

In a few days ago, I have been asked me to create a couple of sites and I create a simple PowerShell script using PnP Framework. Creating these sites on the SharePoint administration centre can take a while since you can only create one at the same time. If you are using a script like this will allow you to do a bit more on that also allow you to run other settings that you want...

Read More

Advanced settings not loading in Power Platform

Yesterday one of my clients showed me an issues where the Advanced settings didn’t load. Advanced Settings loading problem When I selected the advanced settings the browser attempted to load … Read More Continue Reading Pieter Veenstra’s Article on their blog Advanced settings not loading in Power Platform Yesterday one of my clients showed me an issues where the Advanced settings didn’t load. When I selected...

Read More

Filter by Content Type using Get Items in Power Automate.

In a comment on my Filter Query on Get Items in the SharePoint connector post I was asked about how to filter by content type. Filter by content type This … read the filter-by-content-type-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Filter by Content Type using Get Items in Power Automate. In a comment on my Filter Query on Get Items in the SharePoint connector post I was asked about how to...

Read More

1 Better way to use Create Item in SharePoint with Power Automate

Have you been using the REST API instead of the create item action in Power Automate. Create Item in the SharePoint connector is now just as good! Using the REST … read the create-item-sharepoint-power-automate post Continue Reading Pieter Veenstra’s Article on their blog 1 Better way to use Create Item in SharePoint with Power Automate Have you been using the REST API instead of the create item action in Power Automate....

Read More
Formulating a Power  Platform Governance Strategy
Jan25

Formulating a Power Platform Governance Strategy

Microsoft’s Power Platform consisting of Power BI, Power Apps, Power Automate and Virtual Agents, is an intuitive set of tools that enable individuals with no experience of coding and programming to build apps and flows. The Power Platform is so easy to use, that anyone can start to generate reports, build apps, automate processes and even build chatbots. As a business, it’s important you understand the capabilities of...

Read More

Filter Query in SharePoint Get Items in Power Automate

Have you tried the experimental version of Filter query in the SharePoint Get Items action in Power automate yet? Filter Query in Get Items In this post I will look … read the filter-query-get-items-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Filter Query in SharePoint Get Items in Power Automate Have you tried the experimental version of Filter query in the SharePoint Get Items action in...

Read More
Manage your devices with Microsoft Endpoint Manager
Jan18

Manage your devices with Microsoft Endpoint Manager

Microsoft Endpoint Manager is a management and security service that is made up of from a number of existing products brought together to provide a new solution. Microsoft Endpoint Manager allows organisations to manage their data and devices securely in the cloud and on-premises. In this article we will introduce Microsoft Endpoint manager and discuss some of the main services it provides. What is Microsoft Endpoint Manager?...

Read More
Microsoft Teams vs Slack
Jan18

Microsoft Teams vs Slack

Facebook vs Snapchat, Android vs Apple, Microsoft vs Amazon – monumental business battles that have changed the way people communicate. Now we’re seeing the rise of another rivalry, this time in the collaboration software market, Microsoft Teams vs Slack.  In 2019, this market reached $9.5 billion globally, and with the onset of the Covid-19...

Read More

3 Ways to add a column to an array in Power Automate

When you have an array in Power Automate and you would like to add a column, you have 3 ways of doing this. Arrays in Power Automate In some of … read the add-a-column-to-an-array-power-automate post Continue Reading Pieter Veenstra’s Article on their blog 3 Ways to add a column to an array in Power Automate When you have an array in Power Automate and you would like to add a column, you have 3 ways of doing this. In some...

Read More

Patch any field type in a SharePoint list item using Power Apps

In Power Apps the Patch function is very important when you work with data. In this post it’s all about how to update any field type in SharePoint lists. Field … read the patch-field-type-sharepoint-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Patch any field type in a SharePoint list item using Power Apps In Power Apps the Patch function is very important when you work with data. In this...

Read More
Take control of files created on SharePoint that are not published
Jan10

Take control of files created on SharePoint that are not published

Did you know that if you’re a SharePoint Site collection owner you cannot see all the pages created? A few days ago, I notice that I should have a certain number of pages on the Site Pages library (80 or something) but only a few appear for my user. You can verify how many files you have on the particular library on the Site contents of your site. This happens because the page was… Continue Reading David Ramalho’s...

Read More

Call flows from a model driven app

Wouldn’t it be great if you could call flows from a model driven app? Well you can , but it is not without its difficulties. Some background It is easy … read the call-flows-from-a-model-driven-app post Continue Reading Pieter Veenstra’s Article on their blog Call flows from a model driven app Wouldn’t it be great if you could call flows from a model driven app? Well you can , but it is not without its...

Read More

Variables or Compose? Consider neither in Power Automate

The question is Variables or Compose actions in Power Automate? Variables Sometimes you need a place to put things. To explain the idea of variables I often use the idea … read the variables-or-compose-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Variables or Compose? Consider neither in Power Automate The question is Variables or Compose actions in Power Automate? Sometimes you need a place...

Read More

Your 1st lesson in Power Apps, in a few easy steps!

1st lessons can be so important when you want to get started with Power apps. 1st steps in Power Apps – Login Earlier this week I was contacted on the … read the your-1st-lesson-in-power-apps post Continue Reading Pieter Veenstra’s Article on their blog Your 1st lesson in Power Apps, in a few easy steps! 1st lessons can be so important when you want to get started with Power apps. Earlier this week I was contacted on...

Read More

Create new tabs in your Teams in Microsoft Teams using Power Automate

Have you ever tried adding new tabs in your teams in Microsoft Teams? When you do this with Power Automate you might need to have a look at Microsoft Graph. … read the new-tabs-microsoft-teams-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Create new tabs in your Teams in Microsoft Teams using Power Automate Have you ever tried adding new tabs in your teams in Microsoft Teams? When you do this...

Read More

Who can create new environments in the Power Platform

It is important to create multiple environment when you use the Power Platform, but how do you control who can create new environments? Environments There can be multiple reasons for … read the create-new-environments-power-platform post Continue Reading Pieter Veenstra’s Article on their blog Who can create new environments in the Power Platform It is important to create multiple environment when you use the Power...

Read More
How to enable/disable the comments on SharePoint Lists
Dec13

How to enable/disable the comments on SharePoint Lists

One of the recent updated for Microsoft Lists / SharePoint List Online was the possibility to comment on each item of a list that allows you to interact with other users for that particular item. This is a great feature which will be helpful to many organization and will help users to extend their collaboration. However, it’s possible that some organization may want to disable or enable… Continue Reading David...

Read More

How to handle leavers in Power Automate

Nobody likes it when people leave your organisation, but apart from the emotional part of this. What do you do when leavers own flows in Power Automate? Flow Owners Last … read the how-to-handle-leavers-in-power-automate post Continue Reading Pieter Veenstra’s Article on their blog How to handle leavers in Power Automate Nobody likes it when people leave your organisation, but apart from the emotional part of this. What do...

Read More

How to embed a canvas app in your model driven app

Do you want to create a button in the forms in your model driven app? You could embed a Canvas App in your model driven app to do this. Create … read the embed-a-canvas-app-model-driven-app post Continue Reading Pieter Veenstra’s Article on their blog How to embed a canvas app in your model driven app Do you want to create a button in the forms in your model driven app? You could embed a Canvas App in your model driven app...

Read More

Automatically re-enable flows that were suspended in Power Automate

Do you want to re-enable flows that were suspended automatically? Have you noticed that flows that aren’t running are automatically switched off? Switched off flows This can be very annoying! … read the re-enable-flows-power-automate post Continue Reading Pieter Veenstra’s Article on their blog Automatically re-enable flows that were suspended in Power Automate Do you want to re-enable flows that were suspended...

Read More

The target in the Launch function in Power Apps

The Launch function in Power Apps helps you to open links in your browser from your app. Launch Function The launch function has had a few additional options added recently, … read the launchtarget-launch-function-power-apps post Continue Reading Pieter Veenstra’s Article on their blog The target in the Launch function in Power Apps The Launch function in Power Apps helps you to open links in your browser from your app....

Read More

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

Show 21 – Part 1: News and front of mind

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. First though, the news as we cover the latest Teams usage numbers, updates to Power Apps and more. News

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

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.