Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
swathidp
Regular Visitor

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

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

1 ACCEPTED SOLUTION
onurbmiguel_
Super User
Super User

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!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

2 REPLIES 2
onurbmiguel_
Super User
Super User

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!

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


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"})),

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.