Excel Automation - Add Data in 2 Columns in Microsoft Power Automate for Desktop
In this video tutorial, we will create a desktop flow in Microsoft Power Automate for desktop that will perform the following Excel automation:
• Read the values in columns A and B
• Add the 2 values together
• Write the result in column C
• Repeat for all the rows in the Excel file
We are going to show you 2 ways of automating the above task - the first method involves looping through all the rows in the Excel file, whereas the second method involves reading the entire Excel file as a datatable first, and then looping through the datatable itself. Do let us know in the comments below which method you think is better.
00:00 Introduction
00:10 The scenario
00:45 Method 1 - Terminate process, launch Excel, get first free column/row from Excel worksheet, loop, read from Excel worksheet, write to Excel worksheet and close Excel
04:18 Method 2 - Terminate process, launch Excel, get first free column/row from Excel worksheet, read from Excel worksheet, set variable, for each, convert text to number, set variable, increase variable, write to Excel worksheet and close Excel
Related videos of concepts used in this video:
Excel automation basics: • Power Automate Desktop Excel Automati...
Excel data manipulations: • Perform Excel Data Manipulations in M...
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
Смотрите видео Excel Automation - Add Data in 2 Columns in Microsoft Power Automate for Desktop онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS Power Automate 23 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,774 раз и оно понравилось 39 людям.