Andrew Elans articles - 36 total
Whitelist Power Automate IP addresses for Azure Firewall
Azure Blob storage account may have this setting enabled in Networking to limit access only to...
Dataverse/Azure: add AAD users to systemusers
When you enroll in the Microsoft 365 Developer Program (read my experience here), you get access to...
Live Server: fix `Live Reload is not possible without a head or body tag.`
Copy of my response for reference: github.com/ritwickdey/vscode-live-server/issues/22 where someone...
Live Server localhost: https setup on macOS & windows
With my Power Pages project I plan to use Service Worker API to pre-fetch/update the data for better...
MSAL: await config load and do the rest
Ref. also to this post of mine: Load scripts in sequence with import(), async and IIFE When loading...
Dataverse Web Api: how to setup CORS? NO ANSWER YET...
You cannot control CORS or response headers in Dataverse. I'm searching for answers... MS claim here...
Power Automate: format JavaScript error object for email
In my Power Pages portal project I would need to be notified on user client-side errors. I will later...
Dataverse: custom telemetry setup with allowed POST and disallowed GET
========================== Update 26.02.2025: See important note on "Prefer":...
Dataverse: strip all permissions from a Security Role with fetch
When creating a new blank Security Role in Dataverse of Microsoft Power Platform, you would still see...
Power Pages: how to get back .../_services/about
When building Power Pages, there is a simple method to clear portal cache / config data when...
Power Pages SPA: components Part 1
Go to make.powerapps.com -> select environment dev01 All custom app components (tables,...
Power Pages: Content Snippets with a HACK part 4
Let's make a new model-driven app to manage custom snippets. Create a new model-driven...
Power Pages: Content Snippets with a HACK part 3
To create a new model-driven app to manage custom snippets we need first to do some other...
Power Pages: Content Snippets with a HACK part 2
Let's first dig a bit in the functionality of power apps. Power Pages Management app Run...
Power Pages: Content Snippets with a HACK part 1
Power Pages is meant to be a low-code platform for building web sites from built-in components. But...
How I enrolled in Microsoft 365 Developer Program
I have Azure developer role within my organisation's tenant that is very limited in what I can...
Create JSON data with Power Fx formula column in MS Dataverse
How to create valid JSON data from existing columns in Dataverse? Power Pages use...
Show full text on hover with text-overflow: ellipsis
Inspired by this post where someone would want to have an active title property for only those...
Fix Bootstrap 5.3 modal's rootElement
When placing a Bootstrap 5.3 modal inside a container other than body, bootstrap's <div...
Dataverse table with 2 lookup and 1 formula columns
Task I have contracts with customers. Each contract may have only one customer...
Inject HTML snippet from file
A question on stackoverflow: Include another HTML file in a HTML file I was playing around and...
Power Pages: modified <dialog> functionality
In my project I use a Power Pages portal with Bootstrap version 3.4.1 which has a page for managing...
Power Pages: how to disable ESC on modals
Earlier versions of Power Pages use Bootstrap 3, newever Bootstrap 5, and all use jQuery. ...
JSON to CSV for Excel: simple object
Let's now convert simple JSON data to CSV with JavaScript, export and open CSV file in Excel. ...
JSON to CSV for Excel: a note on CSV and encoding
There are multiple JS libraries that allow export to excel. But what if we want to follow a...
Dataverse: get distinct values with Web API
I want to get a list of distinct countries with a Web API call from a Dataverse table with 60.000+...
Power Pages SPA: login redirect
Rev 03 note from 15.05.2025 Article is updated with complete instructions. Rev...
Power Pages SPA: fragment-based routing
Rev 01 note Some parts of this article are updated 09.08.2024 to conform with the RFC3986...
Power Pages SPA: structure
Default structure of pages in Power Pages Each actual web page you navigate to in a...
Power Pages SPA: main setup
In this post I requirements for provisioning Single Page Application with Power Pages. I will not...