Power Automate Desktop to open html table row and download attachment

[jsbev]

Hi All,

We have a water bill portal and like to download the water bill for the properties using power automate desktop. The water bills are listed across 3 web pages and each page lists 50 water bills.

So far i have been able to automate the login process and navigate to the current billing page.

As in the attached screenshot the current bill page list all the properties with the water bill amount. To view the bill attachment, we have to click on the dropdown arrow and then click on the Download bill (PDF) button.

I do not know how to expand the table row for each bill and then download the attachment. 

Any help will be highly appreciated as im new to power automate desktop.

Please find below the screenshot of the current bill page and html code

The list index starts from 0 upto 49

Thanks

JS

[Nived_Nambiar]

Hi @jsbev 

Could you show the selector of dropdown in power automate desktop ?

Let's see what attributes we can use here to increment the row so it loops to next 🙂

[jsbev]

let me know if the below is the correct info required?

I noticed the ordinal attribute for each dropdown increments by 12. ie the first row arrow has ordinal value of 11, the 2nd row 23 and 3rd 35 and so on

[Nived_Nambiar]

Hi @jsbev 

Ok thanks for sharing information

So i would recommend to try this logic.

First make the bot to scrap the single page, then calculate how much such drop down are there and use loop to loop a sequeunce that number of times, inside the sequence first select that drop down and click Download PDF 

then increment the counter by 12 which would be ordinal attribute which you have shown.

Put the same loop inside the another loop which clicks the page number one by one until it reaches last page 🙂

Hope it helps !

[Agnius]

Also, you might want to use the ordinal index on the <tr> (table row) element instead. It seems like that one should be incremented by 1 with each row. But make sure you don't use a "class" property for the row element, because it seems like it has different classes for even and odd rows.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[jsbev]

Sorry how do i do that please?

[jsbev]

Using the Extract data from web page action, i'm able to get the number of rows and table information as below.

Based on this how do i setup flow that the dropdown link is clicked for each row and then click on download pdf button?

[Nived_Nambiar]

Hi @jsbev 

Try like below

1. First make a loop that click the page to browse to next page until it reaches last page , Now inside the do the below sequence for very page.

   1a. Extract the data from the page and determine how much rows of data are there in that page using extract data from webpage action.

   1b. set a variable ordinal with value as 11

   1c. Now use Loop number of times to loop given number of times the rows of table, with the sequence in the loop

           1c.1  Now use click action to click on dropdown element and make sure that selector attribute ordinal value is replaced by the variable ordinal set at step 1b.

           1c.2 Click Download PDF button 

           1c3. click on the same drop down again to close it

           1c4 Increment the ordinal variable by 12

This is how you can design the flow 🙂

Hope it helps !

Mark it as solution if it resolves your query !

[jsbev]

Making progress and pdf attachments are downloading and incrementing to the next row. 

After the last attachment is downloaded, the loop does not stop and get the error below

[Agnius]

You should loop to %DataFromWebPage.RowsCount-1%. Since the index is 0-based, if you have 50 results, you should end at index 49.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[jsbev]

Thanks Agnius. Have a similar issue with the outer loop which increments the page number. considering the first page has page no = 1, i want the loop to stop after page 3

If i change the PageNo to end = 2, then the page 3 loads, but the inner loop does not continue.

[jsbev]

I added an IF condition within the first loop as below. Stops the loop but does not go to the next page.

[Agnius]

Why do you need two variables for the page index? You have %PageNo% which you increment manually and also %LoopPageIndex% that is incremented automatically. You should simply use Loop from 1 to 3, increment by 1 and store the index into %PageNo%. You will then not need the increment variable action at the end of the loop.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.