-
How to get column headers from all Excel tables in a workbook with Power Automate
Power Automate works great for managing data in Excel tables, including reading, updating, deleting or adding records. However, there is no built-in action for extracting information about the structure or metadata of multiple Excel tables in a same file, such as a list of their column headers. Although it is possible to access the column…
-
How to get column headers from Excel table in Power Automate
Power Automate works great for managing data in Excel tables, including reading, updating, deleting or adding records. However, there is no built-in action for extracting information about an Excel table structure or metadata, such as a list of its column headers. Although it is possible to access the column headers of a table by combining…
-
Overcoming Power Apps Delegation Limits with Power Automate and the SharePoint REST API
One of the most common challenges when building Power Apps solutions that use SharePoint Lists as data sources is dealing with delegation limits. Even with Power Apps support to delegable functions, there are scenarios where filtering, searching, or processing large datasets becomes difficult once a list grows beyond a few thousand records. A popular workaround…
-
Send PDF generated templates via email with Power Automate, Microsoft Word and Outlook
Generating multiple documents and distributing them to a large number of recipients can be a time-consuming and painful administrative task. With Power Automate, you can streamline this process and reduce its execution time from more than 10 minutes to less than 10 seconds: In this blog, we will build an end-to-end document generation process using…
-
Building Dynamic Public-Facing Forms Using Power Automate and HTML
Microsoft Forms is a convenient tool for quickly creating basic public-facing forms, especially given how easily it integrates with Power Automate to trigger workflows based on responses. However, it comes with several limitations when building more advanced solutions. One of the main constraints is the lack of dynamic behavior: forms cannot adapt in real time…
-
Copy data between Excel Files using Power Automate and Office Scripts
Managing data across multiple Excel files is a frequent use case for automation. In Power Automate, transferring data is straightforward when both the source and the destination are formatted as a table, making it a convenient option for many standard use cases. In this article, you’ll learn how to copy data between Excel files using…
-
How to Add or Update Rows in Excel Tables Created Dynamically in Power Automate
When working with Excel in Power Automate, adding or updating rows in a table is usually straightforward, as long as the table already exists. However, things become more complex when the table is created dynamically during the flow run, or when the Excel action references a dynamic file. In these scenarios, the table schema is…
-
How to set up an App Registration in Azure Portal for Microsoft Graph API
When working with Microsoft Graph API, proper authorization is required to ensure secure access to the different Microsoft services. There are different authentication and authorization approaches, but for most scenarios, creating an App Registration in Microsoft Entra ID (accessed via Azure Portal) is the simples and most practical solution. In this article, you will learn…
-
What is Microsoft Graph API and how to use it?
Microsoft Graph API is a powerful tool that allows you to access and manage data across Microsoft 365 services such as Outlook, Teams, SharePoint, OneDrive and Planner. It enables direct interaction with Microsoft 365 resources, making it possible to retrieve information, perform administrative tasks, and leverage advanced features that may not be available through standard…
-
Integrating Copilot Studio and Azure Application Insights for Analytics
While Copilot Studio provides basic metrics to help us understand how an Agent is being used, its native analytics lacks a real-time monitoring and becomes limiting as soon as you need deeper visibility into user behavior or operational performance. Although the built-in Analytics tab may be sufficient for a basic usage of the tool, scaling…
Digital Mill
Your digital mill: Power Platform made easy.
Digital Mill 