Forum Discussion
Calculated URL string not working with Web.BrowserContents in function
We need to get tables from several web pages that are numbered, so we have a function with a parameter named PageNumber, like so: = (PageNumber as text)=>
let
Source = Web.BrowserContents("https...
Well, I would just respectfully advise that you are playing with fire by adding quotes into your text parameters. I understand why you are doing it--to unquote and then requote the url so you can add the parameter to the string.
Instead, put the quotes at the Web.Contents level, where your text parameters can always be entered as "https://www.url.com/?page="&StartPage&""®ion="®ionParam&"/"
Since you are using Text.Replace to get your url parameter, you should just get the Text.BeforeDelimiter, and use "?page=" as your delimiter.
Know what I'm saying?
--Nate