Forum Discussion
Customise library column to be link
To get the File name without extension you can use:
substring([$FileLeafRef], 0, lastIndexOf('[$FileLeafRef]', '.'))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.
Of course! Didnt think of it in that way!
Your code is almost perfect - the only issue is that I need the Name of the file from SP not the file name with extention - ie I need FileName not FileName.docx
To get the File name without extension you can use:
substring([$FileLeafRef], 0, lastIndexOf('[$FileLeafRef]', '.'))
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.
ganeshsanap Thanks again - that's perfect
Does this mean you cant reference other column when configuring a column?
- Just tested and i can just ref by $fieldname! 🙂 But Name doesnt work - i presume it has a different name under the hood?
In JSON formatting, you have to use the internal name of columns. Display name which you see in list/list views will not work in JSON.
For more information about supported column types you can refer: JSON Formatting - Supported column types
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs