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.
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.
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)
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.
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.
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?
Hello sir, how can we loop through only unique values on the excel data or data table? For example if the data table contains identical rows how can we instruct power data automate to filter each unique value? Thank you
Uploading data from excel to an online form and submit , however there are no buttons to click for the next person because they people are already on the same page of the form you only click on their names
Hi , I have 40 columns in my excel to fill up For each column the value i stored in a variable to write to excel and i can able to increase the row count to add But, for each column I end up with using 40 write to excel activities Can you please suggest how to use one write to cell action by storing the data in datatable or in any other way please
I have a excel file which contains a range Of Id Numbers which i have to search one by one on our company's website there a search bar on it and click show button after clicking show button i have save that specific Page as PDf with the name range i got in excel one by one can you help me with that....
I need to Downlodd file from Google drive link where I have a zip folder and CSV file it's a manual procedure on daily basis can I automate this for all links for example power automate do this for first link to last link ??
Would you plesae explain how to copy one cell from excel and paste in a website, for example: i have a table in excel with the column user, so i need to copy each value of the column and paste in a website of my company to search this user. Thanks
I tried the technique on PAD, but it’s not recognizing the columns once it reads the data from excel even when the ‘exceldata’ flow variable shows the column names. I tried using both column names and numbers. Where am I going wrong?
isn't a way to access a data value by the column name instead of the index? I ask this beacause if the columns order changes then the automation will fail or throw strange results.
Hello, thank you very much for this clear and understandable video, very good learning material. I now am wondering how you would proceed with the following. Let's assume you have the same content in the spreadsheet, but you have multiple employees for each company. Now you want to enter all these data into a CRM system. Assume you have listed three companies and each company has three employees in your spreadsheet. For the first company, you create a new record in the CRM system and insert the data of the company of the first row. Once saved, you have to add the name of the first employee. So you click on a button in the CRM system to add an employee record for that company. You do the same for the next two employees. However, on the fourth row, there is a new company and its three employees. How do you detect with Power Automate Desktop there's a new company to be added, and than the three employees of that company? Looking forward to a next great video! Thanks in advance.
Thanks for your feedback. One idea to consider is to first retrieve the company name from your spreadsheet, then check whether the company already exists in your CFM. If yes, proceed to add the employee record. Otherwise, create the company record first. Let us know if this helps.
Very good work! Would be great if you show us how to build different actions. EG. The name is Smith, if Name Smith -> do this. If Name is David > do this.
Hello, thank you for the helpful video. My issue is that I have a list of 2 columns with around 100 rows of data. I need to loop 10 at a time until it reaches blank. Which loop would I need to use? Basically looks like this: (In web) Enter Row 1 Press Submit Enter Row 2 Press Submit Enter Row 3 Press Submit ... Enter Row 10 Press Submit Then start another loop starts from Row 11. and then goes through the same cycle until it reaches a blank cell.
Hi Vikshay, I'm not sure if I understood your requirements fully. Maybe you can drop an email to help@mspowerautomate.com with your detailed requirements. Cheers!
You'd be better off just using a regular loop with 2 variables for your start and end, a label before the loop and a GoTo tag inside an IF condition. First place a label and call it anything, let's say 'BeforeLoop' Lets call your start variable 'LoopStart' and give it a value of 2. Let's call your end variable 'LoopEnd' and give it the value of '%LoopStart + 10%'. With this you will be able to start your loop anywhere and end after the 10th row, which will be 12 in this case. To have the loop start again from let's say Row 13, simply set the variable of %LoopStart% to %LoopEnd + 1% AFTER the loop ends. Now with the LoopStart being 13, you can place an IF condition to check if your flow should do the loop again or it's done. If you want to keep going, use a GoTo Tag and set it to the label created at the start ('BeforeLoop'), if not, just continue the flow and you're good to go.
Great video! Two questions arose while watching your video. If I create a "For each" my datatable contains blank lines. Every other line is blank. How do I remove the blank lines? Secondly, I would like to write the data in my datatable to another Excel file in specified cells. Is this possible?
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!
Thank you! I watched 40 videos trying to understand this. I got it after watching yours.
Glad it helped!
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.
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.
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)
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.
Thanks for sharing
PERFECT!!!! I'm using Power Automate to do an email message from Excel and Outlook!!!
Your videos are really helpful!
Thank you so much, I hope you keep creating and helping all of us!
Have a wonderful time!
Thank you! Wish you all the best too!
Thank you very much; simple and easy to follow.
Excellent VDO, easy to understand. Appreciate your training material.
Thank you, I wasn't aware of the 2nd method but will start using it from now on!
amazing tutorial, great explanation, really helps me figure out how to get what i need done.
Thank you a lot
Great Video , it is so clearly . let me understand how to use . thousands thanks
Glad it was helpful!
Great video! Thank you.
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.
Very helpful video...Thank you so much :)
Excellent 👍
Hi, Can you please teach us to loop till the last row of cell by using power automate?
amazing! thanks!
My Excel has a dynamic set of rows. How do we manage this?
Thank you.. how can I copy the value of any cell (e.g. first name then last name) and copy them in online system using record function
Great help thanks
Thank you for sharing. How to compare two excel and provide in status column in second excel like match or not match in
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?
Thanks
good video!! Can you please share or do a video regarding doing Power Automate Desktop AND power pivot Excel? Thanks!!
Hello sir, how can we loop through only unique values on the excel data or data table? For example if the data table contains identical rows how can we instruct power data automate to filter each unique value? Thank you
Uploading data from excel to an online form and submit , however there are no buttons to click for the next person because they people are already on the same page of the form you only click on their names
Is there a way we can select a dynamic range of cells as the datable variable?
hi i need more video like this but have many loops
Hi , I have 40 columns in my excel to fill up
For each column the value i stored in a variable to write to excel and i can able to increase the row count to add
But, for each column I end up with using 40 write to excel activities
Can you please suggest how to use one write to cell action by storing the data in datatable or in any other way please
I have a excel file which contains a range Of Id Numbers which i have to search one by one on our company's website there a search bar on it and click show button after clicking show button i have save that specific Page as PDf with the name range i got in excel one by one can you help me with that....
Thank you very much! Is there a way to join spreadsheets together using power automate?
I need to Downlodd file from Google drive link where I have a zip folder and CSV file it's a manual procedure on daily basis can I automate this for all links for example power automate do this for first link to last link ??
What about if I have multi sheets in my file?
thank you verymuch
You are welcome!
Would you plesae explain how to copy one cell from excel and paste in a website, for example: i have a table in excel with the column user, so i need to copy each value of the column and paste in a website of my company to search this user. Thanks
I tried the technique on PAD, but it’s not recognizing the columns once it reads the data from excel even when the ‘exceldata’ flow variable shows the column names. I tried using both column names and numbers.
Where am I going wrong?
isn't a way to access a data value by the column name instead of the index? I ask this beacause if the columns order changes then the automation will fail or throw strange results.
How do you loops through the same row 2 times in csv file or excel file ?
How we can apply loop through each column ?
Hello, thank you very much for this clear and understandable video, very good learning material. I now am wondering how you would proceed with the following. Let's assume you have the same content in the spreadsheet, but you have multiple employees for each company. Now you want to enter all these data into a CRM system. Assume you have listed three companies and each company has three employees in your spreadsheet. For the first company, you create a new record in the CRM system and insert the data of the company of the first row. Once saved, you have to add the name of the first employee. So you click on a button in the CRM system to add an employee record for that company. You do the same for the next two employees. However, on the fourth row, there is a new company and its three employees. How do you detect with Power Automate Desktop there's a new company to be added, and than the three employees of that company? Looking forward to a next great video! Thanks in advance.
Thanks for your feedback.
One idea to consider is to first retrieve the company name from your spreadsheet, then check whether the company already exists in your CFM. If yes, proceed to add the employee record. Otherwise, create the company record first.
Let us know if this helps.
Very good work! Would be great if you show us how to build different actions.
EG. The name is Smith, if Name Smith -> do this. If Name is David > do this.
whats app has limited the forwared message to 5 how can we use power automate to do so
Hello, thank you for the helpful video. My issue is that I have a list of 2 columns with around 100 rows of data. I need to loop 10 at a time until it reaches blank. Which loop would I need to use?
Basically looks like this: (In web)
Enter Row 1
Press Submit
Enter Row 2
Press Submit
Enter Row 3
Press Submit
...
Enter Row 10
Press Submit
Then start another loop starts from Row 11. and then goes through the same cycle until it reaches a blank cell.
Hi Vikshay, I'm not sure if I understood your requirements fully. Maybe you can drop an email to help@mspowerautomate.com with your detailed requirements. Cheers!
You'd be better off just using a regular loop with 2 variables for your start and end, a label before the loop and a GoTo tag inside an IF condition.
First place a label and call it anything, let's say 'BeforeLoop'
Lets call your start variable 'LoopStart' and give it a value of 2. Let's call your end variable 'LoopEnd' and give it the value of '%LoopStart + 10%'.
With this you will be able to start your loop anywhere and end after the 10th row, which will be 12 in this case.
To have the loop start again from let's say Row 13, simply set the variable of %LoopStart% to %LoopEnd + 1% AFTER the loop ends.
Now with the LoopStart being 13, you can place an IF condition to check if your flow should do the loop again or it's done. If you want to keep going, use a GoTo Tag and set it to the label created at the start ('BeforeLoop'), if not, just continue the flow and you're good to go.
How to do loop until finished? Instead of specify the start and end loop?
Depends on what you are trying to loop. For example, if it is a datatable, you can use the action "For each". Hope this helps.
Great video! Two questions arose while watching your video. If I create a "For each" my datatable contains blank lines. Every other line is blank. How do I remove the blank lines? Secondly, I would like to write the data in my datatable to another Excel file in specified cells. Is this possible?
how to loop through each row of a data table in a web page without knowing the number of rows in that data table.
Singaporean?
hi i need loop dates dd/mm/yyyy from excel. I need add a format? When i extract data from excel show a wrong input in format : dd/mm/yyyy 00:00:00
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!
Could you also use the action to get first free column/row in cases where the length of the list is unknown or is dynamic?
Yes with a foreach loop looping through your Excel table