Power Pages and Cloud Flows – Validate user against Dataverse records based on Contact ID
Apr13

Power Pages and Cloud Flows – Validate user against Dataverse records based on Contact ID

When we use the Cloud Flows integration in Power Pages, we can use Web Roles to restrict what users can call the Flow or not. But sometimes only this is not enough and we might want to add more logic in the Flow to prevent certain actions. For instance, you can validate the Contact ID against Dataverse records to ensure the user has the right to execute certain actions. Check out how you can do it. Contact ID in the Trigger Every...

Read More
Download SharePoint library files in Power Pages with JavaScript and Cloud flows – Improved code using jQuery & option to open PDF file in a new tab
Apr06

Download SharePoint library files in Power Pages with JavaScript and Cloud flows – Improved code using jQuery & option to open PDF file in a new tab

Last week I demoed an improved solution of my previous blog post: Using JavaScript and Cloud Flows to download files from a SharePoint document library in Power Pages in the Microsoft 365 & Power Platform community (PnP) call. The Cloud flows are the same as on the previous post, but on the JavaScript side there were a few updates: Using jQuery instead of Vanilla JsAdded more comments to the codeAdded option to preview PDF files...

Read More
Renewing the Apple Push Notification Service certificate
Apr04

Renewing the Apple Push Notification Service certificate

👋 Today a blog post about renewing the Apple Push Notification Service certificate in Microsoft Intune. I have had an Apple Business Manager account for a long time and have renewed the certificate a few times. But what struck me this week, for the first time, is that there is also an email sent from Apple saying that the certificate is about to expire. Figure 01 – APNS expiration email In… Continue Reading Jeroen...

Read More

The new Microsoft Lists form Experience

The new Microsoft Lists form experience has just been released! Need a tool for collecting information from users inside your organization – that’s the tool for you. In the post, I will go through its main features and options. Let’s go. New forms experience There are 2 types of forms in Microsoft Lists – default […] Continue Reading Marcin Siewnicki’s Article on their blog The new Microsoft Lists form Experience The...

Read More
Defender for Business – Endpoint Detection & Response (EDR) Demo – YouTube
Apr03

Defender for Business – Endpoint Detection & Response (EDR) Demo – YouTube

Defender for Business – Endpoint Detection & Response (EDR) Demo Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key EDR capabilities using this essential, security toolset. Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key EDR...

Read More
Defender for Business – Automated Investigation Demo – YouTube
Apr03

Defender for Business – Automated Investigation Demo – YouTube

Defender for Business – Automated Investigation Demo Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates automated investigation capabilities using this essential, security toolset. Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates automated...

Read More
Defender for Business – Attack Surface Reduction Demo – YouTube
Apr03

Defender for Business – Attack Surface Reduction Demo – YouTube

Defender for Business – Attack Surface Reduction Demo Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key attack surface capabilities using this essential, security toolset. Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key attack surface...

Read More
Defender for Business – Vulnerability Management Demo – YouTube
Apr03

Defender for Business – Vulnerability Management Demo – YouTube

Defender for Business – Vulnerability Management Demo Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key vulnerability management capabilities within this essential, security toolset. Want to know more about the capabilities of Microsoft Defender for Business? In this walk-through, our Stripe OLT, SOC Team Lead demonstrates key...

Read More

Receive the available storage within your SharePoint Online tenant

Within the SharePoint admin centre there is that little detail telling you how much storage you have available out of your total storage. But how do you get that without visiting the SharePoint Admin Centre every day? Retrieve the available storage using PowerShell The PowerShell script to get the storage is actually really simple: This […] Continue Reading Pieter Veenstra’s Article on their blog Receive the available...

Read More
Microsoft Defender for Business – A Stripe OLT Security Essentials Webinar – YouTube
Mar25

Microsoft Defender for Business – A Stripe OLT Security Essentials Webinar – YouTube

Microsoft Defender for Business – A Stripe OLT Security Essentials Webinar Imagine elevating your business’s cyber security from basic to unbeatable in just one hour. That’s what our exclusive webinar on Microsoft Defender for Business promises—and delivers. As SMEs stand on the frontline of cyber threats, this isn’t just an upgrade; this toolset is a necessity to safeguard your organisation’s future. For Businesses with up to...

Read More
Welsh Azure User Group March 2024 Meet Up!
Mar20

Welsh Azure User Group March 2024 Meet Up!

It was the day of our Welsh Azure User Group #WAUG March 2024 meet up and we had yet another two amazing speakers join us. We were joined by Rolf Schutten where we discussed AKS and Azure Draft and the superb Ryan Yates to talk about making Azure Operational Management a Breeze. We also welcomed … Continue reading Welsh Azure User Group March 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...

Read More

Options for Documenting Your Power Apps: Comments, Code, and Controls

Within Power Apps there are various ways to document your app. In this post I’m looking at comments in Power Apps Options to documenting your code in Power Apps As part of my day job at Vantage 365 I do a lot of health checks of apps and flows. This often means that I’m looking […] Continue Reading Pieter Veenstra’s Article on their blog Options for Documenting Your Power Apps: Comments, Code, and Controls...

Read More

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