Perform Excel Data Manipulations in Microsoft Power Automate for Desktop
In this video tutorial, we will create a desktop flow in Microsoft Power Automate for desktop that is able to copy data from multiple Excel worksheets, and to write the data into a consolidated worksheet. In this example, it is assumed that all the worksheets will have the same formatting. We will also show you to modify the desktop flow so that it is able to process any number of worksheets.
00:00 Introduction
00:10 The scenario
02:00 Using Loop to copy data from multiple Excel worksheets
03:55 Creating a consolidated worksheet to store all the copied data
10:45 Making the desktop flow more dynamic so that it can process any number of worksheets
13:20 Using Terminate Process to kill all Excel application
Related videos of concepts used in this video:
Excel automation basics: • Power Automate Desktop Excel Automati...
Loop actions in Microsoft Power Automate for Desktop: • How to use loops in Microsoft Power A...
Flow control (subflows, etc.): • Microsoft Power Automate Desktop - Co...
Keep in touch!
Website https://mspowerautomate.com/
Twitter / msautomate
Facebook / ms-power-aut. .
LinkedIn / power-aut. .
#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate
Watch video Perform Excel Data Manipulations in Microsoft Power Automate for Desktop online without registration, duration hours minute second in high quality. This video was added by user MS Power Automate 17 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,432 once and liked it 70 people.