Extracting ID, a number into the middle of a text in another column

[swathidp]

I have an url column where I have inserted a generic url and I want to call the ID dynamically from another number in ID column.

I am trying to extract the number from column ID and put it in the middle of url column. I wrote the following and the number is not getting extracted:

#"Added Custom" = Table.AddColumn(#"Added Index", "TestURL", each Text.Combine({"https://companyname-IT/Lists/Project%20Intake%20Request%20Form/DispForm.aspx?ID=","Number.From([ID])","&e=xh1LOA"})),

Please help where am going wrong.

The out put shows this https://company namesharepointfolder-IT/Lists/Project%20Intake%20Request%20Form/DispForm.aspx?ID=Number.From([ID])","&e=xh1LOA instead all I want is

https://companyname-IT/Lists/Project%20Intake%20Request%20Form/DispForm.aspx?ID=25&e=xh1LOA

[onurbmiguel_ · Accepted solution]

hi @swathidp 

Please try : 

= Table.AddColumn(#"Changed Type", "TestURL", each "https://companyname-IT/Lists/Project%20Intake%20Request%20Form/DispForm.aspx?ID=" & Text.From([#"Number.From([ID])"]) & "&e=xh1LOA")

Best regards

Bruno Costa | Power Participant

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍


You can also check out BI4ALL's website and our data solutions!

[swathidp]

This worked but with a little tweak :

#"Added Custom" = Table.AddColumn(#"Added Index", "TestURL", each Text.Combine({"https://company name-IT/Lists/Project%20Intake%20Request%20Form/DispForm.aspx?ID="& Text.From([#"ID"]) & "&e=xh1LOA"})),