-
How to send notifications from multiple Excel records to the same email with Power Automate
Many companies use Excel files to store data about orders, requests for quotations, trainings and much more. For example, some companies track product or service orders in an Excel spreadsheet which will contains columns for the customer’s name or code, requested item, price, delivery date, delivery status, delivery address, and so on. Power Automate can…
-
Returning Lookup and Choice Columns from Dataverse in Power Automate
Dataverse is one of the greatest tools introduced by Microsoft in the recent years. As a relational database with an easy user interface, it allows non-technical operators to efficiently manage data. One of the typical features of a relational database is the ability to make connections between records from different tables through relationships, and Dataverse…
-
Accessing Excel Ranges with Power Automate
Many companies routinely work with Excel files as part of their processes. Power Automate offers convenient actions for both reading and writing data to Excel tables. However, it’s important to note that Excel files not always will have data organized within tables. There are scenarios when vital information is dispersed across various cells throughout the…
-
Maximizing Legal Departments Efficiency with Power Automate
In a world surrounded by cloud computing, remote work, artificial intelligence, and other technology uses, legal departments are embracing innovative solutions to streamline their processes. Most part of the managers don’t know, Microsoft offers a powerful tool that simplifies this task, allowing even users without any solid IT background to create automated workflows. What’s even…
-
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.…
Digital Mill
#GoDigital
Digital Mill 