Read-only columns in Sharepoint library

FNU LNU Khristina 21 Reputation points
2022-05-06T12:07:01.41+00:00

Is there any way to make a column read only in Sharepoint Library (not in the list)?
I saw articles about list read only columns, but found nothing about library.

Probably it can be done via power automate somehow but I am not sure.
(using Sharepoint online)

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,250 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,801 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,894 questions
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 23,961 Reputation points Microsoft Vendor
    2022-05-09T08:37:56.847+00:00

    Hi @FNU LNU Khristina ,

    It can be set via library settings.
    1, Create a calculated column [read-only1] with caculation based on the column you want to set to be read-only.
    200194-2.png

    2, Go to Advanced settings-->Allow management of content type.
    3, Go to Library settings-->Content Types ,click “Document” .
    200099-3.png

    4, Click “hide1” and Choose “Hiden” ,Then click “OK”.
    200241-4.png

    5, Go to Edit current view ,and show the calculated column [read-only1] instead of the hidden column [hide1] .
    200109-5.png

    This way even if the user go to the quick edit, it cannot edit the column value.
    200110-6.png

    Thanks,
    Yanli Jiang

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

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. FNU LNU Khristina 21 Reputation points
    2022-05-11T08:44:05.993+00:00

    Hello @YanliJiangMSFT-7045,

    Thank you so much for the detailed reply! I have tried these steps and it worked.
    The only question left, is there any way to hide these nulls? So that there will be "-" or just nothing?

    there is null if the hidden column is empty
    there are 2 columns with the same text if we display the hidden column