-
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…
-
How to remove duplicates from arrays in Power Automate?
Process automation often requires repeating specific steps multiple times. In Power Automate, loops are very handy for executing these repetitions, , allowing you to perform a task for on each element of an array (for further instructions on how to loop and access individual elements from an array, check this article). However, Power Automate doesn’t…
-
Como extrair e limpar textos com Power Automate
Um dos usos mais frequentes do Power Automate é manipular textos e extrair dados para realizar tarefas. Com o Power Automate, é possível extrair texto de e-mails, PDFs, imagens, Excel ou Listas do SharePoint, entre muitas outras fontes. No entanto, esses textos geralmente precisam de algum tratamento antes de serem utilizados. Neste artigo, você aprenderá…
Digital Mill
Your digital mill: Power Platform made easy.
Digital Mill 