Excel Automation in Power Automate Desktop | Write to Excel worksheet in Power Automate Desktop #03
Quality Assurance Lab Quality Assurance Lab
41.8K subscribers
32,826 views
359

 Published On Mar 24, 2021

This video explains multiple scenarios to write data to excel using Power Automate Desktop
0:10 - Demo 1: Take user Input and write the user input to a new excel file
0:33 - Take user input using Display Input Dialog Action
1:55 - Launch a blank excel file using Launch Excel Action
2:09 - Write data to excel file using Write to Excel worksheet Action
3:03 - Save and close the excel file using Close Excel Action

5:39 - Demo 2: Write data to an existing excel file based on condition
6:48​ - Launch an existing excel file using Launch Excel Action
7:16​ - Get first free row or column
7:55​ - Read data from Excel
10:27 - For Each action to iterate the Datatable variable
11:14 - If Action
12:29 - Write to Excel worksheet Action
15:42 - Else if Action
17:02 - Save and close the excel file using Close Excel Action

=========================================================
Microsoft Power Automate Desktop Tutorial Playlist:
   • Power Automate Desktop Tutorial  

Microsoft Power Automate Tutorial Playlist:
   • Power Automate Tutorial for beginners  

Automation Anywhere A11 Tutorial Playlist:
   • Automation Anywhere A11 Tutorial  

Automation Anywhere A2019 Tutorial Playlist:
   • Automation Anywhere A2019  

UiPath Tutorial Playlist:
   • UiPath Tutorial  

JMeter Tutorial Playlist:
   • JMeter Tutorial  

Git and GitHub Tutorial Playlist:
   • Git and GitHub  Tutorial  

Subscribe for more tutorials -    / @qualityassurancelab7764  

Connect with me for some interesting updates here -
LinkedIn -   / quality-assurance-lab-6500a71a0  
Facebook -   / quality-assurance-lab-107065690712674  
Twitter -   / labassurance  
Medium -   / labassurance  

Join Channel Membership -    / @qualityassurancelab7764  

show more

Share/Embed