URL Link to a specific Item in a Sharepoint list

[brf10043]

All,

I'm pulling data from a SharePoint list and building a straight table with the data.  In my table I am attempting to use the Title column (S_Idea) column and create a link that opens the specific item in SharePoint from the table.  The unique identifier for each item in the SharePoint list is the ID (S_ID).

Here is what the link looks like in IE.

//https://team.gsk.com/sites/Usability%20Improvements/Lists/Usability%20Improvements/Item/displayifs.a...

Here is what my expression currently looks like

=(S_Idea) & '<URL>https://team.gsk.com/sites/Usability%20Improvements/Lists/Usability%20Improvements/Item/displayifs.a...(S_Id)

In this example I'm trying to display the S_Idea column as the text but when clicked open the URL to the specific item Essentially substitute &ID=105 with &ID='&(S_Id) but this doesn't seem to be working.

[brf10043 · Accepted solution]

I found the answer.  My ID column as not capitalized.  Should have been &(S_ID)