Hyperlink Columns does not allow more than 255?

Tan, Emillieona 7 26 Reputation points
2021-09-03T17:20:22.363+00:00

Hi All, I created a Glossary page for my items on Sharepoint.
When i build the columns that allows me to hyperlink the pages to the content, it would not allow me to do so further 255 words.
How can i do it in a more efficient way?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,140 questions
0 comments
Accepted answer
  1. Echo Du_MSFT 17,136 Reputation points
    2021-09-06T02:10:08.797+00:00

    Hello @Tan, Emillieona 7 ,

    Welcome to Q&A Forum!

    According to my research, the Hyperlink column in a SharePoint list or library have a 255 character limit. You can create a Multi-lines of Text column to solve this problem.

    Please following steps:

    1.Create a Multi-lines of Text column and check "Use enhanced rich text (Rich text with pictures, tables, and hyperlinks)" option.

    129443-a1.png

    2.Edit item and click on the Edit icon next to the column.

    129340-a2.png

    3.On the Edit panel, click on the … icon and select "Add or edit hyperlink"

    129355-a3.png

    4.Enter the URL

    129356-a4.png

    129377-a5.png

    Thanks,
    Echo Du

    =====================================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    3 people found this answer helpful.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tan, Emillieona 7 26 Reputation points
    2021-09-07T07:57:27.25+00:00

    Hi Echo,

    I do have a curious question why do they make 255 for one side and have to go the steps like you mentioned to make the links longer? Why is it not a direct straightforward solution to this?
    Also, the other question is :

    When i make folders in SharePoint and number them 1 to 10 when it hits 10, the 10th folder jumps to the top.
    I will have to number them 0.1 to 10 for it to obey the sequence of 10, 11, 12 thereafter. Is there a better way to rearrange or number them so it will not jump?

    Thank you :)

    1 person found this answer helpful.
  2. Mark Foster 0 Reputation points
    2023-01-18T05:22:04.1233333+00:00

    The sort order is alphabetical. If you want a list from 1 to 10 inclusive, make it 01 to 10 and the sort order will remain correct... until you get beyond 99.

    As for OP - I agree it's silly that a Sharepoint URL is often excessively long (>255 chars) and their hyperlink field is limited to this length. Why limit hyperlink length artificially like this? Or how about defaulting to shorter URL's within Teams and SharePoint filed content so that you can link to it?

    0 comments
  3. Li, Wenxiang 0 Reputation points
    2023-06-19T14:18:13.0633333+00:00

    how can we add this link in Powerapps?

    0 comments
  4. Engineer 0 Reputation points
    2023-06-29T05:25:16.0333333+00:00

    Manuel Gomes has an article to get around this limitation https://manueltgomes.com/microsoft/sharepoint/how-to-create-hyperlink-more-than-255-characters/

    1. Create a new multiline text column
    2. Format the column and pick advanced mode
    3. Copy-paste the following JSON (slight variation of what Manuel suggested)
    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "txtContent": "=if(@currentField != '','Link','')",
  "attributes": {
    "target": "_blank",
    "href": "=@currentField"
  }
}

    The result

    User's image

    0 comments