web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Grabbing Prices From A...
Power Automate
Unanswered

Grabbing Prices From Aliexpress

(0) ShareShare
ReportReport
Posted on by 17

Hello,

 

i am trying to grab the prices from aliexpress but the span:eq(%CurrentItem['Variable1']%)  does not work. (Click link on web page or button does not work)

 

i use an excel with currenitem selection and headers which one of is Variable1.

 

site to get prices from are also in the excel. (TestPrice)

 

i need the prices from all variants

  • Highboy Profile Picture
    1,187 Super User 2024 Season 1 on at

    Just out of curiosity, why are you using OCR?
    Could you send a link to one of the pages you are trying to grab a price from?

  • Jochem Profile Picture
    17 on at

    Hello,

     

    OCR is one of the fallback clicking methodes (which surely finds some word, but mostly the wrong one), there is also a click if the variant is a imagetype and a click if the variant is a Texttype.

     

    and that twice as there can be 2 variants at a time

     

    the links and what prices to get can differ depending if ali has an sale. all links can be found in attached excel

  • Highboy Profile Picture
    1,187 Super User 2024 Season 1 on at

    I am not quite sure what you are trying to do, are you trying to scrape the price from every page, that are listed in the excel sheet, (Lots of the are identical) and write the price in "Price1" H column?. Easy task, but loading each page takes quite a long time, so more than a few 100 links, and you will be running the process forever.😊


    Highboy_0-1674925972271.png

     

  • Jochem Profile Picture
    17 on at

    Hello,

     

    that is exactly what i am trying to do. as you can see in the excel there are links with all the different variants. this is how i split it up and make Power Automate Desktop look it up and scrape the prices.

     

    issues is the Text based button for the variants do not work. and there are somethings multiple variants.

     

    if you have a better idea please let me know.

  • Jochem Profile Picture
    17 on at

    i would take any advise, because like you say. it is A LOT of work. hence i am looking to automate it.

  • momlo Profile Picture
    1,527 Super User 2024 Season 1 on at

    My advice may sound weird, but it might work for you (I took this approach once, and it did reduce the 1-item processing time from 15s to 3s 😄 - identical thing - get a list of items, go to the page, grab 30tish parameters).

     

    And the advice is... turn off JS on the page.

    Instead of opening the page, open the page source in the tab, use UI automation to send ctr-a + ctr+c, grab source code from the clipboard, and parse it with regex to get the values you need  🙂

    You need to use UI automation to get the text because as soon as you disable JS on that page, you are disabling the PAD extension on the page (just that page, if you disabled JS for a single page).

     

    This approach will work if values you are interested in are present in the source, and you can identify patterns and write regex or them. Speed boost guaranteed 😄

     

  • Jochem Profile Picture
    17 on at

    Hallo Momlo,

     

    thank you for your suggestions, but i am not familiar enough with what you mean. can you please explain it a bit more detailed.

     

    sorry :S

  • Jochem Profile Picture
    17 on at

    i still do not understand it, i tried looking into it. i found a spot but a bunch of information like prices/variant.  but how do i make it consistant enough so i can easily fill in my Excel with the correct prices

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 249 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 202

#3
David_MA Profile Picture

David_MA 180 Super User 2026 Season 2

Last 30 days Overall leaderboard