Link to display item in SharePoint online list

[misty]

I need the Title field to link back to the individual item (displayItem) in my SharePoint list.  I have created a custom column with the following but it sees the [Id] as a string if within the quotes but outside the quotes if I use &[Id] it throws an error.

"https://[SharePointTenant]/sites/BusinessDev/Lists/BDPipeline/DispForm.aspx?ID=[Id]"

"https://[SharePointTenant]/sites/BusinessDev/Lists/BDPipeline/DispForm.aspx?ID="&[Id]

What else can be done?  I don't see the field Link to Edit Item in Power Query or anything else I could use.

I have been struggling with this for two days.  Any help is very much appreciated.

[mwegener]

Hi @misty ,

take a look at.

CONCATENATE

https://docs.microsoft.com/en-us/dax/concatenate-function-dax

and

FORMAT

https://docs.microsoft.com/en-us/dax/format-function-dax

[misty]

Thank you.  I cannot concatenate text and a number.  When I try to change the Id field to text, it reverts back to a number.

[misty]

@mwegener Thanks!  I used the & concatenate in a custom column.  The issue is that the Id field is a datatype number.  When I switched it to text then went back to the Added Custom in Applied Steps it reverted to datatype number.  I know that it does that just tired.  I created a new custom column after the ChangedType2 with the following:

"https://[SharePointTenant]/sites/BusinessDev/Lists/BDPipeline/DispForm.aspx?ID="&[Id]

Works like a charm!