Excel Automation in Power Automate Desktop | Write to Excel worksheet in Power Automate Desktop #03

Published: 24 March 2021
on channel: Quality Assurance Lab
32,947
362

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  


Watch video Excel Automation in Power Automate Desktop | Write to Excel worksheet in Power Automate Desktop #03 online without registration, duration hours minute second in high quality. This video was added by user Quality Assurance Lab 24 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 32,947 once and liked it 362 people.