Power Automate Desktop - Web Extraction Part 1 | Price extraction from web page

Поділитися
Вставка
  • Опубліковано 20 вер 2024
  • Extract the data from different elements from the web page and insert it into excel spreadsheet.

КОМЕНТАРІ • 12

  • @gregmichell20
    @gregmichell20 3 роки тому +4

    Great video. The website I'm trying to extract from has multiple pages how do I extract from all?

  • @xuyangzhang8883
    @xuyangzhang8883 3 роки тому +1

    I have a similar question that Greg raised. If the data exists in multiple pages, how do I extract from all, and what can be done in the flow to avoid appending duplicate data?

  • @rayc3253
    @rayc3253 3 роки тому +1

    pretty new to power automate , is it possible to insert the data into a SQL database directly?

  • @DioceseofChesterinEngland
    @DioceseofChesterinEngland 2 роки тому +1

    You don't seem to have answered anyone's questions about extracting data from multiple pages.

  • @04shame
    @04shame Рік тому

    how to know how many rows of table in a website?

  • @maokue2639
    @maokue2639 2 роки тому

    Is it possible to do it with yellow pages and search criteria?

  • @notonurnelly
    @notonurnelly 3 роки тому +1

    It would be great if you could share what you pasted into the CSS Selector at minute 3:12. I have tried Contains("CAD $") and this does not work.

    • @llau0203
      @llau0203 3 роки тому +2

      I have added the following as extra columns:
      a > div:eq(1) > div > div > span:eq(0):contains("CAD $")
      a > div:eq(1) > div > div > span:eq(2):contains("CAD $")
      a > div:eq(1) > div > div > span:eq(2) > span:eq(3):contains("CAD $")
      Then I have used Excel formula to combine them.
      Note: The patterns are not consistent:
      -
      - From
      - From
      Hope this helps.

  • @sherwincervantes1236
    @sherwincervantes1236 3 роки тому

    I have a list of part numbers that I do an inquiry on a website that I regularly update once a month. Is it possible we power automate. In order for me to update the parts I have to type the part numbers and get pricing update.

  • @felipesignorellireis7839
    @felipesignorellireis7839 3 роки тому

    Hi
    I would like an information,
    Doing exactly the same thing that you did, I want
    1) Access a web site that contains password, then go to a specific Page, doing the web recorder, but instead of extract text, I want to take a screeen shot of that Page an then send to my email.
    It's possible?

  • @leejason977
    @leejason977 3 роки тому

    Great. Could you tell me the value of the css selector?

    • @raspranav
      @raspranav 3 роки тому

      Can you please post this question on the Power Automate Desktop forum? powerusers.microsoft.com/t5/Power-Automate-Desktop/bd-p/MPADesktop