3

I have a list of 8 items in SharePoint 2010 and I export them to Excel. How can I export item's URL so that when clicking the link on Excel spreadsheet, it can bring me back to the item in SharePoint?

2

You can't do it directly , but you can do the following workaround

  • At your list View , Make sure that it contains the ID of the item.

enter image description here

enter image description here

  • After you export your list from the ribbon .
  • Open excel sheet > and at any column beside your row.
  • Add this formula.
 =HYPERLINK("https://yourrootsite/Lists/List/DispForm.aspx?ID="&A2,Table_owssvr__2[Title])
  • the output should be like Direct Linkable link with a meanning name that is the title of item

enter image description here

  • Drag your column down to apply it to all rows Via +
  • Thanks everyone i was able to solve this with a workflow< – djgibbs Sep 15 '16 at 2:36
  • This is a beautiful answer. It may not have been what the OP wanted, but it worked perfectly for me. Thank you! – tfrederick74656 Sep 8 '17 at 13:20
0

You can add a new calculated field to the list and use formula

=CONCATENATE("http://siteurl/lists/listname/forms/displayform.aspx?ID=", Id)

Change siteurl and listname

Now going forward you can simply export the list and no need to update excel file each time.

  • Thankyou ! It would be great if i could to that. Ill try it! – djgibbs Sep 4 '16 at 16:19
  • Can you elaborate more? – djgibbs Sep 4 '16 at 16:21
  • From List Settings add a new column and select calculated.. Next use the formula I have provided. – Amal Hashim Sep 4 '16 at 16:22
  • Ok ill try this method then ill let you know. Thankyou again for your help! – djgibbs Sep 4 '16 at 16:23
  • Is the return value of the field single text? I tried on my dev box and its working as expected. – Amal Hashim Sep 4 '16 at 18:02
0

Thanks everyone i was able to solve this with a workflow. I created a new column called Link. Then in the workflow, I use 3 variables which i called (Url, Link and LinkwithURL). In my workflow i use Set Variable URL at the value of http://siteurl/lists/listname/_layouts/FormServer.aspx?XmlLocation=/list/listname[%CurrentItem:yourcolumn%].xml&DefaultItemOpen=1 then set the value of LinkWithUrl at (The colomn i what to get as link) Set the value of LinkWithURL at Variable URL,Variable Link then Set the value of Lien which my new column with the value of LinkwithURl . thats it -----------------

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.