Forum Discussion

Ljanssen86's avatar
Ljanssen86
Copper Contributor
Jan 26, 2024

Document library set current user as value for custom person column when uploading file

Hi,    We have a shared document library. To maintain an overview of responsibility for the content stored there, we have added a required custom "owner" column.  We want to have this seperate cus...
Document Library
files
  • mvnair's avatar
    mvnair
    Jan 26, 2024

    Ljanssen86 

    if you want a Person Field for this then you might be able to use a Flow to populate the field when new document is created. 

    Else you can use a Calculated Column and copy the Created By value as default, but it might be a Read-only field.

mvnair's avatar
mvnair
Brass Contributor
Jan 26, 2024

Ljanssen86 

if you want a Person Field for this then you might be able to use a Flow to populate the field when new document is created. 

Else you can use a Calculated Column and copy the Created By value as default, but it might be a Read-only field.

  • Ljanssen86's avatar
    Ljanssen86
    Copper Contributor
    Feb 01, 2024

    mvnair 

    Thank you for the reponse.

    We have been able to fill the column with the created by value. 

    So far this seems to work for files uploaded, but not yet for newly created files. We are still looking into this.

    • mvnair's avatar
      mvnair
      Brass Contributor
      Apr 18, 2024

      Ljanssen86 

      I tried the following json on column formatting of a new Text column to dislay the name of the Created By (or Modified by) and it works on new docs or when you upload.
      You can use $Editor to display Modified By user details.

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

       

       

Resources