we have a sharepoint online classic team site. and inside the classic team site, we have a custom list titled "Project Management" which have a custom drop down field named "ProjectStatus", which have 5 values such as; "Active", "In Progress", etc...
now i want to remap the "Project Management" list's items "ProjectStatus", as follow:-
if "ProjectStatus" = "Active" to map it as "Live".
if "ProjectStatus" = "In Progress" to map it as "not completed yet".
so can i run a PnP script to loop through all the list's items and update their statuses according to the above mapping? also not to affect the list items' modified date + modified by?