Become part of your presentation with Presenter Modes in Microsoft Teams

When you present in Microsoft Teams and you share your screen you might not be visible. Presenter modes make it easier to interact with your audience. Presenter modes When you … Read More Continue Reading Pieter Veenstra’s Article on their blog Become part of your presentation with Presenter Modes in Microsoft Teams When you present in Microsoft Teams and you share your screen you might not be visible. Presenter modes make...

Read More
Custom View Formatting on Microsoft Lists to show Announcements
Dec01

Custom View Formatting on Microsoft Lists to show Announcements

Announcements are a big part of a SharePoint landing page and there are a few options out there either using out-of-the-box webpart or you can build an SPFx webpart. A few days ago, I was looking for an example using List formatting and I couldn’t find it on the community repo. Therefore I decided to create this sample which should be available soon on the community Git Hub of List… Continue Reading David Ramalho’s Article...

Read More

Get the current environment of an app in Power Apps

Today I tried to display the current environment in a canvas app in Power Apps. This was slightly harder than expected. Power Platform connectors there are quite a few Power … Read More Continue Reading Pieter Veenstra’s Article on their blog Get the current environment of an app in Power Apps Today I tried to display the current environment in a canvas app in Power Apps. This was slightly harder than expected. there are...

Read More

Containers in responsive apps in Power Apps

When you develop responsive apps in containers become very important. In this post I’m trying to help with the common challenges. Horizontal vs Vertical containers A while back I wrote … Read More Continue Reading Pieter Veenstra’s Article on their blog Containers in responsive apps in Power Apps When you develop responsive apps in containers become very important. In this post I’m trying to help with the...

Read More

Create recursive flows in Power Automate

With the introduction of child flow, have you tried creating recursive flows? Recursive flows Before looking into how to implement recursive flows, please review my child flow error handling post. … Read More Continue Reading Pieter Veenstra’s Article on their blog Create recursive flows in Power Automate With the introduction of child flow, have you tried creating recursive flows? Before looking into how to implement...

Read More
How to enable your Microsoft Viva Connections Dashboard
Nov11

How to enable your Microsoft Viva Connections Dashboard

Microsoft Viva Connection enables the users to have quick access to data and information using Microsoft Teams and with that increase the communication across your company. As you can imagine Teams relies on SharePoint to provide such experience and in order to activate this functionality you need to set up a couple of settings in SharePoint. To do this you need to set up on your… Continue Reading David...

Read More

Error handling in child flows in Power Automate

In the past I’ve looked at error handling for flows and this resulted in the Try-Catch pattern. In this post I will focus on error handling in Child flows. Parent … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/11/10/error-handling-in-child-flows-power-automate/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

The making of: A successful Microsoft Ignite table talk

A couple of months ago Anna Chu asked me to co-host a table talk at Microsoft Ignite about best practices within the Power Platform. The team Together with Karoliiona Kettukari … Read More Continue Reading Pieter Veenstra’s Article on their blog The making of: A successful Microsoft Ignite table talk A couple of months ago Anna Chu asked me to co-host a table talk at Microsoft Ignite about best practices within the Power...

Read More

Comments in Power Automate flows

As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate Notes vs Comments We already had the … Read More Continue Reading Pieter Veenstra’s Article on their blog Comments in Power Automate flows As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate We already had the option to...

Read More

SharePoint Site Scripts and Site Designs in Power Automate

When you look at SharePoint site provisioning solutions, you will quite quickly bump into Site Scripts and Site Designs. In this post some options on handling these in Power Automate … Read More Continue Reading Pieter Veenstra’s Article on their blog SharePoint Site Scripts and Site Designs in Power Automate When you look at SharePoint site provisioning solutions, you will quite quickly bump into Site Scripts and Site...

Read More

Using Dataverse views to simplify filter queries in Canvas Apps in Power Apps

Do you find that your queries in filters become complicated? In this post a way to simplify your queries using Dataverse views. Simplifying queries When you develop more complicated apps … Read More Continue Reading Pieter Veenstra’s Article on their blog Using Dataverse views to simplify filter queries in Canvas Apps in Power Apps Do you find that your queries in filters become complicated? In this post a way to simplify...

Read More

7 reasons to use child flows in Power Automate

When you develop your flows inside solutions you have the option to use child flows. But are they worth it? The 7 Reasons to use child flows I’m sure that … Read More Continue Reading Pieter Veenstra’s Article on their blog 7 reasons to use child flows in Power Automate When you develop your flows inside solutions you have the option to use child flows. But are they worth it? I’m sure that there are more...

Read More

Get into Space with Power Automate and the EONET by NASA connector

Have you tried the EONET by NASA or also known as Earth Observatory Natural Event Tracker connector in Power Automate yet? First steps into space Visit the NASA API site … Read More Continue Reading Pieter Veenstra’s Article on their blog Get into Space with Power Automate and the EONET by NASA connector Have you tried the EONET by NASA or also known as Earth Observatory Natural Event Tracker connector in Power Automate...

Read More

Calculate travel distance using Power Automate

When you have an app that has a current location and a destination postcode and you want to calculate travel distances, you could use Power Automate. Bing Maps To use … Read More Continue Reading Pieter Veenstra’s Article on their blog Calculate travel distance using Power Automate When you have an app that has a current location and a destination postcode and you want to calculate travel distances, you could use Power...

Read More

1 Top tip! Make your compose actions self documenting in Power Automate

Very often I hear flow people telling others that we should use Compose actions instead of variables. But when you reference a compose action it just shows “Outputs”. The Compose … Read More Continue Reading Pieter Veenstra’s Article on their blog 1 Top tip! Make your compose actions self documenting in Power Automate Very often I hear flow people telling others that we should use Compose actions instead of...

Read More

Error when you turn on solution based flows in Power Automate

Today I tried to import a solution with a few flows in a solution. The error After I imported the solution and then tried to turn on the flow, I … Read More Continue Reading Pieter Veenstra’s Article on their blog Error when you turn on solution based flows in Power Automate Today I tried to import a solution with a few flows in a solution. After I imported the solution and then tried to turn on the flow, I was presented...

Read More
Enhance Microsoft Teams with App Templates
Sep16

Enhance Microsoft Teams with App Templates

As one of the most widely used apps in Office 365, Microsoft Teams is an amazing tool for business. It boosts team communication with chats and meetings and can dramatically improve workflow with file-sharing and collaborative editing, and it’s only getting better.  In a previous article we discuss the enhanced integration between the Power Platform and...

Read More

The Weekday and Calendar functions in Power Apps

The weekday function in Power Apps gives us a numbers between 1 and 7 while the Calendar function can give you an array Sunday – Saturday. Calendar functions I will … Read More Continue Reading Pieter Veenstra’s Article on their blog The Weekday and Calendar functions in Power Apps The weekday function in Power Apps gives us a numbers between 1 and 7 while the Calendar function can give you an array Sunday –...

Read More

Responsive designs in Power Apps, the basics

When you want to leave it up to the user what device they use, responsive designs in Power Apps becomes important. Responsive design patterns I will start this post by … Read More Continue Reading Pieter Veenstra’s Article on their blog Responsive designs in Power Apps, the basics When you want to leave it up to the user what device they use, responsive designs in Power Apps becomes important. I will start this post by...

Read More

Format numbers locally to your user in Power Apps

A while back I wrote about formatting numbers in Power Automate. Today a quick post about how to format numbers in Power Apps. Format numbers Before you start to format … Read More Continue Reading Pieter Veenstra’s Article on their blog Format numbers locally to your user in Power Apps A while back I wrote about formatting numbers in Power Automate. Today a quick post about how to format numbers in Power Apps. Before you...

Read More

Request to XRM API failed with error,The flow is missing a connection for api ‘‘

Today when i tried to save my flow I got the following error message Request to XRM API failed with error. What to do when you get this error? Request … Read More Continue Reading Pieter Veenstra’s Article on their blog Request to XRM API failed with error,The flow is missing a connection for api ” Today when i tried to save my flow I got the following error message Request to XRM API failed with error. What to do...

Read More

Migrating file shares with SharePoint Migration manager

A while back I wrote about the SharePoint Migration Tool. Today I will share my experiences of the SharePoint Migration Manager. Why SharePoint Migration Manager? SharePoint Migration Manager is almost … Read More Continue Reading Pieter Veenstra’s Article on their blog Migrating file shares with SharePoint Migration manager A while back I wrote about the SharePoint Migration Tool. Today I will share my experiences of the...

Read More

Step 1 in Application Lifecycle Management and the Power Platform

As you take software development more seriously, Application Lifecycle Management (ALM) becomes more important. Application Lifecycle Management Application Lifecycle Management isn’t something that stands on its own. After years of … Read More Continue Reading Pieter Veenstra’s Article on their blog Step 1 in Application Lifecycle Management and the Power Platform As you take software development more seriously,...

Read More

Get the local trigger time in Power Automate

What’s the time a flow was triggered locally to the user who triggered a flow? How do we get the local trigger time? Standard Time When you create a flow … Read More Continue Reading Pieter Veenstra’s Article on their blog Get the local trigger time in Power Automate What’s the time a flow was triggered locally to the user who triggered a flow? How do we get the local trigger time? When you create a flow that...

Read More

Using PnP PowerShell with Azure Automation Accounts

In the past I often used Azure Functions to run PnP PowerShell from my flows in Power Automate, but there is a good alternative, Azure Automation Accounts. Azure Automation Accounts … Read More Continue Reading Pieter Veenstra’s Article on their blog Using PnP PowerShell with Azure Automation Accounts In the past I often used Azure Functions to run PnP PowerShell from my flows in Power Automate, but there is a good...

Read More

How to export and import solutions using flows in Power Automate

Have you ever wanted to export and import solutions using a flow? In this post all you need to know to get started. Perform an unbound action First I want … Read More Continue Reading Pieter Veenstra’s Article on their blog How to export and import solutions using flows in Power Automate Have you ever wanted to export and import solutions using a flow? In this post all you need to know to get started. First I want to have...

Read More

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