Remove Hyperlink from Lookup Columns in SharePoint

Problem:
When we add a lookup column to any SharePoint list, it appears with the link to the parent item in SharePoint list views. Quite often, the end-user clicks on the lookup link and edits the parent lookup item by mistake – People get confused about which link to click. So we wanted to remove hyperlinks from lookup columns in SharePoint 2013 list views.

remove lookup hyperlink from sharepoint list view

Here is how you can remove hyperlink from lookup fields out-of-the-box without any coding and customization efforts.

  • Go to your list settings, pick the lookup column. In my case, it’s “Parent Project”. On the “Edit Column” page, select the “Title” field under the “Add a column to show each of these additional fields” Section as highlighted below. sharepoint remove hyperlink lookup field
  • Now, edit your list view, unselect the “Parent Project” field, and select the “Parent Project: Title” field. (You can rename this Title – BTW!)
    remove hyperlink from lookup column
  • Click “OK” to save the view. That’s all! This removes the link from hyperlink columns.
    sharepoint remove hyperlink from lookup

However, in Display form of the list, it still shows link in hyperlink fields, isn’t it? Proceed with the below method to remove hyperlink from lookup column. Although lookup field links can be removed using SharePoint designer-XSLT methods, I prefer this jQuery as its relatively simpler.

Lookup columns are pointing to. link something like “http://Site/***&RootFolder=*”. So, let’s find all Anchor elements of the page with HREF attributes
“&RootFolder=*”. and remove the link of the lookup.

To remove lookup hyperlink from SharePoint list view using jQuery, follow these steps:

  1. Go to your List view page, E.g. http://portal.crescent.com/Lists/ProjectMilestones/AllItems.aspx
  2. Click on Site Settings gear, click on the “Edit Page” menu item
  3. Click on Add a Web Part link shown on the page, Under “Media and Content” choose “Script Editor” and click on the “Add” Button
  4. Click on the “Edit Snippet” link on the Script Editor Web part and place the below code in it and save the page.
    sharepoint 2013 remove hyperlink from lookup column
<script type="text/javascript" src="https://code.jquery.com/jquery-1.2.6.min.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $('a[href*="RootFolder=*"]').each(function(index) {
            var link = $(this);
            $(this).after("<span>" + link.text() + "</span>");
            $(this).remove();
        });
    });
</script>
To remove Hyperlink from Person or group fields using jQuery, Just replace the Line#4 with:
$('a[href*="userdisp.aspx?ID="]').each(function(index) { 

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

8 thoughts on “Remove Hyperlink from Lookup Columns in SharePoint

  • May 17, 2021 at 2:39 PM

    Worked great! Muchas Gracias

    Reply
  • November 10, 2020 at 8:15 PM

    Could this be updated for Modern Lists with JSON Formatting?

    Reply
  • May 26, 2020 at 4:21 PM

    Is there any way to drop the link so when the original lookup source is deleted, it will stay in the lookup field?

    Reply
  • March 30, 2020 at 1:11 PM

    Thanks for this. I tried to use it on my SharePoint 2019 classic site and while it did remove the links to the person columns as I was hoping for, it also removed the ITEMS and LIST ribbon tabs. Any thoughts on how to just get the person column?

    Thanks!

    Reply
  • October 28, 2019 at 3:00 PM

    The first example worked perfectly for me. Thank you!

    Reply
  • January 16, 2017 at 9:09 AM

    Hi,
    Thanks for your solution, but your solution remove any hyperlink like as Title, any why exist that can exclude some column?

    Reply
    • January 18, 2017 at 4:12 PM

      Thanks for your Solution, but I add LinkToItem=”TRUE” for column that want to hyperlink to view Item, unfortunately disable this hyperlink after your script, can you help me?

      Reply

Leave a Reply