Unanswered

Extract information from the web-page with multiple rows

(0) Share

Report

Posted on by sri08

Hi Team,

I need help with the flow where the flow can iterate through the mulitiple rows of a webpage and extract the information to excel.

Currently my flow works only on first row. Not sure how to create a counter which can calculate the number of rows and iterate through each one of them and scrappe the information,

thanks for the help.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

MarcelLehmann 378 on at

Like (0)

Report

U could initialize a whole number variable (default 1) and a variable with boolean. Then u take the action do until and give the condition .. variable boolean is true

Then put your action in with collecting the data with a row selection table[variable whole number]?('message') After this action put a condition like isempty(collection field). Then put on yes set variable to true and on false u increment the variable whole number.

Set the advanced settings of the loop to 200 or so many rows that could be max.

Was this reply helpful? Yes No
sri08 20 on at

Like (0)

Report

Hi @MarcelLehmann ,

Thank you for the reply and the suggestion. Sorry i am new to this. Can you please share some workflow which i can look into and try to implement in my flow?

Please find attached my flow,

Thanks,
Sri

Was this reply helpful? Yes No
MarcelLehmann 378 on at

Like (0)

Report

ah ok u use power automate desktop - no problem. (my description was about cloud flows)
have u seen this: Power Automate Desktop : Web Data Extraction - Ex... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
sri08 20 on at

Like (0)

Report

Hi @MarcelLehmann ,

Thank you for the reply. Yes sorry i didnt mention clearly i am using power automate desktop. Thank you for the link . i have see similar videos. My problem is attached in Step 7 pic.

Currently my workflow is extracting only first row and there are cases where there is more than 2 or 3 rows. what i am facing difficulty

1) how to take the count of number of rows (or how the bot will iterate to see how many rows are present)
2) Then scrappe the data and go back to first step once all rows are extracted.

Thanks,

step_6_output.PNG

step7.PNG

Was this reply helpful? Yes No