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 / New webflow from speci...
Power Automate
Answered

New webflow from specific website not able to extract data

(0) ShareShare
ReportReport
Posted on by 117

Hello Guys, 

 

Is someone able to build up a flow that can extract all the contacts informations listed in all the companies of this website?

i canno't find the right selector to grab it

https://www.energaia.fr/visiter/liste-des-exposants/

thanks for helping, 

 

regards, 

 

Fred

I have the same question (0)
  • PAuserFromFranc Profile Picture
    117 on at

    @VJR @Henri @Henrik_M @Ankesh_49 

    Hi Team, requesting your help to manage selector and build this flow i'm asking for...

    May you help please?

    thx fred

  • AS-06081019-0 Profile Picture
    1,738 Super User 2024 Season 1 on at

    @PAuserFromFranc   Could you please share the flow you have developed? which selector are you using?

  • PAuserFromFranc Profile Picture
    117 on at

    @Ankesh_49 at the moment nothing but i want to grab information from 

    https://www.energaia.fr/visiter/liste-des-exposants/

    for each company name found in the table, then open the little down arrow and get name, phone, email, adress and field of activity for thoses companies and also for each page (we need also pagination)

    Usually i know how to do it but i can't here normally selector would be : 

    body > main > section > div > div > form > div:eq(3) > table > tr.odd:nth-child(1) > td:nth-child(1) > span:nth-child(2)

    something like this with attribute like tr[Class="odd"]

     

  • Pavel_NaNoi Profile Picture
    1,074 on at

    From my limited research on this, most I can tell you is that you'll need to run a javascript in order for this to work on the webpage. Why? well because the company information is not actually on the webpage, but rather an imbued document, an iframe. Thus to access it you need to run javascript that can somehow switch the CSS selector from the main page to this iframe of the imbued document. I have honestly no idea how to do that and I hope someone more well versed in this will come along to help out with this.

  • Pavel_NaNoi Profile Picture
    1,074 on at

    Figured it out, do the following:

    -Launch the webpage

    -Use Extract data from web page

    -In the advanced options write the following css selector - > "iframe:eq(0)" with the following attribute "src"

    this will get you the html link of the iframe, now simply launch a new chrome instance with that link and from there you can extract everything as normal.

     

    Enjoy.

  • PAuserFromFranc Profile Picture
    117 on at

    @Ankesh_49 @Pavel_NaNoi 

    thank you i could step a bit but i'm still stuck with a javascript to execute to open the little arrow and get the datas

    PAuserFromFranc_0-1664476023464.png

     

  • Pavel_NaNoi Profile Picture
    1,074 on at

    Shouldn't need javascript for that, does extract data from webpage not work?

  • Pavel_NaNoi Profile Picture
    1,074 on at

    Alright, I can see now why you were struggling on that extraction part, got some good news and some bad news,

    Good news, I made an automation that does what you want, opens the arrow, extracts text and moves to the next.

    Bad news? its 1 minute 30 seconds per page (in 1ms delay debug mode)

     

    I don't see a way of improving that time other than maybe just using an API call method or something (I have no idea how to do that don't even ask)

     

    However if you want this automation, private message me (just click my profile, should see the button on the right), I'll send it over to you, it will need some editing from your end though.

    In summary it does the following:

    - Creates a new Datatable 

    - Gets the number of pages to go through

    - Creates a loop based on the number of pages

    - Extracts arrows count on page

    - Goes through each arrow, extracting specific text (can be edited to extract w/e)

    - Puts that information into the Datatable (will need editing if the above is changed)

    - Once done, moves to next page and repeat till finished.

  • Henrik_M Profile Picture
    2,021 Super User 2024 Season 1 on at

    Step one should be to enter the iframe directly:  https://exposants.energaia.fr/form/liste_exposant&lang=fr&session=EN22&langue_id=1 

    Henrik_M_0-1664552145732.png

     

    I thought about the program in my head, and it should be possible. I'll see if I have time to make it during the weekend, then I can share.

  • PAuserFromFranc Profile Picture
    117 on at

    Enter the iframe, i did but the rest...i'm stuck, thanks again @Henrik_M 

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 468

#2
Haque Profile Picture

Haque 370

#3
Valantis Profile Picture

Valantis 354

Last 30 days Overall leaderboard