Unanswered

Web-Scraping controll Price

(0) Share

Report

Posted on by Cassy1

Hello again. I have another issue where I'm not making progress. I have an inventory stored in Excel with the following attributes: Item No., Item Description, Item Cost, Target, Actual, Supplier. Now, my goal is for Power Automate to automatically go to a URL and compare the prices of competitors with the prices in my inventory. If my price for a product is higher or lower, my price should be automatically adjusted. This scenario is entirely fictional, as it is a project for my university. I initially tried it on make.PowerAutomate.com but didn't make any progress there. So, I tried it with the desktop version. I'll attach the current flow as an image. In the next step, I wanted to iterate through my inventory and search for my product in the automatically created Excel file, then compare the prices. Can someone here help me and explain how I can achieve this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Srini007 3,483 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cassy1

I understood that you have an Inventory file where it is stored in Excel, so you are opening a URL and then what step are you doing? Are you looping in excel and typing the Item in the URL which you opened? I see some missing information here

It's better if you can list the steps, so that we can help with the solutioning

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

After you start Excel, you should use Get first free column/row from Excel worksheet to get the range you need to read. Then use Read from Excel worksheet to get your data, using %FirstFreeRow-1% as the end of the range. This will result in a data table called %ExcelData%. You can then use a Loop action to iterate through the table, getting each item and work with it.

Whatever it is that you need to do in the web page itself is something I cannot comment much on, because of the limited info in your post.

I would also recommend switching PAD to English to make it easier to get help and follow our instructions. See here on how to do that: https://youtu.be/l2zpRkUBk0o?si=ox4TXWowOwDDKT0Z

-------------------------------------------------------------------------

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.

Was this reply helpful? Yes No