download html and test if contains Text RRS feed

  • Question

  • i am trying to iterate over a webpage to return the table data, my html contains "next" if there is a next page to continue, and "next" does not exist if it is the last page

    what is the proper function to return the html of webpage and the proper function to text if contains text?



    Wednesday, January 23, 2019 7:30 PM


  • Hi mtsj. You can use Text.FromBinary(Web.Contents("yourUrlHere")) to get the html source of a web page. If you're using Power BI Desktop, you can also try using Web.BrowserContents("yourUrlHere").

    Once you have the html, you can use Text.Contains(html, "whatever") to determine if it contains a particular piece of text.


    Thursday, January 24, 2019 8:34 PM