Forum Discussion

KevBel's avatar
KevBel
Copper Contributor
Jul 18, 2023
Solved

Displaying DocLib File URL Path in Column

Good day, Using SharePoint Online (modern) and set up a new document library called DOCLIB1.  There are two folders in the library called FOLDER1 and FOLDER2.  FILE1.TXT and FILE2.TXT are located wi...
admin
Document Library
files
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Jul 18, 2023

    Hi KevBel,

    you could apply the following json formatting to your "Path" column

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


    You will get a view like this

    If you don't want the path to your document library to be displayed ("/sites/MyAppPage/CopyLib/" in my example), then use this json

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=replace([$FileRef],'/sites/MyAppPage/CopyLib/','')"
}

     This will look like this

     

    Best Regards,
    Sven

ganeshsanap's avatar
ganeshsanap
MVP
Jul 18, 2023

KevBel You can run a Power automate flow on file creation / update (as per your requirements) and then update the new PATH column from your flow OR use JSON formatting for showing the file path. However, I am not sure if JSON formatting will work in search results page or not (I have to test it from my end).

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources