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