How to loop through each row in an Excel file - Power Automate Desktop Excel actions tutorial

preview_player
Показать описание
We often use Excel files to hold large swaths of data - hundreds, perhaps thousands, of rows. You might want to automate your activities using tools like Microsoft Power Automate Desktop, since, with such large numbers of data, chances are you probably spend a big chunk of your time repeatedly doing the same thing with each value, or each row, in your Excel file.

You'll need to loop through each row to store and retrieve the specific value you want for your task so that Microsoft Power Automate Desktop help you get it done.

So, how do you loop through each row in an Excel file?
00:00 Introduction
00:51 The objective
01:04 Method 1: Loop
07:50 Method 2: Datatable
08:09 What is a datatable?
08:24 Method 2 Step 1: Read and store values
12:29 Method 2 Step 2: Retrieve values

Is there any other topic in Microsoft Power Automate Desktop you would like us to go through? Let us know in the comments 👇

Keep in touch!

#powerautomatedesktop #powerautomate #excel #powerautomatetutorial #excelautomation
Рекомендации по теме
Комментарии
Автор

Thank you! I watched 40 videos trying to understand this. I got it after watching yours.

rorybahia
Автор

My friend, thank you so much for this tutorial. I finally got my first PA to loop through a list of my film collection referencing IMDB and applying release year to each title in Excel. 🤗You've earned a follow.

thecandyman
Автор

Excellent video. Makes a lot of sense Especially if you have some coding structure background. Power automate is just coding with a UI interface. Very user friendly.

WinkieDuck
Автор

For Method #2, rather than using the column index number, an alternative would be to use the column header name.

So %CurrentItem[0]% would become %CurrentItem['First Name']%. And so on...

Using the index number would require that you modify the workflow should you insert a new column at the beginning, or if you decide to reorder the columns so that Column 0 and 1 no longer correspond to First/Last name.

Good video, keep up the good work!

airrsongs
Автор

Your videos are really helpful!

Thank you so much, I hope you keep creating and helping all of us!

Have a wonderful time!

davi.constante
Автор

I realized these cases on my own, I do not say it to show off. But it is great to see that there is a step by step video, since I did not take notes when I did the practical case. Thank you very much, I hope you continue to publish more PAD videos.

Tortugostalker
Автор

Thank you very much; simple and easy to follow.

adoleh
Автор

I can't thank you enough for this one, I simply couldn't find anything related to this type of iteration and was having to do a long and tedious job manually, this just saved my day (and project deadline as well)

tharic
Автор

Excellent VDO, easy to understand. Appreciate your training material.

kasinasintuaus
Автор

PERFECT!!!! I'm using Power Automate to do an email message from Excel and Outlook!!!

tonypetruzzi
Автор

Thank you, I wasn't aware of the 2nd method but will start using it from now on!

pudu
Автор

amazing tutorial, great explanation, really helps me figure out how to get what i need done.

williammah
Автор

Great Video, it is so clearly . let me understand how to use . thousands thanks

civicleung
Автор

Very helpful video...Thank you so much :)

krishnakumar-hpor
Автор

Thank you! It is a great tutorial. I have a scenario whereby I have an excel with a multiple row count. How can I make the looping value dynamic based on the excel row count? Thanks in advance.

firdaussnoordin
Автор

hi i need more video like this but have many loops

noorfatinnajwa
Автор

Thank you for sharing. How to compare two excel and provide in status column in second excel like match or not match in

harshadpatel
Автор

My Excel has a dynamic set of rows. How do we manage this?

KakdeG
Автор

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

Semaj
Автор

Amazing. Thank you. I have a question. I have a registration form built in SSRS and I want to record the fields as variable so every time I read the data from an excel file it automatically inserts them into the registration form and clicks the submit button to be added to the SQL database. Can you help please?

roseabu-nie