Can i update a list item without affecting the Modified By and Modified Date

Question

I have a custom list named WorkOrders inside our SharePoint online tenant. now this custom list contain around 10K items. and i want to do some modifications to existing list items, as follow:-

1- I want to add a new custom column named Media.

2- Based on some calculation from another list i want to update this custom column Media.

but the ModifiedBy and Modified date for the work order items are important to us, and we do not want to affect those 2 fields when updating the new custom column.. so is there a way to update a list item without affecting the Modified By and Modified Date, by using:-

1- SharePoint Rest API

2- Pnp PowerShell

3- Pnp SDK

4- Power Automate

any advice?

Answer 1

Hi @john john Pter

I would recommend you to use manual Power Automate trigger to keep all the system fields the same as previous when you update the list item. You could refer to following steps

https://evolvous.com/learn-from-expert/how-to-modify-sharepoint-item-without-changing-its-default-columns-value/

---

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.