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

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

group by more than 2 columns sharepoint 2013

In this article we will explain, how to create multi level group by more than two columns.
We are having a list with name “RajamouliFilmography”, now we want to create multi-level hierarchy “Group By “with more than 2 levels.

In OOTB it’s not possible to create more than 2 levels of Group by, but using SP Designer we can achieve this functionally.


Open the Site in SharePoint Designer

Click on Site Pages->In the Top click on web part page->select any page layout ->Enter the Page name.

Now click on the Page->Edit the file.
We placed the cursor inside the Zone Template, but Data View is in disabled.
In SharePoint 2013 we cannot add the Data View directly.
To enable Data View we have to convert the page in to HTML, for that click on the Parse HTML as shown in the below screen shot.
Again navigate to INSERT tab, there we can able to see the Data View is enabled stage, place the cursor inside the Zone Template, and click on Empty Data View.
Once we added the Empty Data View, in-between the Data Sources tag add the List.
Once we added the list, in the right hand we can able to see the Data Source Details.
Press Ctrl tab and select the columns that you want to give Group By, then click on Insert Selected Fields ->Click on Multiple Item View.
In the Option Tab Click on Sort & Group, it will pop a window, there we have to select the Fields and click on add that you want to give Group by
We added the fields in an order that we want to create group by Year, Film, and Hero Name, Select the Check box option for all the fields Show group header.
Click on Ok.
Save the page and then click on preview browser.
Now we can able to see the more than 2 levels of hierarchy structure.



Please let me know if anyone having quires on this article.

SharePoint Online  Training Contact: sharepointtraining@dotnetsharepoint.com

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.


Could not find file 'C: \Users\SharePoint\AppData\Local\Temp\374d35h38-f654-gf66-463f-gg17a0d453hh\ExportSettings.xml

Could not find file 'C: \Users\SharePoint\AppData\Local\Temp\374d35h38-f654-gf66-463f-gg17a0d453hh\ExportSettings.xml
We take the backup of site in one server using.

Export-SPWeb http://dotnetsharepoint.com/sites/dotnet/dotnetsharepoint/ –Path "C:\DotNetSharePoint.cmp" –includeusersecurity

Example:

DotNetSharePoint.cmp
DotNetSharePoint1.cmp
DotNetSharePoint2.cmp

  We copied the .cmp file to other server and tried to Import  using the below command.

Import-SPWeb http://dotnetsharepoint.com/sites/dotnet/sharepoint/ -Path "C:\DotNetSharePoint.cmp"  -IncludeUserSecurity -Force

While trying to Import we got this error.

“Could not find file 'C;\Users\SharePoint\AppData\Local\Temp\374d35h38-f654-gf66-463f-gg17a0d453hh\ExportSettings.xml”

Root Cause of this Issue in my case: We missed one .CMP file while copying one server to another Server.

DotNetSharePoint.cmp
DotNetSharePoint1.cmp


Finally after copying all 3 files it is working without any issues.

How to get the field guid using PowerShell

How to get the field guid using PowerShell
Using PowerShell we can get the field guid easily in our SharePoint.

# to get the site that you want to hide the column


#Get the list you want to access
$listname = $web.Lists["YourListName"]

#Get the field that you want to get guid
$ListCol = $listname.Fields["YourFieldName"]
Write-host "List column GUID is:"$ListCol.id


Run the Power shell script in the Management Console, Hit Enter we can easily get the output.

Remove user from site collection and its sub sites.

Remove user from site collection and its sub sites.
Sometimes we have to remove user/users from inside the group or outside of the group from the site collection and its sub sites, even if the list and site having unique permissions we can delete users easily without Power Shell.

.We can achieve this using GUI

Navigate to site settings
Click on Site permissions->click on any SharePoint group
In the top URL we can able to see like this
For every group having having a unique id.
change the 85 to 0 in the URL, it  will display all the users, select the check box that you want to delete.
 In the tool bar we can able to see the Actions,clink on the actions ->click on delete users from site collection.

It will remove the users form site collection, sites and sub sites.

Blocked file is not migrated to SharePoint

While doing the migration from lotus notes to SharePoint, we got an error and warning in the log file with “Blocked file is not migrated to SharePoint id = “” name=”” size =”” “.

Causing of this issue is we need to remove the file extension block file in the tool and we need to change the file Size limit in the tool as shown in the below screen shot.
        1)Navigate to “Migrator Notes to SharePoint”->right click and click on “Advanced configuration Options” there click on SharePoint tab as shown below.
If we want to keep any file limit means we have to mention otherwise for no limit use "o or blank".

      2)  In the blocked file extensions, we can remove the file type if you want to migrate.

Once all done, migrate next time we won’t get this type of warning or error “Blocked file is not migrated to SharePoint”.


Block and unblock of attachment types in SharePoint

  In SharePoint by default few attachments are blocked and will not be allowed to be uploaded.
 If we want to allow uploading of blocked file type then we need to delete the file type from "Blocked file types".
Follow the below simple steps to allow block file types into your site in SharePoint.
  Navigate to Central Administration->Manage Web Applications->select desired web application->Blocked file types as show in figure below


And in the below window, remove the undesired file types from the blocked file types. You will now be able to add that file to your site.
Also you can add any file type extension you don’t desire to be uploaded. Just type the extension of file type you want to block in braces. Ex: if you want to block word document then type {.doc} in separate line in below window and click ok.



File types Extensions blocked by default in SharePoint 2013 are:

  • .ade
  • .adp
  • .app
  • .asa
  • .ashx
  • .asmx
  • .asp
  • .bas
  • .bat
  • .cdx
  • .cer
  • .chm
  • .class
  • .cmd
  • .cnt
  • .com
  • .config
  • .cpl
  • .crt
  • .csh
  • .der
  • .dll
  • .exe
  • .fxp
  • .gadget
  • .grp
  • .hlp
  • .hta
  • .htr
  • .htw
  • .ida
  • .idc
  • .idq
  • .ins
  • .isp
  • .its
  • .jse
  • .json
  • .ksh
  • .lnk
  • .mad
  • .maf
  • .mag
  • .mam
  • .maq
  • .mar
  • .mas
  • .mat
  • .mau
  • .mav
  • .maw
  • .mcf
  • .mda
  • .mdb
  • .mde
  • .mdt
  • .mdw
  • .mdz
  • .ms-one-stub
  • .msc
  • .msh
  • .msh1
  • .msh1xml
  • .msh2
  • .msh2xml
  • .mshxml
  • .msi
  • .msp
  • .mst
  • .ops
  • .pcd
  • .pif
  • .pl
  • .prf
  • .prg
  • .printer
  • .ps1
  • .ps1xml
  • .ps2
  • .ps2xml
  • .psc1
  • .psc2
  • .pst
  • .reg
  • .rem
  • .scf
  • .scr
  • .sct
  • .shb
  • .shs
  • .shtm
  • .shtml
  • .soap
  • .stm
  • .svc
  • .url
  • .vb
  • .vbe
  • .vbs
  • .vsix
  • .ws
  • .wsc
  • .wsf
  • .wsh
  • .xamlx



How to concatenating the columns in a SharePoint List?

How to concatenating the columns in a SharePoint List?

To concatenate the columns we have to create calculated column and we have to write the formula based on our requirement.

First create a calculated column

Create a formula as shown in below example to combine two columns.

Example:

I am already having two columns with name “YourColumnName1” and “YourColumnName2”,if we want to combine the both the columns we have to create a another column with calculated type and add the formula as shown below.


=CONCATENATE(YourColumnName1,YourColumnName2)

If we use this example, we won’t get any space between the “YourColumnName1” and “YourColumnName2”.

If we want to give any space between the two columns we have to use this below formula.

=CONCATENTATE(YourColumnName1,””, YourColumnName2)

Labels

.Net Interview Questions add custom button in sharepoint using javascript Add custom column property into a PageLayout in SharePoint Add Page Title on their browser's title bar in SharePoint Customly add zip files in blogger Add-SPOSiteCollectionAppCatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list Advance SmartObject An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Angular 2 Angular JS Angularjs Angularjs 1 anonymous users accessing lists and libraries App Permissions for SharePoint 2013 asp.net membership unique email Asp.net TreeView Control asp.net. Attendees in SharePoint Auto refresh list using Content Editor WebPart in SharePoint 2013. Auto Refresh SharePoint list using JavaScript Block and unblock of attachment types in SharePoint Blogger C# Callouts in SharePoint 2013 Cascading Dropdown list in SharePoint change onenote to another location. change SuiteBarLeft in SharePoint 2013 check if userid exists in database c# click node text to expand/collapse in Treeview client object model Close webpart CQWP crate chart using BI site in PPS Create a modern team site collection in SharePoint online Create BI chart in PPS SharePoint 2013 create filter in dashboard designer. create kpi's in dashboard designer create kpi's in SharePoint 2013 dashboard designer Create List Create List In SharePoint Create List using Power Shell Script Create Lookup Field in List using Power Shell Script Create lookup field in List create SharePoint List custom view. create SharePoint List views in List Schema create site collection in site collection in SharePoint using powershell created Date Time calculated field in SharePoint Cross site Collection in SharePoint 2013 Crud Operation in Asp.net Using Stored Procedure Custom MasterPage Approval in SharePoint custom view for survey list Customly add SharePoint List view in Page. delete items in sharepoint using powershell Difference between Angular 1.x & Angular 2 difference between Office 365 and Windows Azure difference between Windows Azure and Office 365 in sharepoint? DifferenceBetween discussion board Display Data in Grid View display radio buttons and choice fields horizontally in SharePoint 2013 Document library DotNet Drag and drop documents in document library in SharePoint dynamically populating values from one list to another list using jquery in sharepoint edit and delete buttons in datagridview Edit Links email notification using Nintex enable anonymous access in SharePoint 2013 enable app catalog sharepoint online site collection powershell Enable appcatalog site collection level using PowerShell based on Input file Enable versions for list and library except the hidden lists using PowerShell Script Error occurred in deployment step 'Recycle IIS Application Pool': Cannot resolve model for the project package Errors&Solutions Export document library in sharepoint using powershell Export particular Group in Term Store Management in SharePoint 2013 Export to Excel first release Flow Flow features free disk space on servers using powershell Friendly URLs and Managed Navigation in SharePoint 2013 get a list of site collection with template in web application using PowerShell Script in SharePoint Get attachments in SharePoint custom list using c# get current list item id sharepoint programmatically Get current url using jquery Get data from SharePoint list using Rest api & Angular JS Get Random Get Random SharePoint items using PowerShell Get Random values from SharePoint list using PowerShell Get url of the last value using jquery Get-SPOSite : The managed path sites/yoursitename is not a managed path in this tenant. Getting Email From User Hide “Edit Links” in left navigation SharePoint 2013 hide button in sharepoint based on permissions Hide column in SharePoint List view hide fields using client side object model Hide list in Quick Launch in SharePoint using PowerShell How to add Custom Tiles to SharePoint site Page. How to add extension files in Search Navigation in SharePoint 2013 How to Add Multiple users Using SharePoint People Picker How to add SharePoint list view in Page using C# How to Approve MasterPage using PowerShell in SharePoint How to bind Multiple users Using SharePoint People Picker how to change indicators on kpi performance how to check if an email address already exists in the database in asp.net how to configure workflow manager platform for SharePoint 2013 how to create calculated value using powershell how to create certificate in SharePoint How to create flow. how to create gantt chart webpart in sharepoint how to create KPI indicators in Dashboard designer How to create moden communication site in SharePoint online How to create Multi selected filter in Dashboard How to create nintex workflow in sharepoint how to create rdlc reports in asp.net How to Display Data Grid View in ASP.net How to enable anonymous access in SharePoint How to find data in datagridview in c# How to get image names from the folder using C# how to get particular list content type id in SharePoint 2013 How to get QueryString value in SharePoint WebPart Programatically how to get the current item id for newly created item using REST API and JQuery how to hide list in sharepoint how to know who created list in sharepoint How to make a Site Collection Read-Only in SharePoint 2010 How to overlay Office 365 shared calendar on SharePoint Site how to pass jquery value to asp.net textbox control How to pass pagename as a browser's title bar in the page how to remove unused Application Pool in SharePoint how to remove zone using powershell script How to send mail to particular group of people using PowerShell how to update modified by and created by using powershell how to uplaod RAR files in blogger import csv data into sharepoint import data using powershell Import group to term store management using SharePoint 2013. InfoPath InfoPath Cascading Dropdown list Insert update delete in datagridview in C# winforms Integration from SharePoint to k2. K2 Smart Forms for SharePoint JavaScript Injection jquery JSON K2 blackpearl K2 Designer K2 Designer Workflow. K2 smartform cascading dropdown list k2 Workflow K2 workflow to send a mail with PDF left navigation Local Term Set in managed meta data Managed meta data navigation in SharePoint 2013 Managed metadata service in SharePoint 2013. Managed Navigation in SharePoint 2013. Managed Promoted Sites. meta data navigation Microsoft Flow New Features New-SPConfigurationDatabase The user does not exist or is not unique NintexWorkFlow Office 365 OneDrive OneNote overwrite existing document in sharepoint using javascript PDF Converter PDF Method in K2 Performance Point Service in SharePoint 2013 PerformancePoint Services Configurtion PerformancePoint Services Configurtion for SharePoint 2013 PerformancePoint Services in SharePoint Server 2013 Popularity trends in SharePoint 2013 Pages populate dropdown list dynamicallyusing jquery Power Power Automate Power Shell Power shell script to get SharePoint site size. PowerApps powershell read xml PowerShell Script PowerShell script to get list of users from SharePoint groups PowerShell Scripts in SharePoint 2013 Powershell to set the masterpage in SharePoint Promoted Links Promoted Sites psconfig.exe quick launch Rdlc reports Readonly Column in SharePoint Editview Realtime DotNet Interview Questions Recent Dotnet interview questions Recent SharePoint interview questions recover deleted OneNote page. OneNote content is missing Regional Settings in SharePoint 2013 Replace New Item text in SharePoint Rest API Schedule PowerShell Script Search in SharePoint 2013 Search navigation in SharePoint 2013 Secure store service SecureStore Services SecureStore Services configuration for SharePoint 2013 self-signed certificate on IIS Server Send email to members of SharePoint Group using PowerShell sharepint2010 sharepoin2010 SharePoint 2013 SharePoint 2010 SharePoint 2013 SharePoint 2013 Dashboard Designer SharePoint 2013 features SharePoint 2013 Interview Questions SharePoint 2013. SharePoint 2013.disable views from user to create SharePoint 2013.Power shell SharePoint 2013.SharePoint 2010 SharePoint 2016 SharePoint Administration SharePoint Alerts and Reminders SharePoint App Configuration SharePoint Apps SharePoint Bulk upload SharePoint Calculated field SharePoint Calendar View sharepoint interview questions SharePoint online interview questions SharePoint online training SharePoint Onprem vs Online SharePoint RealTime Online Training SharePoint2010 SharePoint2013 SharePoint2016 SharePointInterview SharePointOnline SharePointOnline;Restore deleted site;SharePoint 2013 show data in datagridview in C# Simple Insert update Delete Retrieve Clear in asp.net. Site Collection Operations in SharePoint 2013 Site Collection Read-Only in SharePoint 2013 site contents Sorting & Filtering SPO SPSite Site Collection Operation parameters in SharePoint 2013 Step by step to create rdlc report in .Net Store names in text files in C# Sub site Subsite Term store management. The server was unable to save the form at this time. please try again UI New look update created by using client side object model update field values in SharePoint using powershell update items in SharePoint list using client object model update modified by field using client side object model upload zip files in blog use IsNullOrEmpty in PowerShell VirtoSoftware VirtoSofware vitrosoftware WebParts what is Document Set in SharePoint 2010 What is Filter in SharePoint Dashboard what is Limited-access user permission lock down mode feature What is Modern Team site What is Target Audience in SharePoint Who Created Site Using PowerShell Workflow in SharePoint 2013 Workflow management platform in SharePoint 2013 Workflow manager for SharePoint 2013 XSL-Template.