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
Смотрите видео Perform Excel Data Manipulations in Microsoft Power Automate for Desktop онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS Power Automate 17 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,432 раз и оно понравилось 70 людям.