Update List items in sharepoint online without updating MOdified By and Modified Date information

Question

Update List items in sharepoint online without updating MOdified By and Modified Date information

Deepak Trivedi 0

I wanted to update list items in sharepoint online without updating their Modified date and Modified by columns is it possible?

Either these two column should not be updated or they should be updated with previous values.

Thanks in advance.

2 answers

Your answer

Answer 1

You can do it. At least I'm doing it now ;-)

It can be done via SharePoint PI v.1.0
You can make a post request to next url:

https://site.sharepoint.com/sites/site-id/_api/web/Lists/GetByTitle('List_Name')/items(Item_Id)/validateUpdateListItem

with headers

Accept: application/json; odata=verbose
Content-Type: application/json; odata=verbose

and body

{    
  "formValues":[       
    {          
      "FieldName":"Author",          
      "FieldValue":"[{'Key':'i:0#.f|membership|_user_id_'}]"       
    },       
    {          
      "FieldName":"Editor",          
      "FieldValue":"[{'Key':'i:0#.f|membership|_user_id_'}]"       
    },       
    {          
      "FieldName":"Modified",          
      "FieldValue":"2023-07-20 15:22:34"       
    }    
  ],    
  "bNewDocumentUpdate":true 
}

I use it to fix the Author and Editor of items in a list, which was uploaded by "technical" user, to replace it by appropriate "real" user. Via cloud flow.

Answer 2

Emily Du-MSFT 51,851 Microsoft External Staff

Modified and Modified by columns are used to record when and who modified items.

In the SharePoint mechanism, it is designed and established. There is no possibility to update list items in SharePoint Online without updating their Modified and Modified by columns.

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.

Emily Du-MSFT 51,851 Reputation points Microsoft External Staff

2023-08-14T02:49:42.43+00:00

Would you have a chance to check the above information?

If anything is unclear with the above information, please don't hesitate to let me know.

I am glad to be of assistance.
Deepak Trivedi 0 Reputation points

2023-08-14T04:41:59.7466667+00:00

In the sharepoint server object model there were an option system.update() was available which allow to update these ootb column values as well any such option not available in sharepoint online in SPFx PnP, RestAPI, GraphAPI etc?
Emily Du-MSFT 51,851 Reputation points Microsoft External Staff

2023-08-14T06:09:57.7833333+00:00
You could use PnP PowerShell to change values of Modified and Modified By columns. But this modification is timely. After modifying with PowerShell, if items are modified again, the system will automatically update Modified and Modified By columns according to the modification person and modification time.

Example PnP PowerShell:

$SiteURL= "https://tenant.sharepoint.com/sites/emilytest" $ListName = "listname" $ItemID = "1" $Modified = "2023-08-10T10:30:00-00:00" $ModifiedBy= "******@tenant.onmicrosoft.com" Connect-PnPOnline -Url $SiteURL -Interactive Set-PnPListItem -List $ListName -Identity $ItemID -Values @{"Modified"=$Modified; "Editor"= $ModifiedBy}
Deepak Trivedi 0 Reputation points

2023-08-14T11:48:09.95+00:00

Set-PnPListItem: Attempted to perform an unauthorized operation.

getting this message while trying to execute above PS scrit.
Deepak Trivedi 0 Reputation points

2023-08-14T11:49:50.9133333+00:00

Set-PnPListItem: Attempted to perform an unauthorized operation.

this is response when trying to execute above code.

Emily Du-MSFT 51,851 Microsoft External Staff

Have you received this error when running PnP PowerShell before?

1.Update PnP PowerShell to latest version.

2.To grant the tenant access to the PnP Management Shell Multi-Tenant Azure AD Application, run Register-PnPManagementShellAccess by using global admin account. Need to click "Consent on behalf of your organization".

User's image

3.Try to run following PnP PowerShell by using site admin account.

$SiteURL= "https://tenant.sharepoint.com/sites/emilytest" 
$ListName = "listname" 
$ItemID = "1" 

$UserName="******@tenant.onmicrosoft.com"
$Password = "password"

$Modified = "2023-08-10T10:30:00-00:00" 
$ModifiedBy= "******@tenant.onmicrosoft.com" 

$SecurePassword = ConvertTo-SecureString -String $Password -AsPlainText -Force
$Cred = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $UserName, $SecurePassword

Connect-PnPOnline -Url $SiteURL -Credentials $Cred
Set-PnPListItem -List $ListName -Identity $ItemID -Values @{"Modified"=$Modified; "Editor"= $ModifiedBy}

Emily Du-MSFT 51,851 Reputation points Microsoft External Staff

2023-08-29T10:15:55.1433333+00:00

I'm checking how the things are going on about this issue.

I would appreciate it if you would like to share a recent update this issue.

Share via

Update List items in sharepoint online without updating MOdified By and Modified Date information

2 answers

Your answer