question

FNULNUKhristina-8658 avatar image
0 Votes"
FNULNUKhristina-8658 asked YanliJiangMSFT-7045 commented

Read-only columns in Sharepoint library

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)

office-sharepoint-onlineoffice-sharepoint-server-administrationsharepoint-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FNULNUKhristina-8658 ,
Thanks for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

0 Votes 0 ·
YanliJiangMSFT-7045 avatar image
0 Votes"
YanliJiangMSFT-7045 answered

Hi @FNULNUKhristina-8658 ,

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.














2.png (49.4 KiB)
3.png (11.2 KiB)
4.png (36.3 KiB)
5.png (22.8 KiB)
6.png (21.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FNULNUKhristina-8658 avatar image
0 Votes"
FNULNUKhristina-8658 answered YanliJiangMSFT-7045 commented

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


[1]: /answers/storage/attachments/200845-01.png


01.png (32.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FNULNUKhristina-8658 ,
It also can be set via library settings.
1, Go to Library settings-->Content Types ,click “Document” .Click “hide1” and Choose “Optional” ,Then click “OK”.
2,Then create a calculated column [read-only2] with caculation based on [hide1].But the formula is :
=IF([hide1]="","-",[hide1]). or =IF([hide1]="","NULL",[hide1]).
201511-7.png

3,Then do steps 3-5 in my previous answer.
201463-8.png

Regards,
Yanli Jiang












0 Votes 0 ·
7.png (60.9 KiB)
8.png (12.0 KiB)