Power Platform Community Forum Thread Details

Expression.Error: 7 arguments were passed to a function which expects between 1 and 2. Details: Pattern= Arguments=[List]

I am trying to pull in stock ticker data from google.com/finance for different stocks and have gotten the error -

"Expression.Error: 7 arguments were passed to a function which expects between 1 and 2. Details: Pattern= Arguments=[List]"

My current query is the following -

let
Source = Web.BrowserContents("https://www.google.com/finance/quote/DAL:NYSE", "https://www.google.com/finance/quote/NI:NYSE", "https://www.google.com/finance/quote/DG:NYSE", "https://www.google.com/finance/quote/MSFT:NASDAQ", "https://www.google.com/finance/quote/BBY:NYSE", "https://www.google.com/finance/quote/GOOG:NASDAQ"),
#"Extracted Table From Html" = Html.Table(Source, {{"Ticker", ".PdOqHc"}, {"Price", "[jsname=""LXPcOd""]"}, {"Amount Change", ".ZYVHBb"}, {"Prev Close", ".gyFHrc:nth-last-child(9) > .P6K39c"}}, [RowSelector=".PdOqHc"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Ticker", type text}, {"Price", type text}, {"Amount Change", type text}, {"Prev Close", type text}})
in
#"Changed Type"

I believe the issue stems from having multiple web browser contents, but not sure how else to pull in multiple stocks. Thanks in advance

Quick Links

Leaderboard > Power Apps - Power Query