Explore Insights on Platforms and Tools

When you hook Business Central into Power BI, the out-of-the-box model works fine — until you need a group view. Multi-company reporting is where things get messy fast. In this post, I’ll show you why the default setup falls short, and share some practical tips (with code snippets) for pulling data across multiple companies without losing your mind.

Managing Microsoft Dataverse environments requires proper documentation of custom tables and columns. This comprehensive PowerShell script automates the export of your Dataverse schema, filtering by publisher prefix and generating detailed CSV reports. Whether you're conducting audits, planning migrations, or creating documentation, this tool extracts table metadata, column properties, and type-specific constraints with robust error handling and pagination support.

Microsoft’s Power Pages Security Scan takes the guesswork out of portal security. Instead of manually checking every table permission or page setting, the scan highlights risks like anonymous access, overly broad roles, and unsafe scripts. Treat it as part of your governance cycle and keep your portals safe with less effort.

Need live values in a form without parking secrets in the browser. This post shows how to call a mapped Cloud Flow from Power Pages, return a simple {id,text} list, and fill Dropdown A then Dropdown B. The script adds searchable selects, keeps hidden fields in sync, and posts only clean ids. We cover the minimal Flow setup, mapping to the site, and a drop-in page script you can paste and publish.

Running flows under user accounts is a recipe for fragility. Password resets, staff changes, or MFA prompts can break your automation at the worst moment. By switching to service accounts (service principals), and retrieving secrets from Azure Key Vault, you can make your flows stable, secure, and enterprise-ready.

In the final part of this Power Pages one-step submit series we complete the picture with file uploads. You’ll learn how to create child rows for each file, upload the binary into the File column, and bind attachments back to the parent record. We’ll also cover running uploads in parallel, showing clear progress feedback, and adding production guardrails like size limits and file type checks. The result is a single, user-friendly action that does it all.

In Part 2 of the Power Pages one-step submit series we look under the hood at how records are created through the Web API. We cover token handling, building the payload from form fields, and linking to related tables with @odata.bind. You’ll also see a safe fallback pattern for when lookups fail. With this in place your custom Submit button can create the parent record reliably, ready for the file upload process we’ll cover in Part 3.

Submitting forms in Power Pages can feel clunky - you create the record, then circle back to upload files. In this post I show a cleaner way: a single button that does it all. Using a bit of custom JavaScript, the form creates the parent record, uploads one or more files, and links them straight away. Users get clear feedback with a busy overlay and a file picker that supports multiple uploads. No second pass, no confusion, just one smooth action.

Lets add some exciting custom dropdowns in Power Pages! In this blog, I will show how to turn a plain text field into a smart, flexible dropdown using jQuery UI Autocomplete. You will learn how to pull live suggestions from a Dataverse table,without using lookup fields. Whether users choose a suggested location or type their own, you keep your data clean and your UI modern.

Need to connect Power Platform to Xero? We recently built a custom connector to fetch purchase orders and create bills automatically. Here’s how we approached it, including the Swagger definition, setup tips, and flow design. A practical little automation that’s already proving its worth.

Ditch static API calls! Learn how to use dynamic parameters in Power Query to automate data retrieval and keep insights fresh.

Power Platform Governance: Protecting Your Data with DLP Policies As the number of businesses which rely on the Power Platform to...

Discover how to structure Power Platform environments for secure, scalable automation in our latest blog post.

Discover the critical role of governance in Power Platform, from securing data to ensuring compliance and optimizing workflows.

Achieve more with less by using automation tools to streamline processes, reduce manual tasks, and enhance team productivity.

Integrate legacy systems with modern tools using iPaaS. Enhance efficiency, access valuable data, and extend the life of existing technology

Microsoft Forms helps hotels manage multilingual staff and data, improving operational efficiency and reducing errors.

A Comprehensive Guide for Beginners If you're venturing into the world of Microsoft's Power Platform or are already familiar with it,...

Moving data around the enterprise, ideally, we want to do it using APIs and controlled interfaces. Sometimes this is not possible, you...

In this blog we walk you through how to export data from Power BI to a Teams channel