Looping operation imputting data from excel and extracting data from web to excel

(0) Share

Report

Posted on by bebo987

Hi team,

I am trying to build up a flow that scrapes price values from a website (transport fares)

Basically what I need to do is looping an operation that

connects to the website
insert some criteria (from/to)
select a date, from a date list coming from excel
run a query
fetch the fare and save it to the correspondent excel record
repeat from step 3 up to the final date

so on steps 1 and 2 I'm ok and also 3: I ran a test to select a single date but I don't know how to fetch the data from an excel matrix and putting it into a loop

Thanks for your help

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

@bebo987

This video would help you to achieve what you are looking for.

Write back if this is not what you're looking for or need something more.

Video link

Was this reply helpful? Yes No
Riyaz_riz11 4,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bebo987

I will attach the steps, please refer this.

Here %CurrentItem4[2]% 2 refers the 3 rd column

insted of that you can mention name as well %CurrentItem4['Empname']%

%CurrentItem4% just a variable name.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
bebo987 98 on at

Like (0)

Report
Copy link

Link copied!

HI Guys

thank you for your precious support.

While I get towards those steps I am trying the whole process as a one-off operations (namely one single query to the website)

The Issue I can't workout it's a simple scroll:

This screencap shows you the page the flow has to scrape. After inputting all the parametres it should scroll down to the "Search" Button (in screencap 2)

Even if I tried to record the screen, the actual scroll action, I had a look around on internet to see if there is any viable solution that doesn't require Java Coding but I couldn't find anything.

Do you know any possible solution or workaround to get to the "Search" button?

Thanks for your help
Cheers

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Are you not able to Add an Ui element for the Search button?

Once added then click it using PAD actions.

Right click on the button -> Inspect element -> what is the html code it is showing for this button?

Was this reply helpful? Yes No