Excel in Power Automate for Desktop (Full Tutorial)

This video tutorial shows how to automate Excel with Microsoft Power Automate for desktop. With this full use case, you'll learn all the basics and advanced features, such as running macros/VBA and dynamic file naming.

📂 Course materials: https://andersjensen.org/microsoft-po...

🔹 Complete Power Automate for Desktop Course:    • Power Automate Desktop for Beginners  

👨‍👩‍👧‍👦 Discord:   / discord  
- Join my network with 2600+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!

FOLLOW ME:
💼 LinkedIn:   / andersjensenorg  
📸 Instagram:   / andersjensenorg  
👨 Facebook:   / andersjensenorg  
🐦 Twitter:   / andersjensenorg  
💌 Email Newsletter: https://andersjensen.org/email-newsle...

🖥️ My Monitor (Amazon affiliate):
Samsung 49-inch CRG9 Curved Monitor = https://geni.us/MDpejc
- If you are buying this, I can recommend the Mi Monitor Light Bar = https://geni.us/3Wwad

0:00 Intro
Automating Excel with Microsoft Power Automate for desktop is very easy. This use case takes you through all the basic features and advanced ones, such as dynamic file naming and running Excel macros (VBA).

3:37 Read Excel data with Power Automate for desktop
We'll use a Launch Excel to open an Excel book (sheet). That will produce an Excel instance we can refer to. Remember to use a Close Excel action, so your book/sheet won't get locked to read-only. Use a Get first free column/row to get your data range. Read the Excel data into a Data Table by a Read from Excel worksheet action. Iterate through the data with a For each action. Convert the Excel data with a Convert text to number action, so we can make calculations. Finally, write the data back to Excel with a Write to Excel worksheet - remember to create an index variable to write back to the right Excel cell.

18:36 Use Excel macros/VBA in Power Automate for desktop
We use the Run Excel macro to run an Excel macro created in Visual Basic for Applications, VBA. It's potent because sometimes, the actions in Power Automate are not enough. It's shown how to use arguments. Remember to change the parameters in Launch Excel to load the macros.

23:57 Dynamic file naming
The Get current date and time and the Convert DateTime to text actions are used to create dynamic file names = the date and time when the robot runs. This prevents us from overwriting data because we'll always have a new file name.

26:48 Set active worksheet
Remember to use the Set active worksheet to make your Excel automating more stable.

#microsoft #office365 #powerautomate