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

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...
Microsoft Power Automate Tutorial Playlist:
• Power Automate Tutoria...
Automation Anywhere A11 Tutorial Playlist:
• Automation Anywhere A1...
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-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@iMadeThisThat]

Thank you for another helpful video on PA!

[@truewiking]

Brillantly explained, very clear and easy to follow, Thank you very much

[@deddyandy7306]

Great job, this is insightful and direct to the point

[@simonedemo4646]

Veramente un bel video molto ben fatto, ho imparato molto. Complimenti.

[@marcosalencar7151]

Thank you, I was searching as return one value specific of column, and these video did very useful for me👏👏

[@AngeVPV]

Great tutorial!

[@soldeal4422]

Really excellent video, very useful, thank you, I subscribe to your channel, your explanations are clear

[@utube11235]

Thank you for the really useful video. If i want to Write to a specific column using the column header name (Eg: in your excel the "Group" column instead of giving it as column E), how do i do that? In C#, UiPath etc, we could have used it as row("Group") inside For Each.

[@johnshoowa8760]

Very informative video, sister. Can you please do a video on how to copy and paste data from one Excel file into a corresponding excel template without losing or overwriting the template formatting? I would really appreciate it.

[@ammadkhan4687]

very nice explanation.. Thanks for sharing. Do you also encounter a problem, when a value exists in an specific column then !write to excel ! at the end of loop does not save the excel ? How do you solve this problem?

[@sanjeevsoni6793]

Hello, How to filter the data from the Column say "First Name" and Copy to another Sheet using Power Automate Desktop ]

[@freyahuang4240]

do you happen to get the solution please? same issue here

[@emprendiendo9261]

I have tried many methods to copy and paste text from a group of cells to another sheet, but doing it in a way that does not copy the color format of the cells

[@richg7264]

This was a great help, but for some reason i'm getting a comma added to the "currentItem" variable.

[@canaksoy6461]

Is it possible multiple users enter data at the same time on same workbook?

[@soldeal4422]

Hello Do you know, How do you extract xpath Datas From the web With Power Automate. Maybe you made a video ? It would help me a lot. Thanks again for your videos. cordially

[@ganeshroyal7281]

Hi, I wanted to paste the value copied from web to a excel worksheet

[@sandeepallaka1988]

How to write into a cell using excel column name and not column letter or column index.

[@pramodkumar7040]

Quick question: I have scraped a table from webpage and write the table in excel. However, Headers are not copied to excel and rest of the data is available. Can anyone help me here how to get those headers in excel

[@swatisharma9599]

How to write multiple entry in the rows

[@emprendiendo9261]

not working there is no way to avoid compiling a group of formatted red cells to another plain sheet

[@dreffz]

Great job, this is insightful and direct to the point