Forum Discussion
Change the value of Built-in columns Modified and Modified by
danbmunoz These are SharePoint default columns which cannot be changed using SharePoint user interface.
But, you can update it easily using PnP PowerShell like:
Set-PnPListItem -List "My List" -Identity 1 -Values @{"Editor"="email address removed for privacy reasons"} -UpdateType UpdateOverwriteVersionAlso, going forward whoever will be adding new list items will be shown in Created By (Author) column and the user who modifies the list item will be shown in Modified By (Editor) column automatically in the list when they will start using it.
Author and Editor are internal names of Created By and Modified By fields respectively. Those are required to use in the PnP PowerShell for changing values.
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.
danbmunoz These are SharePoint default columns which cannot be changed using SharePoint user interface.
But, you can update it easily using PnP PowerShell like:
Set-PnPListItem -List "My List" -Identity 1 -Values @{"Editor"="email address removed for privacy reasons"} -UpdateType UpdateOverwriteVersion
Also, going forward whoever will be adding new list items will be shown in Created By (Author) column and the user who modifies the list item will be shown in Modified By (Editor) column automatically in the list when they will start using it.
Author and Editor are internal names of Created By and Modified By fields respectively. Those are required to use in the PnP PowerShell for changing values.
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 okay so that PS command helps cleaning the modified by, column. How can I accomplish the same with Modified ( date and time )
thank you for your reply
danbmunoz Try using this:
Set-PnPListItem -List "My List" -Identity 1 -Values @{"Editor"="<email address>"; "Modified"="2023-05-26T10:44:00"} -UpdateType UpdateOverwriteVersionPlease 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.
- I was wondering if there is a way to "clean" it. The PS cmdlets worked but I want to clean the date and time and make it look like: " - " or something like that so it looks cleaner when demoing
