-
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…
-
Debugging and accessing Office Scripts outputs with console.log
When beginners start building their first Office Scripts, testing the code can be a challenge. Since Office Scripts are designed for Excel automation, a common approach is to display the value of a variable or function return by assigning it to a random range in the spreadsheet, but this method inserts unnecessary data to your…
-
Refreshing Power BI data sources with Power Automate
By default, Power BI allows you to set up a scheduled refresh for data sources stored online, which works great for many use cases. However, there are situations where we need to refresh a data source based on a specific event, rather than on a scheduled basis. The good news is that you can set…
-
Tipos de Dados em Power Automate
O Power Automate é bastante rigoroso com seus tipos de dados, o que pode ser um pouco confuso para usuários que não têm um background em TI ou Análise de Dados. O conceito gira em torno de garantir que os dados manipulados correspondam a tipos específicos e predefinidos. Basicamente, isso significa que, se o Power…
-
Avoid repetitions with functions in Office Scripts
When creating automations in Office Scripts, you may encounter scenarios where the same or similar steps need to be executed at multiple times in your script. This can result in repetitions along the code, which increases complexity and makes the script more challenging to maintain and scale. In programming, functions are a powerful tool to…
Digital Mill
#GoDigital
Digital Mill 