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

Replace Edit with Contribute permissions with SharePoint Site Templates

How do we replace Edit with contribute permissions? When you create a new team site members will have Edit permissions, but often we only want members to have Contribute permissions. Edit vs Contribute permissions When we look at the various permission levels in SharePoint, we can see the different between Edit and Contribute permissions within […] Continue Reading Pieter Veenstra’s Article on their blog Replace Edit with...

Read More

Paginated REST API calls in Power BI

Last week I was asked about handling paginated REST API calls in Power BI. The REST API end point would only return 200 records while a lot more records should be returned. Example Paginated REST API calls In this case we were using the signinapp found at signinapp.com and looking at the API documentation we […] Continue Reading Pieter Veenstra’s Article on their blog Paginated REST API calls in Power BI Last week I was...

Read More

Summary of Ignite 2023 – part 1

Microsoft Ignite 2023 is over but there are so much news and updates so it will take some time to dig through all of them. I summarized the most important things from Teams, SharePoint, and Planner areas in this post. Let’s go and find out what will come next year to Microsoft 365. Teams This […] Continue Reading Marcin Siewnicki’s Article on their blog Summary of Ignite 2023 – part 1 Microsoft Ignite 2023 is over...

Read More
Ignite 2023: Curated blog posts with Microsoft 365 & Power Platform Updates
Nov19

Ignite 2023: Curated blog posts with Microsoft 365 & Power Platform Updates

Microsoft Ignite 2023 was a remarkable event that showcased many exciting announcements across the Microsoft cloud platform in the era of AI. At Ignite 2023, Microsoft focused on AI and its impact on industries. Most of the highlights involve the new features and capabilities of Microsoft Cloud stack involving Artificial Intelligence and Copilots, which aim to enhance productivity and bring new ways of work. Image generated by...

Read More
How to remove the new Outlook For Windows app with Intune
Nov13

How to remove the new Outlook For Windows app with Intune

Today a short blog post about the removal of the new Outlook For Windows app, which comes with the new Windows 11 23H2 update. Outlook For Windows is the replacement for the Windows Mail app. But that's great fun if you're using Windows 11 as a personal device. But you don't want that in an Enterprise environment, so I created a remediation script that we can deploy to our Intune managed… Continue Reading Jeroen...

Read More
Remove the new Outlook For Windows app with Intune
Nov13

Remove the new Outlook For Windows app with Intune

Today a short blog post about the removal of the new Outlook For Windows app, which comes with the new Windows 11 23H2 update. Outlook For Windows is the replacement for the Windows Mail app. But that's great fun if you're using Windows 11 as a personal device. But you don't want that in an Enterprise environment, so I created a remediation script that we can deploy to our Intune managed… Continue Reading Jeroen...

Read More
Speaking at the European MCT Summit 2024
Nov08

Speaking at the European MCT Summit 2024

The annual Microsoft Certified Trainer (MCT) summit is scheduled to take place in the Netherlands this year. The event, which is scheduled for January 14–17, will be held at "De Loods," a venue in Rijswijk that is close to The Hague. Only 200 people can get into the event, so an intimate and interesting experience is guaranteed. I'm happy to be presenting a session at this event with my… Continue Reading...

Read More
Getting the proper SharePoint list columns internal names to use in List Formatting JSON
Nov04

Getting the proper SharePoint list columns internal names to use in List Formatting JSON

Question sent by a reader recently, on my Quick SharePoint Approvals using list formatting JSON to set field values formatting post: Will this not work if my column name has a number in it? I have to submit documents for 2 reviews, and I am using “1st Reviewer Status” and “2nd Reviewer Status” as the column names, but the above code will not populate the approved/rejected in that column. I modified the columns to “Reviewer One Status”...

Read More

Teams Town Hall meetings – overview

Microsoft released a brand new meeting type – Town hall. It’s a replacement for the well-known Live event, which was designed to host large events. In this post, I’m describing the main features and how to start a Town hall meeting. Introduction The town hall is a brand new type of meeting in Microsoft Teams. […] Continue Reading Marcin Siewnicki’s Article on their blog Teams Town Hall meetings – overview Microsoft...

Read More
Create parent and child records with a single WebAPI call in Power Pages
Oct25

Create parent and child records with a single WebAPI call in Power Pages

If you want to create a record with its child records in Power Pages, there is no way to do it using out of the box forms. But you can do it using JavaScript Power Pages Web API, and with a single Web API call. In this blog post we will use the example of creating an Account with 2 child Contacts in Power Pages. Prerequisites Enable both the Account and Contact tables for the WebAPIEnable the fields used in the WebAPI call for both...

Read More
WorkplaceDudes Meetup #2
Oct24

WorkplaceDudes Meetup #2

On 4 October 2023 we held our 2nd Meetup at the NN Group in The Hague. Man man, what a location this was. We were guests at the NN Group's Event Center. In this room there was enough space for our visitors with a mega video wall. Around 16:00 Engin and Jeroen were on site, and we were able to go to the Event Center together with Peter Klapwijk. Here we were going to put up some banners,… Continue Reading Jeroen...

Read More
How to allow users to only Add and View SharePoint list items (block editing/deleting)
Oct21

How to allow users to only Add and View SharePoint list items (block editing/deleting)

This blog post is based on a recent question that I got from a blog reader in a blog post related to List Formatting: Is there a way to disable the edit capabilities when users click on the “View” button? I want users to be able to view their entries after they create the item, but not edit it. You cannot disable the capabilities directly with List Formatting or via list settings only. But you can do this by creating a...

Read More
Welsh Azure User Group October 2023 Meet Up!
Oct19

Welsh Azure User Group October 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG October 2023 meet up and we had yet another two amazing speakers join us. We were joined by Samuel Gomez Huge thank you to both our guests this month! 6.30pm – Welcome and House Keeping6.45pm – Samuel Gomez – Automated information extraction with Azure AI Document … Continue reading Welsh Azure User Group October 2023… Continue Reading jonnychipz’s...

Read More
Workplace Ninja Summit was awesome!
Oct17

Workplace Ninja Summit was awesome!

After a week of Experts Live Australia, it was immediately time to head to Switzerland for the Workplace Ninja Summit 2023 held in Baden, Switzerland. For me this was the first time I was here, because I wanted to go here because of the good stories I had heard from the previous edition. My journey began on Tuesday, September 26. From Bodegraven, by train, in the direction of Utrecht and there… Continue Reading Jeroen...

Read More
Power Pages WebAPI error with N:N relationship enabled table permissions
Oct14

Power Pages WebAPI error with N:N relationship enabled table permissions

Recently working on a more complex table permissions scenario on Power Pages, where we required a N:N relationship relationships with more levels of child permissions, we had nice results when using out-of-the-box lists and also with Liquid custom Web Templates. However, I noted a few errors with basic GET queries in the WebAPI such as: {“error”:{“code”:”9004010D”,”message”:”Common...

Read More
My experience at Experts Live Australia
Oct09

My experience at Experts Live Australia

Last 19 and 20 September 2023 I was in Sydney, Australia for Experts Live Australia. In my previous blog post I already wrote about this, because I was allowed to speak there. Here is a small summary of this event which was held for the first time. My journey started on Saturday 16 September around 18:00 CEST. Then the plane took off from Amsterdam, The Netherlands to Bangkok, Thailand. Then I… Continue Reading Jeroen...

Read More

The Next Generation of OneDrive – recap

OneDrive 3.0 is… here! Microsoft announced the next generation of OneDrive. Redesigned home page, updates in existing features, new ones coming soon, and much more, and Copilot 😊 Let’s go and check what’s coming in OneDrive. New OneDrive home page OneDrive has a brand-new Home page. The starting page has a new look and feel, […] Continue Reading Marcin Siewnicki’s Article on their blog The Next Generation of...

Read More
Welsh Azure User Group September 2023 Meet Up!
Oct02

Welsh Azure User Group September 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG September 2023 meet up and we had yet another two amazing speakers join us. First up we had John Kilmister on to tell us all about unlocking the potential of Azure Blob storage with a guide to some of the lesser known features. Then … Continue reading Welsh Azure User Group September 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User...

Read More

How to send SharePoint News post via email

Do you want to send an email with SharePoint news content? Now it’s possible via the new SharePoint News for Email feature.  The content is scaled to fit different mail clients and works for mobiles. Let’s go and check what’s inside the feature and how you can use it. Introduction Microsoft released a new feature […] Continue Reading Marcin Siewnicki’s Article on their blog How to send SharePoint News post via email Do you...

Read More
Call authenticated external APIs using JavaScript from Power Pages
Sep16

Call authenticated external APIs using JavaScript from Power Pages

If you need to call external APIs using JavaScript from Power Pages, you may want to secure the calls to avoid exposing information or application hacking, as all the calls are made from client side. Power Pages sites can have OAuth 2.0 implicit grant flow enabled, so you can obtain an authentication token that has your Portal as the issuer, and you can use this token to do authenticated calls to external APIs. This post is a quick...

Read More
SMB Workshop Business Premium Webinar: Stripe OLT X Microsoft – YouTube
Sep14

SMB Workshop Business Premium Webinar: Stripe OLT X Microsoft – YouTube

SMB Workshop Business Premium Webinar: Stripe OLT X Microsoft In a world where IT Leaders need to manage rapid technology changes, user expectations, security concerns, BYOD policies, software licensing and budget constraints (to name a few), it’s become imperative that businesses are empowered with software that will support all of their requirements. We introduce, the Business Premium License…. This jam-packed session is...

Read More
Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
Sep09

Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list

Recently I was asked by a community member how to create a linked issue item (via LookUp field) using SharePoint list formatting. Via pure list formatting, it’s not possible to implement such functionality. But we can use List Formatting to create a button that triggers a Power Automate flow and this flow creates a linked issue as below: Check out how to implement this functionality in this post. Create an Issues list Create a...

Read More

Quick guide to Viva Pulse

Microsoft released Viva Pulse a few weeks ago as a public preview and now it’s globally available. It’s a tool to send targeted surveys to users and gather feedback. I played with it for a while and in this post, I will show you how to use it and get data from users. Introduction Microsoft […] Continue Reading Marcin Siewnicki’s Article on their blog Quick guide to Viva Pulse Microsoft released Viva Pulse a few weeks ago...

Read More
New office vibes 👀✨ – YouTube
Sep01

New office vibes 👀✨ – YouTube

New office vibes 👀✨ Come take a trip with us to our new Spinningfields office, located right in the heart of Manchester. Safe to say we already feel very at home here… #manchesterbusiness #manchesterit #newofficevibes Come take a trip with us to our new Spinningfields office, located right in the heart of Manchester. Safe to say we already feel very at home here… #manchesterbusiness #manchesterit #newofficevibes...

Read More
Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
Sep01

Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs

Some people have reported to me that the beloved Send an HTTP request (V1) under Office 365 groups that we used to easily call Microsoft Graph is not available anymore when creating new flows. It turns out it has recently been deprecated, as stated by Microsoft, and we are recommended to use V2 instead: Unfortunately, the V2 action only supports the /groups endpoint and will not allow us to create planner plans. The alternative At the...

Read More
Welsh Azure User Group August 2023 Meet Up!
Aug31

Welsh Azure User Group August 2023 Meet Up!

It was the day of our Welsh Azure User Group #WAUG August 2023 meet up and we had yet another two amazing speakers join us. First up we had Johnny Hooyberghs on to discuss Azure Quantum and Q#, then we were joined by Leo Visser to talk Running PowerShell with Azure Deployment Scripts. Huge thank … Continue reading Welsh Azure User Group August 2023 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...

Read More
Create an Issue Tracker App using Power Apps Copilot (Preview)
Aug26

Create an Issue Tracker App using Power Apps Copilot (Preview)

Recently I tried out the Power Apps Copilot, which is still in Preview but even though not yet perfect, had actually quite interesting results. I used it to create a basic Issue Tracker app. Here are my first impressions on this post. How can I use Copilot? Currently Copilot is available only for Power Platform environments hosted in the United States. You can try it out even with a Developer environment. Just make sure that when you...

Read More