From the Microsoft Power Platform Blogs: Computer-Using Agents; Automate UI Testing; Import Excel Data to SharePoint List; Calculate Working Day Connector

Why It Matters

These enhancements accelerate low‑code automation while addressing enterprise governance concerns, helping organizations scale digital work faster and more securely.

Key Takeaways

• CUAs now include granular security and oversight features.
• Power Platform Test Engine preview automates UI testing for models.
• Excel-to-SharePoint import streamlines data migration via Power Automate.
• Working Day connector adds business calendar calculations to flows.
• Enhanced agents reduce reliance on fragile APIs.

Pulse Analysis

The latest iteration of computer‑using agents (CUAs) in Microsoft Copilot Studio reflects a shift from experimental AI bots to production‑grade automation tools. By embedding role‑based access controls, audit logs, and sandboxed execution environments, Microsoft tackles the security and compliance objections that previously limited enterprise rollout. This tighter oversight not only protects sensitive credentials during login sequences but also provides IT teams with the visibility needed to troubleshoot failures, making large‑scale UI automation a viable strategy for legacy‑heavy organizations.

Parallel to the agent upgrades, Microsoft unveiled a preview of the Power Platform Test Engine, a low‑code framework designed to automate UI testing for model‑driven applications. As Power Apps solutions become more intricate, manual testing strains resources and introduces risk. The Test Engine leverages declarative test scripts that can be version‑controlled alongside app components, enabling continuous integration pipelines to catch regressions early. This capability shortens development cycles, reduces post‑deployment defects, and aligns Power Platform projects with DevOps best practices.

Complementary enhancements round out the release: a streamlined Power Automate template now pulls Excel tables directly into SharePoint lists, eliminating manual data entry and supporting hybrid migration scenarios. Meanwhile, the new Working Day connector injects calendar‑aware calculations—such as business‑day offsets and holiday exclusions—into workflows, a common requirement for finance and supply‑chain processes. Together, these tools expand the low‑code ecosystem’s reach, allowing business users to build end‑to‑end solutions that are secure, testable, and tightly integrated with existing Microsoft 365 data stores.