2 Ways to insert dates into Excel using Power Automate

Today I looked at how to insert dates into Excel after a while back I tried to read dates from Excel Changes since my previous post In my previous Excel … Read More Continue Reading Pieter Veenstra’s Article on their blog 2 Ways to insert dates into Excel using Power Automate Today I looked at how to insert dates into Excel after a while back I tried to read dates from Excel In my previous Excel date post, I looked at the...

Read More

Sharing flows in Power Automate

Recently I tried to share a flow and I got trial warning. it took a while before i started to understand how Sharing flows in Power Automate works. The start … Read More Continue Reading Pieter Veenstra’s Article on their blog Sharing flows in Power Automate Recently I tried to share a flow and I got trial warning. it took a while before i started to understand how Sharing flows in Power Automate works. I created a flow...

Read More

There’s a problem that needs to be fixed in Power Automate

Have you ever had your flows showing the following error: There’s a problem that needs to be fixed to trigger this flow. To see more details open flow checker. Flow … Read More Continue Reading Pieter Veenstra’s Article on their blog There’s a problem that needs to be fixed in Power Automate Have you ever had your flows showing the following error: There’s a problem that needs to be fixed to trigger this...

Read More

Get started with child flows in Power Automate

Child Flows is one of the subjects that has been on my list of things to write about for quite a while. In this post the steps to get started … Read More Continue Reading Pieter Veenstra’s Article on their blog Get started with child flows in Power Automate Child Flows is one of the subjects that has been on my list of things to write about for quite a while. In this post the steps to get started with child flows. In this...

Read More

Implementing 2 levels of grouping in Power Apps

When you want to implement 2 levels of grouping in Power Apps you will discover quite soon that you can’t have more than 1 nested gallery. So how can we … Read More Continue Reading Pieter Veenstra’s Article on their blog Implementing 2 levels of grouping in Power Apps When you want to implement 2 levels of grouping in Power Apps you will discover quite soon that you can’t have more than 1 nested gallery. So...

Read More

Power Automate Approvals and Dataverse

Power Automate Approvals are often one of those unclear things that people try to avoid. Dataverse tables relevant to approvals Over the last week I was asked twice how to … Read More Continue Reading Pieter Veenstra’s Article on their blog Power Automate Approvals and Dataverse Power Automate Approvals are often one of those unclear things that people try to avoid. Over the last week I was asked twice how to collect...

Read More

Modern app designer vs Classic app Designer in Model Driven Apps

When you create a new Model Driven App today, you will find that you have an options between the Modern app designer and the Classic app designer. Existing model driven … Read More Continue Reading Pieter Veenstra’s Article on their blog Modern app designer vs Classic app Designer in Model Driven Apps When you create a new Model Driven App today, you will find that you have an options between the Modern app designer and...

Read More

Environment Variables in Power Apps

After yesterday’s post about environment variables in Power Automate, today it is time to look environment variables Power Apps. Environment Variables As I showed in yesterday’s post for the SPSite … Read More Continue Reading Pieter Veenstra’s Article on their blog Environment Variables in Power Apps After yesterday’s post about environment variables in Power Automate, today it is time to look...

Read More

Environment variables in Power Automate

When you create flows inside a solution you might have noticed these Environment Variables. What are they and what can you do with them? Environment Variables in dynamic content Recently … Read More Continue Reading Pieter Veenstra’s Article on their blog Environment variables in Power Automate When you create flows inside a solution you might have noticed these Environment Variables. What are they and what can you do with...

Read More

Power Automate flow or app code in Power apps?

Power Automate and Power Apps use the same connectors. So do you use a flow or app code? It can be an important choice. An example app I’m going to … Read More Continue Reading Pieter Veenstra’s Article on their blog Power Automate flow or app code in Power apps? Power Automate and Power Apps use the same connectors. So do you use a flow or app code? It can be an important choice. I’m going to use a simple app...

Read More

Create a Microsoft Teams team template

Recently I was asked about creating a team template in Microsoft Teams and apply this template using Power Automate as the team creation had to be automated. Education tenant As … Read More Continue Reading Pieter Veenstra’s Article on their blog Create a Microsoft Teams team template Recently I was asked about creating a team template in Microsoft Teams and apply this template using Power Automate as the team creation had...

Read More
Change a SharePoint content type using Power Automate
May02

Change a SharePoint content type using Power Automate

Photo by Javier Allegue Barros on Unsplash A few weeks ago, I need to change a content type from SharePoint into another one. There are a few alternatives to do either by using a custom solution, Power Automate and/or logic apps. The idea was when an item is created change the content type from x to y. To achieve this, you have 2 different options: When an item is created… Continue Reading David Ramalho’s Article on their...

Read More

Who is in the office tomorrow, using Power Automate?

Do you want to know who is in the office tomorrow or the day after? With some COVID restrictions still in place it can important to know who is in … Read More Continue Reading Pieter Veenstra’s Article on their blog Who is in the office tomorrow, using Power Automate? Do you want to know who is in the office tomorrow or the day after? With some COVID restrictions still in place it can important to know who is in the...

Read More

8 top reasons to use Dataverse or SharePoint lists in the Power Platform

Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium licences? Dataverse or SharePoint lists? Dataverse or SharePoint lists, that is the question. There are … Read More Continue Reading Pieter Veenstra’s Article on their blog 8 top reasons to use Dataverse or SharePoint lists in the Power Platform Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium...

Read More

Filter by calculated fields in SharePoint using Power Automate

When you read items from a SharePoint list and you want to filter by calculated fields in that list filter queries will fail. So how can you filter your items? … Read More Continue Reading Pieter Veenstra’s Article on their blog Filter by calculated fields in SharePoint using Power Automate When you read items from a SharePoint list and you want to filter by calculated fields in that list filter queries will fail. So how...

Read More

Expected String but got Null, when calling a flow from a Model Driven app

A few weeks ago I looked at calling flows from model driven apps. And for a while my flow worked as expected and then suddenly it broke with an “Expected … Read More Continue Reading Pieter Veenstra’s Article on their blog Expected String but got Null, when calling a flow from a Model Driven app A few weeks ago I looked at calling flows from model driven apps. And for a while my flow worked as expected and then...

Read More

Get all your broken connections using Power Automate

To get all your broken connections in the Power Platform can be a challenge. In this post I will use flow to collect the broken connections. Options to get broken … Read More Continue Reading Pieter Veenstra’s Article on their blog Get all your broken connections using Power Automate To get all your broken connections in the Power Platform can be a challenge. In this post I will use flow to collect the broken connections....

Read More

Customer Voice a.k.a. Forms Pro the database behind the magic

If you call Customer Voice still Forms Pro or not, have you ever looked into the Databases sitting behind Customer Voice? Forms vs Customer Voice In this post I will … Read More Continue Reading Pieter Veenstra’s Article on their blog Customer Voice a.k.a. Forms Pro the database behind the magic If you call Customer Voice still Forms Pro or not, have you ever looked into the Databases sitting behind Customer Voice? In this...

Read More

Many running flows in Power Automate

Recently I noticed that some of my flows end up with many running flows. Types of flows There are a few different types of flows Manual cloud flows Scheduled cloud … Read More Continue Reading Pieter Veenstra’s Article on their blog Many running flows in Power Automate Recently I noticed that some of my flows end up with many running flows. There are a few different types of flows Manual cloud flows Scheduled cloud flows...

Read More

Set yourself to Do Not Disturb using Power Automate Desktop

A while back I tried setting people to Do Not Disturb using Power Automate. In this post I will use Power Automate Desktop. Power Automate Desktop As there isn’t an … Read More Continue Reading Pieter Veenstra’s Article on their blog Set yourself to Do Not Disturb using Power Automate Desktop A while back I tried setting people to Do Not Disturb using Power Automate. In this post I will use Power Automate Desktop. As...

Read More

Filter SharePoint list items without a date in Power Automate

So you have a list and that list has a date field. Now you only want to get the items that have a date set and filter out the items … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/03/22/items-without-a-date-power-automate/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

SQL Server vs Azure SQL in Power Automate

So often I have said, it doesn’t matter where your data lives, but have you ever compared SQL Server with SQL in Azure when you use Power Automate? SQL Server … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/03/19/sql-server-vs-azure-sql-power-automate/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

Create Views in Microsoft Teams

Have you ever wondered how to organize your documents in a Microsoft Teams Channel just like views in SharePoint? Views in Microsoft Teams Recently I discovered Views in Microsoft Teams. … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/03/17/create-views-in-microsoft-teams/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

Create Dynamic Adaptive Cards in Teams using Power Automate

Recently I looked at the basics of Adaptive cards, but what if you want more dynamic adaptive cards in Teams that respond to user input? Adaptive Cards When you create … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/03/11/dynamic-adaptive-cards-power-automate/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

Call Microsoft Graph from an HTTP Action vs Custom Connector in Power Automate

Is there a difference between calling Microsoft Graph Endpoints using an HTTP action or creating a custom connector? In this post I will compare these two options. Microsoft Graph in … Read More Continue Reading Pieter Veenstra’s Article on their blog Call Microsoft Graph from an HTTP Action vs Custom Connector in Power Automate Is there a difference between calling Microsoft Graph Endpoints using an HTTP action or...

Read More

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