Unanswered

Get Row Count of table in web browser

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am logged onto a website that lists requests in a table format. I am trying to use Power Automate to get a count of the number of rows in this table so in turn, I can assign it to a variable and loop an exact number of times equal to that variable.

Is there such a way to Get that information without having to use Excel - for example, extracting data from webpage and storing the results into an Excel Spreadsheet, saving the excel document stored into a variable (ExcelInstance)?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

You can directly get the web table into a Datatable variable of PAD and then loop through it.

Use "Extract data from web page" to capture the html table which would return the results in a datatable

Detect any table value as an UI element more than once and PAD will automatically convert it to a table.

I have laid down some steps and instructions and a video link here.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi VJR,
Thank you for the reply. For the solution you provided, I need to do a Loop that is the exact number of times = to the rows in the table. What would be the variable used in this situation? When I did the Loop, I chose for Parameters - Start from:, End to: = %DataFromWebPage.RowsCount% and Increment by 1 where the variables produced = LoopIndex. With that said, does this mean my Loop is now comparable to Looping an exact number of times of the Row Count?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

You dont need to have a count variable.

Pad will automatically loop till the last row of the Datatable.

Make sure to use the "For each" action and pass the name of the datatable (in this case DataFromWebPage).

Let me know if this answers your question.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi VJR,

Thank you again, just seeing this now, will look into what you mentioned and let you know.

Mahalo!

Warm regards,

Mena

Was this reply helpful? Yes No
sri08 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mena
Hope you are well. I have developed a workflow which keys the "tax number" in the search button of a url extract the necessary information and export back it to the excel. In the same URL i have another button to be clicked which it takes to next page and i need to scrape that information as well.

The challenge here is that the few tax number has page with multiple rows. (please find attached step 4 marked in RED). As of now my workflow extracts only the first row. Not sure how to go about it ?

Please let me know ,if you can help with the flow,
Thanks
Sri

Was this reply helpful? Yes No
sri08 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please find attached the flow,

Thanks,
Sri

Was this reply helpful? Yes No