Forum Discussion
Concatenate URL in Power Query
Hi Experts I am trying to concatenate the following URL with the [ID] Column in my table in Poqwer Query https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?ID
Anonymous , In case you are trying to create a new column
New column = "https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" & [ID]
or
New column = Text.Combine({"https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" ,[ID]})
Anonymous , In case you are trying to create a new column
New column = "https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" & [ID]
or
New column = Text.Combine({"https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" ,[ID]})
Hi Amit getting the following error...see images
image 2