2 ways to duplicate SharePoint Lists to support your Power Apps

Recently I’ve been asked quite a few times to duplicate SharePoint lists as part of creating a Development, Test and production environment in Power Apps. PnP PowerShell Whatever you want to do to SharePoint, PnP PowerShell is often the quick way of doing things. Especially if you want to undertake the same thing. One of […] Continue Reading Pieter Veenstra’s Article on their blog 2 ways to duplicate SharePoint Lists...

Read More

Update a Hyperlink Column in SharePoint with Power Automate

Today, I was asked about how to create a lookup to a document or item in a SharePoint form. Sometimes a slightly different solution, using a Hyperlink field can do the trick. Lookups in SharePoint So I created a lookup column and then in the SharePoint Details form. This would look like this: Not too […] Continue Reading Pieter Veenstra’s Article on their blog Update a Hyperlink Column in SharePoint with Power Automate...

Read More

429 Errors reported by the trigger in your flow in Power Automate

This morning I was asked about 429 Errors in flows, But rather than 429 errors in actions, this time it was about 429 errors in triggers of a flow. 429 Errors 429 is the number that represents errors due to systems being too busy. In Power Automate you could for example have a flow that […] Continue Reading Pieter Veenstra’s Article on their blog 429 Errors reported by the trigger in your flow in Power Automate This...

Read More
Handle multiple N:N records associate and disassociate requests with JavaScript and Power Pages Web API
Mar13

Handle multiple N:N records associate and disassociate requests with JavaScript and Power Pages Web API

In my previous posts Creating and removing N:N relationship between Dataverse records using Javascript and Power Pages Web API I showed how we can leverage the Power Pages Web API to handle single N:N associate and disassociate requests for a custom N:N relationship between Accounts and Contacts, and also in the following post Generic JavaScript Functions to Associate and Disassociate Dataverse records using the Power Pages Web API, I...

Read More

Dataflow timeouts in Power Apps

Last week one of my clients had an issue with timeouts in their dataflows in Power Apps. It had worked for a while, but then suddenly the dataflow was experiencing timeouts. Dataflow query timeout issues In my case I found that my dataflows would fail in different ways. But Mainly I would get back the […] Continue Reading Pieter Veenstra’s Article on their blog Dataflow timeouts in Power Apps Last week one of my clients...

Read More

Synchronise Microsoft Shifts with Outlook Calendars in Power Automate the 2024 way

I’ve been planning to rewrite my Synchronise Microsoft Shifts with Outlook Calendars in Power Automate post for quite a while. This post will give you the new and more efficient way of implementing a synchronisation process between Shifts and Outlook. Setup of Microsoft Shifts In Microsoft Teams I’ve added the Shifts app and I’ve added […] Continue Reading Pieter Veenstra’s Article on their blog...

Read More

Show mobile device notification area in Power Apps

When you develop apps for mobile devices, you might want to have a look into the option to show the mobile device notification area. Show mobile device notification area setting Within the Display Settings of your app settings in Power Apps, there is a setting available to make the mobile device notification settings visible. By […] Continue Reading Pieter Veenstra’s Article on their blog Show mobile device notification...

Read More

Relationships in Dataverse managed with Power Automate

In Dataverse you can create relationships between tables, but how do you manage the relationships from a flow in Power Automate? Relationships in Dataverse In Dataverse there are a number of different type of relationships that you can create. Relationship examples Consider the following tables: Many-to-one relationships If we created a relationship between the car […] Continue Reading Pieter Veenstra’s Article on their...

Read More

The good and the bad of using Copilot in the Power Platform

Copilot is everywhere within Microsoft technology nowadays. But it is really helping or is it just a step in the wrong direction. In this post the good and the bad of using Copilot. Copilot in Power Platform Within the Power Platform there are Copilots all over the place. In this post I will focus on […] Continue Reading Pieter Veenstra’s Article on their blog The good and the bad of using Copilot in the Power Platform...

Read More

New awesome feature in Power Apps! How to Run SQL Server stored procedures without Power Automate in 2024

Recently Microsoft released a new feature in Power Apps that will let you call SQL Stored procedures without needing to call a flow in Power Automate What are SQL Server Stored Procedures? A Stored Procedure is nothing more than a piece of code that will do something within your database. Well that is a great […] Continue Reading Pieter Veenstra’s Article on their blog Run SQL Server Stored Procedures in Power Apps: New...

Read More
Welsh Azure User Group February 2024 Meet Up!
Feb22

Welsh Azure User Group February 2024 Meet Up!

It was the day of our Welsh Azure User Group #WAUG February 2024 meet up and we had yet another two amazing speakers join us. We were joined by Tiago Costa and how the lack of Azure Governance is Disturbing, a candid no holds barred look at all the tools and utilities we should be … Continue reading Welsh Azure User Group February 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User Group...

Read More
Generic JavaScript Functions to Associate and Disassociate Dataverse records using the Power Pages Web API
Feb17

Generic JavaScript Functions to Associate and Disassociate Dataverse records using the Power Pages Web API

In my previous post Creating and removing N:N relationship between Dataverse records using Javascript and Power Pages Web API I showed how we can leverage the Power Pages Web API to handle single N:N associate and disassociate requests for a custom N:N relationship between Accounts and Contacts. In case we want to extend that to be more generic to any N:N relationship we can leverage a custom function that can be used in multiple...

Read More

Do you have multiple developers working on 1 flow in Power Automate?

This post is all about some issues that I ran into yesterday. Multiple developers worked on one flow in Power Automate and my app in Power Apps broke. When apps break due to multiple developers working on a flow! It is not uncommon to remove a flow and then readd a flow in your app, when […] Continue Reading Pieter Veenstra’s Article on their blog Do you have multiple developers working on 1 flow in Power Automate? This...

Read More

4, 5 or 7 syntaxes for the Patch function in Power Apps

Did you know that there are 5 different syntaxes for the patch function? Or are there 7, or maybe just 4. In this post all about the various syntaxes for the Patch function. The 5 syntaxes for the Patch function The Patch function is most of the times used to create or update a record […] Continue Reading Pieter Veenstra’s Article on their blog 4, 5 or 7 syntaxes for the Patch function in Power Apps Did you know that there...

Read More

Process AI Builder data using xpath in Power Automate

Today I was asked to have a look at the dynamic data that is generated by AI builder and make it easier to process AI Builder data. AI Builder data AI Builder is frequently used for scraping data of documents, like Invoices or Purchase Orders. When you create a model in AI Builder, Power Automate […] Continue Reading Pieter Veenstra’s Article on their blog Process AI Builder data using xpath in Power Automate Today I was...

Read More

Excel Filter Query in List Rows Present in a Table Action in Power Automate

Filter queries are important when you work with SharePoint Get Items actions or Dataverse Get Rows, but how about the Excel Filter Query setting? Get rows present in a Table The Get rows present in Table also has the Excel Filter Query setting. In the above mentioned posts I’ve gone through all the options available […] Continue Reading Pieter Veenstra’s Article on their blog Excel Filter Query in List Rows Present...

Read More

When to create child flows in Power Automate?

When you use solutions (and you always should use solutions!) there is the option to run Child flows. But when should you create a child flow? What is a Child Flow? A Child flow is a flow that can be started from another flow. Potentially taking parameters and potentially returning data back to the flow […] Continue Reading Pieter Veenstra’s Article on their blog When to create child flows in Power Automate? When you use...

Read More

Check permissions like a Pro Low Coder

When you develop an app using Dataverse, you might have a button to update data in Dataverse. How do you check permissions before Power Apps tells you that the Patch function has failed? Updating data Using the Patch function we can update or create a record in Dataverse or any other data source. To Create […] Continue Reading Pieter Veenstra’s Article on their blog Check permissions like a Pro Low Coder When you develop...

Read More

Help! My Dataverse flow does not trigger anymore!

Today suddenly my flow does not trigger anymore. My flow should trigger when a new account is created but suddenly it doesn’t trigger my flow anymore. First steps to debug the issue First of all I tried to rerun a previous flow run. This flow still ran without any issue. Then I clicked on the […] Continue Reading Pieter Veenstra’s Article on their blog Help! My Dataverse flow does not trigger anymore! Today suddenly...

Read More

Help! My Dataverse flow does not trigger anymore!

Today suddenly my flow does not trigger anymore. My flow should trigger when a new account is created but suddenly it doesn’t trigger my flow anymore. First steps to debug the issue First of all I tried to rerun a previous flow run. This flow still ran without any issue. Then I clicked on the […] Continue Reading Pieter Veenstra’s Article on their blog Help! My Dataverse flow does not trigger anymore! Today suddenly...

Read More
WorkplaceDudes Meetup #3
Feb09

WorkplaceDudes Meetup #3

Last February 8, 2024, we held our 3rd Meetup at NEXXT in Amersfoort. Thanks to Harm Veenstra for arranging the location and food. From 16:30 people started coming in. Not much later the lids of the food came off and we could all start eating from the available stamppot buffet. Rene Laas and Gerjon Kunst began the evening with a topic that is totally contemporary, namely Unlocking the… Continue Reading Jeroen Burgerhout’s...

Read More

When to create child flows in Power Automate?

When you use solutions (and you always should use solutions!) there is the option to run Child flows. But when should you create a child flow? What is a Child Flow? A Child flow is a flow that can be started from another flow. Potentially taking parameters and potentially returning data back to the flow […] Continue Reading Pieter Veenstra’s Article on their blog When to create child flows in Power Automate? When you use...

Read More

A new approach to error handling in Power Automate

For quite a few years now I’ve promoted the Try-Catch error handling pattern. But there is a new approach on its way. The Flow Run Table Within Dataverse you can now find the Flow Run table. The Flow Run table has a record for every run of a flow. This includes the status, trigger type, […] Continue Reading Pieter Veenstra’s Article on their blog A new approach to error handling in Power Automate For quite a few...

Read More

Power Platform First Aid sessions

Are you looking for help with your Power Platform. And you had enough of looking for help by searching on the internet? Power Platform First Aid ⛑️Join us in January 2024 for our “first aid” event focused on Power Platform. ⛑️ Have you got questions about the Power Platform?Is your flow not working? Does your […] Continue Reading Pieter Veenstra’s Article on their blog Power Platform First Aid sessions Are you...

Read More

System Updates in SharePoint from Power Automate using the ValidateUpdateListItem endpoint

Today I wanted to update Documents/Items without triggering other flows. The ValidateUpdateListItem endpoint in the REST API made this System Update possible. System Updates vs Updates Normally when an item is updated in SharePoint, flows that are triggering on the list my trigger. Sometimes however you might want to update the triggering list item with […] Continue Reading Pieter Veenstra’s Article on their blog System...

Read More

Do you have multiple developers working on 1 flow in Power Automate?

This post is all about some issues that I ran into yesterday. Multiple developers worked on one flow in Power Automate and my app in Power Apps broke. When apps break due to multiple developers working on a flow! It is not uncommon to remove a flow and then readd a flow in your app, when […] Continue Reading Pieter Veenstra’s Article on their blog Do you have multiple developers working on 1 flow in Power Automate? This...

Read More

Process AI Builder data using xpath in Power Automate

Today I was asked to have a look at the dynamic data that is generated by AI builder and make it easier to process AI Builder data. AI Builder data AI Builder is frequently used for scraping data of documents, like Invoices or Purchase Orders. When you create a model in AI Builder, Power Automate […] Continue Reading Pieter Veenstra’s Article on their blog Process AI Builder data using xpath in Power Automate Today I was...

Read More

Excel Filter Query in List Rows Present in a Table Action in Power Automate

Filter queries are important when you work with SharePoint Get Items actions or Dataverse Get Rows, but how about the Excel Filter Query setting? Get rows present in a Table The Get rows present in Table also has the Excel Filter Query setting. In the above mentioned posts I’ve gone through all the options available […] Continue Reading Pieter Veenstra’s Article on their blog Excel Filter Query in List Rows Present...

Read More

Excel Filter Query in List Rows Present in a Table Action in Power Automate

Understanding Filter Query settings in Power Automate actions is important when you work with SharePoint Get Items actions or Dataverse Get Rows, but how about the Excel Filter Query setting? Get rows present in a Table The Get rows present in Table also has the Excel Filter Query setting. In the above mentioned posts I’ve […] Continue Reading Pieter Veenstra’s Article on their blog Excel Filter Query in List Rows...

Read More
Creating and removing N:N relationship between Dataverse records using JavaScript and Power Pages  Web API
Feb04

Creating and removing N:N relationship between Dataverse records using JavaScript and Power Pages Web API

Managing Dataverse N:N relationships between records using the Power Pages Web API can be trickier as there are few samples around and the syntax differs a little bit from handling N:N relationships using the Dataverse Web API. In this post I will show a quick code sample on how you can handle that, using a sample N:N custom relationship between Contacts and Accounts. Prerequisites All required fields (including the N:N relationship...

Read More
Trigger a Cloud Flow when CSS webs file are modified in Power Pages (Standard Data Model)
Feb03

Trigger a Cloud Flow when CSS webs file are modified in Power Pages (Standard Data Model)

Sometimes when multiple developers work on the same Power Pages site using Power Platform CLI or changing WebFiles/WebTemplates via browser we might have update conflicts. One special case is when we have custom styles developed using SCSS and not pure CSS. We can have more than I developer working on separate partials and using Fiddler to test updates locally, but for the updates to take effect in the Power Pages site for other...

Read More
Welsh Azure User Group January 2024 Meet Up!
Jan17

Welsh Azure User Group January 2024 Meet Up!

It was the day of our Welsh Azure User Group #WAUG January 2024 meet up and we had yet another two amazing speakers join us. We were joined by Nikos Delis to discuss the Azure Service Bus and then we took a look at the AZ-305 Azure Architect Exam updates with Elkhan Yusubov. Huge thank … Continue reading Welsh Azure User Group January 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User...

Read More
Setting a SharePoint Date only field value to the current date using List Formatting JSON
Jan09

Setting a SharePoint Date only field value to the current date using List Formatting JSON

This post is based on a recent question that I got from a blog reader in a blog post related to List Formatting and setting field values: I am trying to add an action button to my Microsoft list. The reason for this is that I would like the trip date column to populate with the current date the button was pressed. Just to make it easier for the executives to confirm they have completed a work trip. Can this be done thru list and...

Read More
Edge profile sync not working
Jan08

Edge profile sync not working

Today there is a small blog post about the following problem. In addition to the fact that I am employed, I also have my own small company that provides Microsoft-related trainings. Nothing exciting. I have a Microsoft Learning Action Pack containing Office 365 E3 licenses and I bought the Entra ID P2 separately. In the Microsoft Edge browser, you have the option to log in with a work account… Continue Reading Jeroen...

Read More

System Updates in SharePoint from Power Automate using the ValidateUpdateListItem endpoint

Today I wanted to update Documents/Items without triggering other flows. The ValidateUpdateListItem endpoint in the REST API made this System Update possible. System Updates vs Updates Normally when an item is updated in SharePoint, flows that are triggering on the list my trigger. Sometimes however you might want to update the triggering list item with […] Continue Reading Pieter Veenstra’s Article on their blog System...

Read More

Power Platform First Aid sessions

Are you looking for help with your Power Platform. And you had enough of looking for help by searching on the internet? Power Platform First Aid ⛑️Join us in January 2024 for our “first aid” event focused on Power Platform. ⛑️ Have you got questions about the Power Platform?Is your flow not working? Does your […] Continue Reading Pieter Veenstra’s Article on their blog Power Platform First Aid sessions Are you...

Read More
Remove the Dev Home app with Intune
Jan04

Remove the Dev Home app with Intune

Today another short blog post about the removal of the Dev Home app, which comes with the new Windows 11 23H2 update. Dev Home…. What on earth should you use this app in an Enterprise environment? So, I created a remediation script that we can deploy to our Intune managed systems using Microsoft Intune. The remediation consists, as you probably know, of two PowerShell scripts, namely the… Continue Reading Jeroen...

Read More

A new approach to error handling in Power Automate

For quite a few years now I’ve promoted the Try-Catch error handling pattern. But there is a new approach on its way. The Flow Run Table Within Dataverse you can now find the Flow Run table. The Flow Run table has a record for every run of a flow. This includes the status, trigger type, […] Continue Reading Pieter Veenstra’s Article on their blog A new approach to error handling in Power Automate For quite a few...

Read More
My review of 2023
Jan03

My review of 2023

So…. 2023. That was 3 days ago. 2023 was a special year for me. In this blog post, I will mention all the highlights, on a personal level, community and website. Personal The highlight in this area is that I got to speak at Experts Live Australia. You can read the report of this further on. Earlier in 2023, I was nominated for Microsoft MVP. Unfortunately, I didn't become one. As a Microsoft… Continue Reading Jeroen...

Read More
Using JavaScript and Cloud Flows to download files from a SharePoint document library in Power Pages
Dec27

Using JavaScript and Cloud Flows to download files from a SharePoint document library in Power Pages

Even though we can now use Virtual Tables to expose SharePoint lists in a Power Pages site, the same does not apply to SharePoint Document libraries. You can use the native SharePoint integration to display content that was set up in that way from the Model Driven Apps side, but you cannot expose a custom library in that way. For example, if you want to expose a random library with Document templates for users to download, there is no...

Read More

Activate and Deactivate Features in SharePoint form Power Automate Flows

Enabling a SharePoint feature from a flow in Power Automate is easy, but how do you deactivate features? Activate a feature in SharePoint I’ve got a SharePoint site and I want to enable the Document ID Service feature. This is all simple. Using the above end point I can activate the feature. That GUID mentioned […] Continue Reading Pieter Veenstra’s Article on their blog Activate and Deactivate Features in SharePoint...

Read More

How to use Templates in SharePoint libraries

Microsoft introduced long-awaited templates for SharePoint libraries. It’s available for everyone so you can use it to jump-start the creation process. Is it good? What’s inside? What’s missing? Let’s check it out! Short introduction Templates for SharePoint libraries are there, finally! Simply, you can create a library using a predefined selection. This is the first […] Continue Reading Marcin Siewnicki’s Article on their...

Read More
Converting a certificate from .cert to .pfx to use with Power Pages OAuth2 implicit flow
Dec21

Converting a certificate from .cert to .pfx to use with Power Pages OAuth2 implicit flow

We know that in order to use OAuth2 implicit flow in Power Pages, we need to have a certificate in the proper format as specified by Microsoft here: Manage custom certificates As we can the Let’s Encrypt service to generate free SSL certificates, I was wondering if I could not use the same developing Power Pages integration POCs in my developer tenant. Those certificates actually meet the criteria but they are not immediately in...

Read More
Copilot for Microsoft 365 – The Ultimate Webinar with Stripe OLT – YouTube
Dec14

Copilot for Microsoft 365 – The Ultimate Webinar with Stripe OLT – YouTube

Copilot for Microsoft 365 – The Ultimate Webinar with Stripe OLT Our Copilot for M365 webinar offers a strategic overview of this new, innovative tool, showcasing how AI has the power to redefine productivity and creativity. During this webinar you will gain: An in-depth understanding of Copilot for M365 Tools: Explore the core functionalities and innovative features of Copilot, and how it integrates with existing Microsoft 365...

Read More
Welsh Azure User Group December 2023 Meet Up!
Dec14

Welsh Azure User Group December 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG December2023 meet up and we had yet another two amazing speakers join us. We were joined by Samuel Amaugo on to discuss Application Insights in a /NET application for Monitoring and Logging, as well as Steph Locke and Owain Osborne-Walsh on to discuss Azure … Continue reading Welsh Azure User Group December 2023 Meet Up! Continue Reading jonnychipz’s Article on their...

Read More

Auto height, Containers and flexible font sizes in Power Apps

It is important that each control on your screen fits and that nothing overlaps. Auto Height and Containers can help you be with flexible font sizes. Flexible font sizes Have you ever tried adjusting the default font size on your mobile or Windows device? Then when you try to use your app, text doesn’t fit […] Continue Reading Pieter Veenstra’s Article on their blog Auto height, Containers and flexible font sizes in...

Read More

Connect to Microsoft Graph using PowerShell with certificates

Earlier this week I fixed some PowerShell scripts that connected into Microsoft Graph using the Thumbnail of a certificate installed on my local system. Some of the challenges in this post. Connect-MGGraph Within the Microsoft.Graph.Authentication module the is the Connect-MGGraph cmdlet to connect to Microsoft Graph. One of the examples given within the documentation, shows […] Continue Reading Pieter Veenstra’s Article...

Read More

4 new undocumented functions to encode and decode Xml in Power Automate

Today, I found 4 new undocumented functions in Power Automate Why Encode Xml? First of all, why would we need to encode xml? Sometimes characters in the xml could cause problems when you use them in an actions. Encoding characters can then typically solve this issue. Typically you would treat the tags in xml differently […] Continue Reading Pieter Veenstra’s Article on their blog 4 new undocumented functions to encode and...

Read More

A scheduled flow that locks an app

Earlier this week I was asked on the chat how to handle scheduled flows that need to lock an app in Power Apps while the flow is running. Scheduled flows First of all it is important to realize that scheduled flows are not connected to the app in any kind of way. Therefore there isn’t […] Continue Reading Pieter Veenstra’s Article on their blog A scheduled flow that locks an app Earlier this week I was asked on the...

Read More

Managed Identities in Logic Apps to access Microsoft Graph

In this post I’m going through the steps to configure Logic apps to use Managed Identities to access SharePoint sites using Microsoft Graph. Managed Identities Within Logic Apps you will see Managed Identities popping up in various places. You can find them in Azure Runbooks within Azure Automation where they are often used to run […] Continue Reading Pieter Veenstra’s Article on their blog Managed Identities in...

Read More