Power Automate for Desktop with Microsoft Excel

Published: 06 February 2023
on channel: Daniel Christian
1,833
55

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
- https://learn.microsoft.com/en-us/tra...

Power Automate for Desktop series
1) Introduction to Power Automate for desktop    • Introduction to Power Automate for De...  
2) Power Automate for desktop recorder    • Power Automate Desktop Recorder  
3) Power Automate for desktop message box    • Power Automate for Desktop Message Boxes  
4) Power Automate for desktop variables    • Power Automate Desktop Variables  
5) Power Automate for desktop machine management capability    • Power Automate for Desktop Machine Ma...  

Contact information:
Twitter:   / dchristian19  
Facebook:   / www1.christianfamily.biz  
Instagram:   / dan.christian.33  
LinkedIn:   / danchristian19  

Join this channel to get access to perks:
https://www.youtube.com/@DanielChrist...

#PowerAutomate #PowerAutomateDesktop #Attendflow #UnAttendedflow #Excel


Watch video Power Automate for Desktop with Microsoft Excel online without registration, duration hours minute second in high quality. This video was added by user Daniel Christian 06 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,833 once and liked it 55 people.