How to update the list items without changing the modified by values.

We written a PowerShell script instead of doing manual work, we can do it easily while spending little bit time J

We want to update a field value in a particular list for all items based on the condition, without affecting the modified by and created by values.

$web = Get-SPWeb http://dotnetsharepoint.com/sites/sharepoint2013

$list = $web.lists["Your List Name"]

#Geting  all items in particular list and save them to a variable

$items = $list.items

#Go through all current list items

foreach($item in $items)

{

#If the "CurrentStatus" column value equals "NO"

if($item["CurrentStatus"] -eq "NO")

{

#Change the value of the "CurrentStatus" column to “YES”

$item["CurrentStatus"] = "YES"

$modifiedBy = $item["Editor"]

$modifieddate = $item["Modified"]

$item["Editor"] = $modifiedBy

$item["Modified"] = $modifieddate

$item.Update()

$list.Update()

$web.Dispose()

}

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

Hide the SharePoint list column in “New from” using PowerShell

In this example we want to hide the column in the "NewForm.aspx" page, we are hiding the “hide column” using the below Power Shell script.

#Get the site that you want to access the list

$webUrl = Get-SPWeb http://dotnetsharepoint/sites/sharepoint/

#Get the list name

$listname = $webUrl.Lists["DemoHideColumn"]

#Get the Column that you want to hide

$columnName = $listname.Fields["HideColumn"]

# hide the column from New Form using the ShowInNewForm property

$columnName.ShowInNewForm=$false

#if you want to show it again change to $true

$columnName.Update()

$listname.Update()

$webUrl.Dispose()

After completing the Power Shell we can get the Output as shown below in the NewForm.apsx.

Read More»

Export user list from SharePoint groups using PowerShell script

 We can get all users from all groups in SharePoint using below script. Using the below script we can get sub rooms users also.

  

Add-PsSnapin Microsoft.SharePoint.PowerShell

$URL= "https://Dotnetsharepoint.com"

     $site = Get-SPSite $URL

   

     #Write the Header to "Tab Separated Text File"

        "Site Name `t Group Name `t User Name “| out-file "D:\SPUsersList.xslx"

       

     #Iterate through all Webs (All Sub rooms)

      foreach ($web in $site.AllWebs)

      {

        #Write the Header to "Tab Separated Text File"

        "$($web.title) `t" | out-file "D:\SPUsersList.xslx" -append

         #Get all Groups  

         foreach ($group in $Web.groups)

         {

                "`t `t $($Group.Name)" | out-file "D:\SPUsersList.xslx" -append

             

                        foreach ($user in $group.users)

                        {

                           #Exclude Built-in User Accounts                            

                                "`t `t `t $($user.name)" | out-file "D:\SPUsersList.xslx" -append

                        }

         }

     }

    write-host "Report Generated at D:\SPUsersList.xlsx"

Read More»