-
Formatting dates from Excel in Power Automate
A lot of users have trouble when working with Dates in Microsoft Excel. The system dates are often stored as serial numbers, where each date is assigned to a unique number following a sequence. For example, the serial ‘1’ matches to January 1st 1900, while the serial ‘43982’ matches to May 31st 2020. When integrating…
-
How to extract and clean texts with Power Automate
One of the most frequent uses from Power Automate is to manipulate texts and extract data from it to perform tasks. With Power Automate, it is possible to extract text from emails, PDFs, images Excel or SharePoint Lists, and many other sources. However, these texts usually require some treatment before use. In this article, you…
-
Data Types in Power Automate
Power Automate is very rigid with its data types, and it can be a little confusing for those users that do not have an IT or Data Analytics background. The concept revolves around ensuring that specific data matches predefined types. It basically means that, if Power Automate is expecting a number, you cannot provide a…
-
Using dynamic content in Power Automate
As a Low/No Code platform, one of the main goals of Power Automate is to make things easier for the user, avoiding the need of coding to achieve its results. One of the features that provides this easy use is the “dynamic contents”, which are basically a quick and user-friendly way to access data from…
-
Inserting and updating data into Excel Tables with Power Automate
Moving forward with our series about how to work with Excel Tables in Power Automate, we investigate how to insert data into Excel Tables from Power Automate. It includes either inserting new rows into a Table or updating existing records. Other articles from this series Integrating Power Automate and Excel Tables Reading data from Excel…
-
Reading data from Excel Tables in Power Automate
Moving forward with our series about how to work with Excel Tables in Power Automate, we investigate how to return data from Excel Tables into Power Automate. This reading operation can be used for all records from an Excel table, for a specific row or even for a set of rows by applying a filter.…
-
Integrating Power Automate and Excel Tables
Excel spreadsheets are an essential tool for business users, but many are missing out on the power of Excel tables. While data is typically entered into cells in a tabular format, the use of table formatting is often overlooked, resulting in less productivity. Excel tables provide a structured way to organize and manage data within…
-
Using loops and accessing array elements in Power Automate
Loops are a fundamental feature in programming languages that allow users to iterate over lists, arrays, and other data types. They are very useful for accessing individual items within these entities. In Power Automate, loops play a vital role by enabling the efficient execution of repetitive tasks. In this blog post, we will delve into…
-
Working with variables in Power Automate
In Technology, variables are a well-known concept that is present in basically in every programing language. It’s a versatile tool that allows you to store and manipulate data dynamically, so the same variable can have different values assigned to it according to the context. In Power Automate, you also can use variables, and in this…
-
How to access the raw outputs in Power Automate
As a low code solution, Power Automate is great for business process automation, empowering organizations to streamline their workflows and automate tasks seamlessly. When using the tool, we sometimes receive error messages that are not clear and we get stuck about how to solve some problems. However, there is a very useful feature that allow…
Digital Mill
#GoDigital
Digital Mill 