Your Power Platform journey starts here
-
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…
New to Power Automate?
Check our Microsoft Power Automate: Automate Tasks Without Coding course at Udemy
The Project
Mill your processes
Welcome to Digital Mill, a free project dedicated to promoting a culture of data and automation for business users through the Microsoft Power Platform. Just as a windmill transforms wheat into flour, Digital Mill takes raw data and manual processes and refines them into actionable insights and operational efficiency. Our goal is to help businesses embrace the digital age while automating repetitive tasks.
At Digital Mill, we are committed to sharing knowledge, ideas, and cost-effective solutions that empower people without deep technical expertise. Our mission is to make data, AI and automation accessible in everyday professional life, saving time on routine tasks and allowing individuals to focus on what truly matters.
We leverage the power of automation and AI from Microsoft tools, which are widely available to companies worldwide, often included in standard subscriptions. By combining these tools with practical guidance, we aim to foster a data-driven, automation-first mindset across industries.
