-
Managing worksheets in Office Scripts
As a solution for automating tasks within Excel spreadsheets, Office Scripts can help you to interact and manage worksheets. These interactions with worksheets can also be triggered from Power Automate, enabling you to integrate Excel automations into your workflows. In this article, you will learn how to perform a few useful tasks related to worksheets…
-
How to cancel Power Automate flow run linked to Approval Requests
Power Automate is a great tool for managing approval processes, allowing you to create approval requests, wait for a response or cancel it. One of the main actions for handling approvals is the Start and wait for an approval, which creates a new approval request and keeps the flow running until it is responded. However,…
-
Capture modifications to specific files in Power Automate
Many business processes are initialized by a file change in a SharePoint Document Library. However, when it comes to streamline these processes with Power Automate, the available triggers retrieve all files from a specific folder (including its subfolders), without providing a clear option to limit the flow to capture only the changes made to a…
-
Getting started with Solutions in Power Platform
As a set of low code tool, Power Platform is great for any “non-IT-experts” enhance their productivity with automations, applications, AI agents and websites, and all of that with a very smooth learning curve. However, once you start to work with more complex projects that may combine different Power Platform assets, such as Power Apps,…
-
Approval requests above the 30 days limit in Power Automate
Power Automate is a great tool when it comes to manage both simple or complex approval processes, since it contains a default Microsoft connector supports different approval types. One of the most useful features is the Start and wait for an approval action, which issues an approval request and pauses the flow until it is…
-
Populating an Excel table from a Microsoft Forms submission
How many processes there are in your organization where a customer or an employee must fill out a form or a document, with data then transferred into an Excel table, SharePoint list, or database? This is a common scenario, and many companies still handle it manually, risking errors in the data entry process and dedicating…
-
Reading data from Excel tables with Office Scripts
By default, tasks related to Excel tables can be integrated into low-code automation tools, such as Power Automate. However, for more advanced scenarios, you may need to rely on Office Scripts, which provides you with a wide range of alternatives to automate not only operations in Excel tables, but also in individual ranges, charts, worksheets…
-
How to group SharePoint List records by column in Power Automate
Have you ever found trouble to generate custom reports from a data source using Power Automate? In general, sending simple reports that replicate all records from a SharePoint List or an Excel spreadsheet is straightforward, but it becomes a complex task when you want to apply filters or aggregate data. In this article, we will…
-
Formatando datas do Excel com Power Automate
Muitos usuários têm dificuldades ao trabalhar com datas no Excel. As datas do sistema geralmente são armazenadas como números seriais, onde cada data é atribuída a um número inteiro único que segue uma sequência. Por exemplo, o serial “1” corresponde a 1º de janeiro de 1900, enquanto o serial “43982” corresponde a 31 de maio…
-
Extracting JSON object keys in Power Automate
Power Automate is a very useful tool for data migration and transformation in certain contexts. However, it falls short when it comes to providing an easy solution for extracting keys from JSON objects, which can pose challenges for many users looking to work with structured data. As every step output in Power Automate is essentially…
Digital Mill
Your digital mill: Power Platform made easy.
Digital Mill 