Turn outdated into automated - Design intelligent dashboards with automated reporting

Turn outdated into automated - Design intelligent dashboards with automated reporting Let's say you have office supply data coming in from different regions; east, west and central. And you regularly have to format and compile all these different data sources into one financial report for your executive team. Well, Microsoft Power Automate makes it fast, easy, and more secure, while reducing errors and freeing you up to do more important stuff. Here, I'll show you. We're going to make a main desktop flow and add several subflows to build out your automation..

Start by launching a new Excel doc, then create a new subflow that will let us separate and manage different parts of the flow easily. This one will be to read and write sales data from the different regions. Next, launch the sales data worksheet from the central region that will read all the values and table column names too..

Choose the Excel instance and write this red data to the main final consolidated report starting from column a row 1. Once we have this subflow ready we can run it. Now, let's create another subflow for the East region. Just like earlier, launch the Excel file, read from it and close it. We can just copy the associated actions change the file data source path and hit save..

Then, read this red data to the main report. But since the row will be different than 1, find the first free row on column A with an action and use the output of it in the write section. For any more data sources, we can just copy the same set of actions and create new sub flows, just change the file path accordingly. Back in our main subflow, run the associated steps for reading and writing from these different.

Reports one by one. This lets us manage the different chunks of this flow easily. now launch an Outlook instance and send the report as an attachment to the executive team. And that's it! Now for the fun part let's do a test run to make sure your new flow works. And just like that, the flow reads all the different data sources formats and consolidates it into a final report that's sent to the executive team...automatically..

DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continuetomake videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=gI34H0JwuRM