Power Pages Table Permissions: Configure permissions to see records from child Accounts
Table permissions is a feature that allows you to control who can view, edit, or delete Dataverse records from a Power Pages site. Power Pages allows to easily configure table permissions based on Contact or Account relationships directly, for example, a user can see all records where they are the Contact in the field configured in the table permission, or their Account is their account in the field configured. However,...
Copy Dataverse contact phone numbers across different environments based on Contact e-mail address using Power Automate
Sometimes we can easily use manually triggered Power Automate Flows as ‘mini-scripts’, to run actions in bulk, such as creating/modifying data. I recently came across the need to sync a field (Business Phone) for contacts with the same email address from different environments, as in the destination environment this field was not previously used/provided, in a situation where we have two separate Power Pages portals and we have...
How to create a Teams Avatar from photo
Do you want to make your Teams Avatar look similar to you without a long manual customization process? With the latest Avatars feature, you can take your photo or take one using a camera and based on that build a 3D avatar. Let’s check how you do it. Avatars Avatars is a dedicated feature designed […] Continue Reading Marcin Siewnicki’s Article on their blog How to create a Teams Avatar from photo Do you want to make your...
🎉Celebrating a milestone: Becoming a Microsoft Most Valuable Professional (MVP)
Hello all, Since June 2024, I can call myself a Microsoft Most Valuable Professional (MVP) in Microsoft Intune. This is not just any title you can get. After 2 previous nominations in the past 3 years, I have now been awarded it. This prestigious recognition is a testament not only to my technical skills and knowledge, but also to my commitment to the community and my passion for technology.
Redirect AVD URL with a static web app
When you read the title like this, you think "That could be pretty handy!". So that's why I put it in writing. I had this a recent customer, where I migrated them from an on-prem RDS farm to Azure Virtual Desktop. Why would you choose to change the current url of Azure Virtual Desktop (https://client.wvd.microsoft.com/arm/webclient/) to something else? It's a pretty long url. It is difficult… Continue Reading...
Welsh Azure User Group June 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG June 2024 meet up and we had yet another two amazing speakers join us. We were joined by Harshavardhan Bajoria to discuss building Next Generation AI Infused applications on Azure. Then we had the brilliant Mykola Kolomiiets discussing how to process documents with Azure … Continue reading Welsh Azure User Group June 2024 Meet Up! Continue Reading jonnychipz’s Article...
Introduction to SharePoint Video Pages
Have a video on your SharePoint site and want to make a page/news from it? Now you can do it with just a few clicks! Microsoft released a new feature that automatically creates pages for your site with embedded videos. Let’s find out how it works. Introduction SharePoint Online has become a video central. You […] Continue Reading Marcin Siewnicki’s Article on their blog Introduction to SharePoint Video Pages Have a video...
Top 5 Highest Paying Microsoft Azure Certifications in 2024
Microsoft Azure stands out as one of the most lucrative career domains, offering promising career growth, immense job satisfaction, and global recognition. In this blog, I have narrowed down the list of the top 5 highest paying Microsoft Azure Certifications in 2024 that will maximize your earning potential. These certifications are globally recognized and provide … Continue reading Top 5… Continue Reading...
Get the current logged Power Pages user Contact ID via JavaScript and use it to create records assigned to the current user
If you are working with Power Pages Pro Code Development, you might need to access the current logged user Contact ID for various purposes, such as personalizing the content, saving data using the WebAPI and relating to the current user. In this blog post, I will show you how to do it via JavaScript in two different ways. Liquid to help To get the current logged user Contact ID via liquid we can to use the Liquid syntax {{user.id}}....
Welsh Azure User Group May 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG May 2024 meet up and we had yet another two amazing speakers join us. We were joined by Rhydian Jenkins of Creditsafe who gave us a n overview to how Creditsafe have implemented multi cloud governance across their estate, and then Ian Pike of … Continue reading Welsh Azure User Group May 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure...
How to get the current Azure Devops iteration name for a project using Power Automate
I was doing some investigation on how I could automate some standard messages we send for my team related to some sprint tasks using Power Automate, and one simple requirement was to automatically detect the current sprint (iteration) name, to make an email content dynamic. The problemThere is one action in Power Automate to get iterations, but it does not have a filtering option. We could leverage this one in combination with the...
Custom fonts on SharePoint – how to add, apply, and automate
Do you want to change fonts on your SharePoint sites? You can do it using a new Brand center! Microsoft’s released the feature 2 weeks ago as a preview and you can test it right now. Add custom fonts, apply fonts to sites, and even use Power Automate to do it automatically on multiple sites. […] Continue Reading Marcin Siewnicki’s Article on their blog Custom fonts on SharePoint – how to add, apply, and automate Do...
How to create Microsoft Teams private channels using Power Automate and the ‘Send a Microsoft Graph HTTP request’ action
Using the standard Power Automate actions for Microsoft Teams we can only create a standard channel, but by using Microsoft Graph with the new ‘Send a Microsoft Graph HTTP request’ action it’s possible to extend the standard actions similarly to my previous post, and create private channels in Microsoft Teams. Microsoft Graph request format To create a Microsoft Teams channel via Graph, you need to send a request body...
Using the new ‘Send a Microsoft Graph HTTP request’ action in Power Automate to send urgent messages in Microsoft Teams
One limitation we have in Power Automate’s standard Microsoft Teams actions is the inability to send high messages flagged as URGENT on Teams. However, with the new ‘Send a Microsoft Graph HTTP request’ action, we can overcome this issue and send messages flagged as urgent in Microsoft teams, enhancing our communication automation capabilities within Teams and Power Automate. The Microsoft Graph Request needed & Action in...
Welsh Azure User Group April 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG April 2024 meet up and we had yet another two amazing speakers join us. We were joined by Jake Walsh who gave us a really insightful and clear introduction to Terraform, and then Narayanan Subramanian came on to take us through a really intricate … Continue reading Welsh Azure User Group April 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...