Power Automate for Desktop with Microsoft Excel

Power Automate for Desktop with Microsoft Excel

Hey Everyone,
In this video, we will take a look at the integration of Power Automate Desktop with Microsoft Excel. This is a continuation of my Power Automate for Desktop Series.

In this video, here are the key items I have covered:
1) Introduction to the Excel actions
2) Launch, save and close Excel spreadsheets
3) Count the number of rows and columns with data
4) Loop through all the rows to read data
5) Write a row of data
6) Run SQL query to manipulate Excel

Table of contents
Introduction 00:00
Create flow and review the Excel sample spreadsheet 00:46
Launch the Excel spreadsheet 02:09
Count rows and columns 03:20
Create a variable 05:40
Create a loop condition 06:42
Read from Excel worksheet 08:00
Write to Excel worksheet 10:23
Close the Excel worksheet 13:20
SQL query to manipulate Excel 13:57
Excel automation advanced example 20:14

Helpful link

Power Automate for Desktop series

Contact information:

Join this channel to get access to perks:

#PowerAutomate #PowerAutomateDesktop #Attendflow #UnAttendedflow #Excel

[Jackot]

Hi sir, thanks for this tuto, is there a way to directly access the first free column/row rather than using a loop? just imagine if your file contains thousands of rows, you can't stay for hours before reaching the first free row, you got the idea, any thoughts?