Get a Power Pages site URL dynamically per environment to send emails via Power Automate
When we deploy Power Automate flows that send emails with URLs in the body across environments, it’s never a good practice to have those URLs hardcoded in the body. For the cases where those URLs target a Power Pages site, there are some ways we can make them dynamic per environment, you can think of environment variables but there is an even simpler way. I know this can look simple but the other day there was someone asking me...
Using Power Pages Web Application firewall to Rate limit Web API calls
In some scenarios where you have a custom Power Pages website that leverages the web API for specific pieces of functionality, you might want to add some rate limiting to it so users cannot overuse the API (for example by creating a script to abuse it and running it using chrome developer tools). Enable Web Application Firewall To enable WAF for your site you need to have CDN enabled. See steps below for more details: Content Delivery...
Power Pages CSP: Starter Settings
While working on CSP (Content Security Policy) settings on Power Pages to make the site external connections or loading of external references more restrictive, we can find a few challenges if we restrict all to ‘self’, we will break a lot of out-of-the-box functionality as some fonts, scripts and content are by default hosted outside of the website domain (they are on PowerApps, Office, SharePoint and Microsoft...
Welsh Azure User Group November 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG November 2024 meet up and we had yet another two amazing speakers join us. We were joined by the awesome Taiob Ali discussing Migrations of SQL servers into Azure. Then friend of WAUG Jake Walsh joined us to discuss Building cloud Centric Networks with … Continue reading Welsh Azure User Group November 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog...
Microsoft Ignite 2024 Recap
Microsoft Ignite 2024 is Live! There is so much news, information, and updates so it’s really hard to follow all of them and watch online sessions at the same time (or attend in Chicago). I selected the most interesting announcements and explored them a little bit. Let’s check out if this edition is only about […] Continue Reading Marcin Siewnicki’s Article on their blog Microsoft Ignite 2024 Recap Microsoft Ignite 2024 is...
Dataverse Image fields not copiyng in full resolution using the XRMToolBox DataTransporter? Power Automate to the rescue!
When moving data from a custom Table I created to store Rich Text Images into another environment using the XRMToolbox data transporter, I noted the images looked blurry: Checking the image size, it’s only a small image (like a few KB) when the original image had more than 200kb in size. So I wondered, what went wrong in the copy. It turns out the Image field is a reference to a ‘FileAttachment’ table item on the background, and we...
Copilot features overview in OneDrive
The latest updates and final rollouts enabled a full set of Copilot features for all commercial users in Microsoft 365. Now you can ask the Copilot for files, Q&As, and even compare files. So let’s dive into OneDrive and check what, how, and why not😊 Introduction Copilot appears in 2 different sections in OneDrive – […] Continue Reading Marcin Siewnicki’s Article on their blog Copilot features overview in...
Welsh Azure User Group October 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG October 2024 meet up and we had yet another two amazing speakers join us. We were joined by the amazing Alan Cox who discussed Microsoft Multi-Tenant Organisations (MTO): Enhancing Collaboration across Tenants. Then the brilliant Konstantinos Passadis came to discuss and demo Azure AI … Continue reading Welsh Azure User Group October 2024… Continue Reading...
Welsh Azure User Group September 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG September 2024 meet up and we had yet another two amazing speakers join us. We were joined by yet another two awesome presenters. First up we had Radu Vunvulea on to discuss the AI Architecture in the Cloud, then Carlos Solis Salazar joined us … Continue reading Welsh Azure User Group September 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...
Power Pages: Use a custom Rich Text Files table to store images (and avoid exposing the full msdyn_richtextfiles table)
In my previous post, I explained how to display images from a Dataverse Rich Text field in Power Pages using Liquid. However, this method enables read access to all records in the Rich Text Attachments (msdyn_richtextfiles) table, which might not be ideal in case the Dataverse environment has other functionalities that have private information stored in that table and should not be available in a Power Pages site. However, we can...
Power Pages: Display images from a Rich Text field using Liquid
Dataverse Rich Text fields store the content as HTML text in the field itself but the images that are uploaded are stored as attachments in the Rich Text Attachments table (msdyn_richtextfile). Those files are referenced directly with the URL to get the preview as image from the WebAPI, when we open them from a Model Driven app they work fine since we have access to the Dataverse Web API. But when we try to render those images that...
New design and edit options in SharePoint Pages
Microsoft has released many new features that address designing and editing content in SharePoint Pages. Some of them make the process easier, some make it faster, but the biggest hero for me is definitely coauthoring! Let’s go and check how it works. Introduction Pages are the key part of the SharePoint Online landscape. You can […] Continue Reading Marcin Siewnicki’s Article on their blog New design and edit options in...
Welsh Azure User Group August 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG August 2024 meet up and we had yet another two amazing speakers join us. We were joined by yet another two awesome presenters. First up we had Deiter Gobeyn with a great talk around Triaging Email with Azure AI Language Services and Logic Apps. … Continue reading Welsh Azure User Group August 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh...
Hiding the ‘Forms’ button in a SharePoint list view using List Formatting
I got the following request from a community member: Hi, I want to hide forms from the command bar. Please advise We can achieve this by using SharePoint list formatting Code to use You can use the following JSON Formatting snippet to hide the Forms button in a SharePoint list (bear in mind all the views need to have the formatting applied if you want to always hide it). { “$schema”:...
Renewing the Apple VPP token
👋 Today a blog post about renewing the Apple VPP token in Microsoft Intune. I opened my dev Intune tenant today and saw a warning symbol next to the Apple VPP token. So, I had a look anyway and to my surprise I had exactly 2 days left to renew the VPP token. Since this is a simple process, compared to the Apple Push Notification Service certificate, I want to share it with you. What do we… Continue Reading Jeroen...
Power Pages, FetchXML and Liquid: Group results by Lookup fields
When we run FetchXML queries on Power Pages Liquid code we get the results as a single table data structure. But sometimes it would be useful if we could group the results by some of the fields on the data set before rendering the items on the page, so we can use that for some calculations or to render data in a structure that is not a table structure or flat data structure display, like a hierarchy view for instance. We can do it...
Automatically remove Intune devices from a group after a wipe
I am sitting here under the Tuscan ☀️ and this blog post had been waiting to be published for a long time. And not just any blog post, but one in which I delved into the wonderful world of Logic Apps and the Graph API. So why would you think? Well, I got a question from a customer about whether it was possible to automatically pull laptops out of an exception group after a wipe action… Continue Reading Jeroen...
Welsh Azure User Group July 2024 Meet Up!
It was the day of our Welsh Azure User Group #WAUG July 2024 meet up and we had yet another two amazing speakers join us. We were joined by James Reeves to walk through a journey of Rockstar to Rookie tracking the career change of a Heavy Metal Guitarist into that of a Data Analyst. … Continue reading Welsh Azure User Group July 2024 Meet Up! Continue Reading jonnychipz’s Article on their blog Welsh Azure User Group...
How to create Azure DevOps pull requests using Power Automate
Recently I needed to automate the creation of Pull requests using Power Automate, but noted that there is no out-of-the-box action for that. But as usual, I love to dig into the Rest API capabilities of each platform and I figured out how to do it using the “Send an HTTP Request to Azure DevOps” action. Check out how to do it in this post. Creating the request To create the Pull request we...
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...