Forum Discussion
Solved
Generating Table from Website
Hi MS Fabric Community, I am having trouble generating a table from the contact list found at the bottom porition of this URL: https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 ...
let Source = Web.BrowserContents("https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 "), #"Extracted Table From Html" = Html.Table(Source, {{"Tribe", ".card-title *"}, {"Region", ".gz-cat"}, {"Address", ".gz-fa-map-marker-alt + *"}, {"Place", "[itemprop=""addressLocality""]"},{"State", "[itemprop=""addressRegion""]"}, {"ZIP Code", "[itemprop=""postalCode""]"}, {"Phone", "[itemprop=""telephone""]"},{"Web", ".gz-card-website > a", each [Attributes][href]}}, [RowSelector=".gz-list-col"]) in #"Extracted Table From Html"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.
Well done. Thank you
lbendlin
Super User
Super User
let
Source = Web.BrowserContents("https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 "),
#"Extracted Table From Html" = Html.Table(Source, {{"Tribe", ".card-title *"}, {"Region", ".gz-cat"}, {"Address", ".gz-fa-map-marker-alt + *"}, {"Place", "[itemprop=""addressLocality""]"},{"State", "[itemprop=""addressRegion""]"}, {"ZIP Code", "[itemprop=""postalCode""]"}, {"Phone", "[itemprop=""telephone""]"},{"Web", ".gz-card-website > a", each [Attributes][href]}}, [RowSelector=".gz-list-col"])
in
#"Extracted Table From Html"
How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.
Well done. Thank you