Posts

Showing posts from 2025

Copy Hidden Power Automate Expressions

Image
While recently walking a colleague through Power Automate, I was reminded of one of my long-standing frustrations: how difficult it is to copy expressions once they’ve been inserted into actions like a Compose , Filter Array , or For Each . For example: workflow()['tags']['environmentName'] item()?['logicalName'] Once fields are wrapped in certain expressions or are in certain actions, you can no longer open them in the expression popup—you or easily copy them out to reuse elsewhere. That makes it frustrating when you want to replicate logic in another flow or simply document what you’ve written. There is a copy action functionality but that copies the entire action and sometimes you just want a specific expression. The Workaround (Until Now) To deal with this, I used to: Add expressions to a comment or note in the action so I could reference them later Open DevTools and inspect the DOM to grab the full title attribute that contains the expression ...

Connecting to Dataverse from Azure Data Factory

Image
Introduction Azure Data Factory (ADF) provides versatile ways to connect and interact with Dataverse. Understanding the connection options and configurations is crucial for securely and efficiently managing your data integration tasks. This guide walks through the primary methods for connecting Azure Data Factory to Dataverse, covering their benefits, best practices, and detailed walkthroughs to get you started. provides versatile ways to connect and interact with Dataverse. Understanding the connection options and configurations is crucial for securely and efficiently managing your data integration tasks. This guide walks through the primary methods for connecting Azure Data Factory to Dataverse, covering their benefits, best practices, and detailed walkthroughs to get you started. Disclaimer: These thoughts are my own and based on my personal experience. If you have different ideas or approaches, I’d love to hear them—I’m always eager to learn more from others in the community. C...

Fixing Temperature Fluctuations on the Creality CR-6 SE with PID Tuning

Image
After installing a new hotend on my Creality CR-6 SE , I ran into a frustrating issue: when printing above 210°C, the hotend temperature would swing wildly—fluctuating by 5–10°C. The printer wouldn’t even start the print due to this instability. 🧠 The Fix: PID Tuning (Thanks to Community Firmware) This issue led me to discover PID tuning , a way to calibrate how the printer regulates temperature using smarter controls. Out of the box, Creality’s firmware doesn’t always support this—but I’m running the excellent CR-6 SE Community Firmware based on Marlin, which includes PID autotuning support via G-code commands. 🔧 How to Tune the Hotend Using OctoPrint Open the Terminal tab in OctoPrint. Turn on the cooling fan before tuning for accuracy, if you typically run the fan during your prints: M106 S255 Run PID autotune at a typical print temp (I used 215°C with 10 cycles): M303 E0 S215 C10 After sending the M303 command, you’ll see a series of output logs in the te...

Automating Azure Storage Account IP Restrictions with Power Automate

Image
When managing Azure Storage Accounts, it’s essential to control access by restricting allowed IP addresses. Manually updating these restrictions can be cumbersome, especially when dealing with frequently changing IP ranges. To address this challenge, I developed a Power Automate custom connector that automates fetching and processing Azure IP ranges using Microsoft’s Azure IP Ranges and Service Tags JSON files. Azure IP Ranges and Service Tags – Public Cloud Azure IP Ranges and Service Tags – US Government Cloud Azure IP Ranges and Service Tags – China Cloud While my initial use case focused on automating Azure IP Ranges and Service Tags, this solution can also be adapted to work with custom lists of IP addresses . Many of the actions in this connector, such as reducing CIDR blocks and generating IP rules, can be applied to any list of IP addresses. This allows users to integrate their own IP management workflows and leverage the Azure Management API to dynamically update fire...

FBI Top Ten Power Platform Connector

Image
Today’s digital landscape offers unprecedented opportunities to leverage technology in the service of public safety. The FBI’s open API, a comprehensive source of data on the nation’s most wanted individuals and significant art crimes, now seamlessly integrates into the Power Platform thanks to the FBI Most Wanted Custom Connector. This innovation enables low-code developers across federal agencies to quickly and easily repurpose critical law enforcement data for the greater good. Inspiration Behind the Connector The inception of the FBI Most Wanted Custom Connector was driven by the untapped potential within the FBI’s publicly available data. Recognizing the wealth of information housed on the FBI’s Top Ten Most Wanted list and the broader FBI’s Most Wanted API , the development of this connector was aimed at unlocking this data trove. By facilitating streamlined access to these resources through the Power Platform, the connector is designed to empower developers and agencies to b...

How to Show Notes (Annotations) on a Model-Driven App Dashboard

Image
Model-driven apps in Power Apps allow users to create dashboards that display key data from different entities. By default, dashboards do not provide an easy way to display Notes (Annotations). However, using a combination of dashboard customization and XrmToolBox, you can modify a dashboard to include a list of Notes. This article provides a step-by-step guide to achieving this. Step 1: Create a New Dashboard Navigate to the Maker Portal . Create a new dashboard . When adding components to the dashboard, insert a List for any entity (e.g., Accounts). The selected entity does not matter, as we will modify it later to display Notes. Step 2: Obtain the Notes View ID In the Maker Portal , navigate to an existing View for the Notes (Annotations) entity or create a new custom view. Once the view is open, copy the View ID as it will be needed later. Step 3: Install XrmToolBox and FormXml Manager Plugin Download and install XrmToolBox from https://www.xrmtoolbox.com/ . ...

Using Web Templates as Custom Components in Power Pages: A Classification Banner Example

Image
Introduction Web templates in Power Pages offer a powerful way to create reusable components that can be used across multiple pages, headers, and footers. This approach simplifies development and maintenance by allowing common elements, such as banners or data tables, to be managed centrally. In this article, we will explore how to use web templates as custom components, focusing on a practical example: a classification banner that can be placed in the header or footer of a Power Pages site. What Are Web Templates in Power Pages? Web templates are Liquid-based templates that allow developers to structure and render dynamic content within Power Pages. They are commonly used for: Custom layouts : Defining reusable structures for pages. Reusable components : Creating elements like banners, notifications, and data tables. Dynamic content : Injecting data dynamically using Dataverse and Liquid expressions. Microsoft has provided comprehensive guidance on using web templates as com...