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...
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...
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...
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...
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...
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...
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...
How to monitor SharePoint sites with Microsoft Clarity
Want to monitor your SharePoint site and get advanced data, session recordings, and even heatmaps? Microsoft Clarity is for you. It’s not a new tool but with native support for SharePoint sites, it’s worth a try. Let’s go and check how to configure it and start working with it. Introduction You’ve just created and deployed […] Continue Reading Marcin Siewnicki’s Article on their blog How to monitor SharePoint sites with...
Issue solved: Canvas Apps PDF function – ‘PDF Creation Failed’ when using a gallery and checking conditions before calling the PDF function
Recently a reader reported an issue happening while using the PDF export functionality in Canvas Apps: I have an application with 2 galleries. The first one is populated with items that are users from a group, and the other is a collection that is populated with users from first table. Items with users from first gallery are “moved” to a collection and then, displayed to the secondary gallery. Like in your example, I put a button that...
How to use DocuSign Approvals in Teams
Electronic signatures play a major role in most formal processes. A big process, an agreement signing, NDA documents… it’s everywhere. Teams has a dedicated feature for e-signs and it’s definitely worth checking. Although it’s limited to 2 providers it’s still a great enhancement in many cases. If you use electronic signatures using DocuSign this post […] Continue Reading Marcin Siewnicki’s Article on their blog How to use...
Microsoft Inspire 2023⚡ #microsoft #microsoftupdates #microsoftinspire – YouTube
Microsoft Inspire 2023⚡ #microsoft #microsoftupdates #microsoftinspire Have you caught up with all of the exciting developments announced at Microsoft Inspire 2023? ⚡ For those of you that have yet to find out the fantastic new updates (and those who need a little refresher) UK Sales Manager Matilda is here to give you a quick round up of her favourite announcements 📣 To find out all about Microsoft’s updates from Inspire 2023,...
Filtering Dataverse data by the current user in Cards for Power Apps
While playing around cards for Power Apps, I noted that the User Power Fx function that is used in Canvas Apps to detect the current user and get some information about it is not supported. After some investigation, I found that Cards use a new object called Viewer instead. How to use the Viewer Object The viewer object has 3 properties that potentially we could use to filter data by the Current User : name: it’s the user...
Speaking at ExpertsLive Australia
For a long time, I always thought I wasn't the person to speak at an event or a meetup or whatever. But recently, especially from our Youtube show, the WorkplaceDudes, and my experiences as a Microsoft Certified Trainer, it started to itch a bit. So, I took the plunge, created a Sessionize profile and devised sessions. And then… looking for a event, or a meetup, and then submitting one of my… Continue Reading Jeroen...
Colored Folders – How to use via Power Automate
Microsoft released a new feature called Colored Folders. It’s available both in OneDrive and SharePoint Online. You can use it to apply color to a special folder to categorize manually data based on the content inside. You can also use Power Automate and automate the whole process. In this post, I will show you basic […] Continue Reading Marcin Siewnicki’s Article on their blog Colored Folders – How to use via Power...
Colored Folders – How to apply a color using Power Automate
Microsoft released a new feature called Colored Folders. It’s available both in OneDrive and SharePoint Online. You can use it to apply color to a special folder to categorize manually data based on the content inside. You can also use Power Automate and automate the whole process. In this post, I will show you basic […] Continue Reading Marcin Siewnicki’s Article on their blog Colored Folders – How to apply a color...
Sort an object array by numeric values that are stored as string using Power Automate
Recently I got a question in a previous post about the sort expression in Power Automate: I am attempting to use this expression in a compose box to sort by a numeric ascending value, but it is sorting that value as if it were a word and not a number. How would I amend this expression to sort the array by a number value that is apparently stored as a text string? Let’s have a look at the issue. If we have an array of objects as...
Opening the New form from another list using SharePoint list formatting
If you want to open the new form in another list using SharePoint Lists JSON formatting, it is pretty straightforward. All you need to do is to use the href property in a link object inside of your custom HTML generated by list formatting, and point it to the relative path of the new item form of the list you want to open, for example: /sites/<your site>/Lists/<your list>/NewForm.aspx Imagine you have an issues list in...