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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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”...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...