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.
