-
Create Outlook Calendar Events from Images with Copilot Studio Workflows
As part of the Copilot Studio ecosystem, the workflows are built on top of Power Automate and support the automation of business processes, combining both traditional actions and artificial intelligence capabilities. In this blog, you will learn how to use Copilot Studio workflows to extract data from an image, structure it as JSON, and create…
-
How to manage worksheet protection with Power Automate and Office Scripts
If you use Microsoft Excel for managing templates, you are probably familiar with worksheet protection. This feature restricts certain operations within a worksheet, preventing accidental changes that could result in data loss. However, when integrating files with protected worksheets into automated processes, these restrictions can also prevent Power Automate from making changes to the file,…
-
How to manage workbook protection with Power Automate and Office Scripts
Microsoft Excel supports the protection of workbooks to prevent unauthorized changes to its structure. However, managing this protection is limited to Excel Desktop, which becomes a challenge for users working with the Excel for the web, especially in organisations where both versions are used. The workbook protection can also create challenges when executing automations with…
-
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…
Digital Mill
Your digital mill: Power Platform made easy.
