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...
Ehren
Microsoft Employee
Microsoft EmployeeIn your function, you have an M expression that will dynamically concatenate the URL with the page number.
Your second example is generating a text value. It's not an M expression, and thus won't be dynamically evaluated.
To illustrate the difference, try evaluating the following two expressions in the formula bar of a blank query:
= 1 + 1
vs.
= "1 + 1"
These may look the same, but they're actually completely different. The first one is an addition expression. The second one is a text value that contains the text of an M addition expression.