Power Platform Community Forum Thread Details

Hi,

I need help creating a loop.
Im trying to automate a process of copying a value in excel from column "b" row 1-200, going on a webpage, entering the value. Then going on to value number 2 and repeating the task over and over again. The attached picture is one working cycle but I have no idea on how to loop this to keep going down the column repeating the process.

Any tips would be greatly appreciated.

Categories:

Power Automate Desktop

Hi,

Take this flow for reference,

Looking at your screenshot, i see that you are attaching active excel session and then reading one cell and entering the details in website/app

But i would recommend to do as shared in above flow screenshot.

1. Launch the excel file by providing the path in Launch excel action

2. Get first free row on B column for the given excel instance using below action

3. Read the data from that excel range (within B column) and store in datatable using Read excel action

4. Close the excel instance

5. Now use for each action to loop through the datatable obtained as result of reading excel data as per step 3 as shown below

Now under that use send keys (as i see you are using send keys action to send the data to required ui ) under the loop

But i would recommend to use UI Automation /web actions to populate the data into required UI instead of using send keys

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!