Refresh list items (not update) using PowerShell script

Question

In SharePoint 2013 List A, I want to refresh value of column A of all items, but I don't want to make new item version when I do refreshing/update.
Column A is calculated column and it is calculating difference in time between Now() and some other date column. So it would display correct value only if user manually edit item.

I found PowerShell script that updates column A, but it will leave new item version, any chance to suggest me how can I modify it so Items won't be updated?

$web = Get-SPWeb http://Server/ListLocation
$list = $web.Lists["ListA"]

foreach ($item in $list.Items)
{
  $item.Update();
}

SPOnline added a SystemUpdate.. Are you the Formulas only for display? Or does its value trigger other Formulas or Workflows? — Danny '365CSI' Engelman
– Danny '365CSI' Engelman, Commented Apr 10, 2017 at 9:24
That column A will later be used for additional calculations. — Danilo
– Danilo, Commented Apr 10, 2017 at 9:27

Gautam Sheth · Accepted Answer · 2017-04-10 09:38:04Z

2

Try below code:

$web = Get-SPWeb http://Server/ListLocation
$list = $web.Lists["ListA"]

foreach ($item in $list.Items)
{
  $item.UpdateOverwriteVersion();
}

Reference - UpdateOverwriteVersion

You can also use:

item.SystemUpdate();

difference -

UpdateOverwriteVersion() - updates the list item without creating a new version, but the Modified and Modified By fields are also updated.

SystemUpdate() - updates the list item without creating a new version,also the fields Modified and Modified By are not updated.

edited Apr 10, 2017 at 9:38

answered Apr 10, 2017 at 9:29

Gautam Sheth

31.1k1 gold badge37 silver badges65 bronze badges

Add a comment |

Stack Exchange Network

Refresh list items (not update) using PowerShell script

1 Answer 1

Your Answer

Linked

Hot Network Questions

Refresh list items (not update) using PowerShell script

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions