-
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á…
-
Understanding the data types in Office Scripts
Data types are a fundamental concept for Office Scripts, as this is a frequent source of errors for both beginners and experienced users. Unlike VBA, where users are always required to explicitly declare data types for variables, Office Scripts doesn’t impose this requirement. This practice, however, is highly recommended and must be followed for a…
Digital Mill
#GoDigital
Digital Mill 