How to loop through each row in Excel - Power Automate Desktop Tutorial

Do you want to loop through an Excel file with Microsoft Power Automate Desktop and perform an action for every row? In this video you learn how!

⭐️ Skip through the video ⭐
00:00:00 - Intro
00:00:04 - Structure of the Excel file
00:00:27 - How to launch Excel and open a file with Power Automate Desktop?
00:00:56 - How to read all data from an Excel worksheet with Power Automate Desktop?
00:01:30 - How to read data from an Excel file with headers in Power Automate Desktop?
00:01:48 - How to loop through Excel with for each in Power Automate Desktop?
00:02:21 - How to use display message in Power Automate Desktop?
00:02:39 - How to read the current value in for each with Power Automate Desktop?
00:03:27 - How to run an RPA robot in Power Automate Desktop?
00:03:56 - Outro

⭐️ Related videos ⭐

⭐️ Follow me ⭐
🧡 Instagram: TomsTechAcademy

#powerautomate #powerautomatedesktop #roboticprocessautomation

[martvis]

Great! Just started working with Power Automate after developing in Automation Anywhere v11 for a couple of years. Very easy and helpfull!

[vishalbharakhada]

very very helpful video. Thank you so much

[Semaj]

Hi, Can you please teach us to loop till the last row of cell by using power automate?

[tristan]

So interesting, I don't understand why you don't have more subscribers, I guess quality is better than quantity :)

[moeaung]

thanks for the great tutorial. Is there a way to set a condition so the flow reads/copies from visible rows in a excel table only?

[shahnurarefinbd]

Hey I loved your video. I am doing a research project which is exactly like yours but I need to read "urls" from an excel sheet then run it into a "Recorded Event" which will scrap few information from the url provided. Any help will be highly appreciated.

[rameshgohil]

nice, but what you will do if you have large dataset?

[mgtd]

Hi, great video!!! I have a copy and paste need from a specific column. How do you run through the list with a copy and paste need?

[keplerb]

Hi, Thank you! But it shows me error at %ExcelInstance%. By default, there is only equal symbol : =ExcelInstance. And I can not assign column names. Has anybody same issue?

[mmbcampus]

How we can apply loop through each column ? Looping only in table headers or looping in a specific row?

[KhatKhati-okrw]

Thanks for the tutorial. I do this, but instead of the value inside each excel row, the message box displays the formula. Like this: %currentitem['Name']% How do I solve the problem?

[skillfulactor]

Is it possible to loop through and excel file and perform a certain action for every row in a desktop application that you have to click Registration enter the information from excel the username and password Then verify password again click submit click okay to go back then click the login enter information etc back and forth ?