How do I get the path of where a file is saved to show as a column in Sharepoint?

Question

How do I get the path of where a file is saved to show as a column in Sharepoint?

JRader 25

If I want to find the location where a file is saved in sharepoint, I have to select the 3 dots to the right of the file name, select Details, and scroll to the very bottom of the side menu to see the path. Is there any way to add a column that will automatically show that path, similar to how you can see when the file was created or modified?

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Emily Du-MSFT 51,996 Microsoft External Staff

Here is a workaround, create a single line of text column and use following JSON codes to show file path.

Select the column -> Column settings -> Format the column -> Advanced mode -> Use codes.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "='https://tenant.sharepoint.com'+[$FileRef]"
}

enter image description here

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.

JRader 25 Reputation points

2024-08-19T17:33:58.7633333+00:00

IT WORKED! Thank you so much!
Sébastien Dos-Santos 0 Reputation points

2024-11-04T10:08:25.24+00:00
hi there, solution seems cool but does not work here, maybe we don't have same interface in french. when i click on "add a coolumn" > "single line txt" > then i have a column "create a column" with Name, description, Type, default value, more options
Can't find ou where and how to paste the code; because in adcanves mode (more options) i got :

max number of caracters etc. see the image i loaded.
Would save me cause the location issue is a mess (so simple though, cf google drive...).
Sébastien Dos-Santos 0 Reputation points

2024-11-04T10:09:15.7766667+00:00

here it is
Jason Ross 0 Reputation points

2026-04-07T20:03:37.52+00:00

Thanks!

They hid that about as deep as humanly possible. How absurd.

2 additional answers

JRader 25 Reputation points

2024-08-19T17:33:58.7633333+00:00

IT WORKED! Thank you so much!
Sébastien Dos-Santos 0 Reputation points

2024-11-04T10:08:25.24+00:00

hi there, solution seems cool but does not work here, maybe we don't have same interface in french. when i click on "add a coolumn" > "single line txt" > then i have a column "create a column" with Name, description, Type, default value, more options
Can't find ou where and how to paste the code; because in adcanves mode (more options) i got :

max number of caracters etc. see the image i loaded.
Would save me cause the location issue is a mess (so simple though, cf google drive...).
Sébastien Dos-Santos 0 Reputation points

2024-11-04T10:09:15.7766667+00:00

here it is
Jason Ross 0 Reputation points

2026-04-07T20:03:37.52+00:00

Thanks!

They hid that about as deep as humanly possible. How absurd.

Answer 1

Jek 0

User's image

After you create a new column, you need to go to Column settings, then Format this column, where you can find the Advance option to can paste the JSON

0 comments

Answer 2

For Website owners, adding a column over the Library settings is possible. Gear Symbol in the top Document folder, Library settings, additional settings, create column, JSON text in the format field, colum name required too. Using [$FileDirRef] instead of [$FileRef] leaves out the name of the file.

User's image

Worked for finding the path of files that are opened through the library search even when the standard path metadata does not show the full path! Worked on the documents present at the time of column creation, must update the Metadata on opening.

User's image