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