Skip to main content

Posts

Showing posts from October, 2016

Copy the value of one column to another column in the same SharePoint List using Powershell script

Powershell Script to Copy the value of one column to another column in the same SharePoint List . $site = new-object Microsoft.SharePoint.SPSite(" http://localhst ") $web =  Get-SPWeb -Identity  http://localhst $list =$web.Lists[" List/Library Name "] $items = $list.items     foreach ($item in $items)     {     $sourcevalue = $item[" Column 1 "]     $item[" Column 2 "] = $sourcevalue     write-host $sourcevalue     $item.update()     } $list.update()
6 comments
Read more

Check-out all files in list or library in SharePoint using Powershell

Powershell Script to Check-out all files/items in a specified list or library . $spWeb = Get-SPWeb http://localhost/       $listName = " List/Library Name "   $list = $spWeb.Lists |? {$_.Title -eq $listName}  foreach ($item in $list.Items)        {         $itemFile = $item.File   $itemFile.CheckOut();          }  
Post a Comment
Read more

Check-in all files in list or library in SharePoint using Powershell

Powershell Script to Check-in all files/items in a specified list or library .    $spWeb = Get-SPWeb http://localhost          $listName = " List/Library Name "      $list = $spWeb.Lists |? {$_.Title -eq $listName}       foreach ($item in $list.Items)        {         $itemFile = $item.File                 if( $itemFile.CheckOutStatus -ne "None" )         {             $itemFile.CheckIn("Automatic CheckIn. ( corp\SPInstallD )")         }       }     $spWeb.Dispose() 
Post a Comment
Read more

How to access to Access request List in SharePoint Online

Browse to the Access Requests list in Internet Explorer/Chrome. Step 1 : Press F12 to open the F12 Developer Tools window. Step 2 : Click the Network tab, and then press F5 to enable network traffic capturing. Step 3 : Refresh the Access Requests page in Internet Explorer. After the page has loaded, press Shift+F5 to stop capturing network traffic. Step 4 : In the Developer Tools window, double-click the first result in the URL list. This URL ends in " pendingreq.aspx. " Step 5 :In the Developer Tools window, click Response body. Step 6 :In the search box, type pagelistid :, and then press Enter. Note :  The search highlights the pageListId text. Copy the GUID that follows the pageListId. The GUID will be between an opening brace ( { ) character and a closing brace ( } ) character as follows: {GUID} Note Include the opening and closing brace characters when you copy the GUID. This GUID is the identifier for the SharePoint Online Access Requests list for ...
Post a Comment
Read more

Get Login user name and details for SharePoint 2013 Online (Office 365)List New Form using REST API

Display login user name and details on SharePoint online(Office 365) List New Form. Step 1: Create people picker column(In my case, created 'F rom' column). Step 2: Open your List new form using SP Designer add tdFrom id for description filed. Step 3: Add the below code in script tag and add SharePoint Services and J query reference files(Download latest files). <script type="text/javascript" src="../../Style Library/Scripts/jquery-3.0.0.min.js"></script> <script type="text/javascript" src="../../Style Library/Scripts/jquery.validate.min.js"></script> <script type="text/javascript" src="../../Style Library/Scripts/jquery.SPServices-2014.02.min.js"></script> <script type="text/javascript" > $(document).ready(function()  { var fieldName ='From'; var userAccountName= $().SPServices.SPGetCurrentUser(); LoadPeoplePickerDetails();  }...
Post a Comment
Read more

Character or Word Count for Multi line Text box in SharePoint List Forms

Character Count for Multi line text box in SharePoint New,Edit List Forms. Step 1 : Open your List new/edit form using SP Designer. Step 2: Add <span> tag under your multi line text filed description in the New form. <span title="4000" id="commentscount">4000</span><span> Characters Left</span> Step 3: Add the below code in your New form. and download jquery latest file. <script type="text/javascript" src="../../Style Library/Scripts/jquery-3.0.0.min.js"></script> <script type="text/javascript"> $(document).ready(function()  { //character count $("textarea[name*='ff43']").keyup(function () { characterCount('ff43', '#commentscount'); }); function characterCount(controlID,spanId) {  var controlVal = $("textarea[name*='" + controlID + "']");  var cmax = $(...
4 comments
Read more

Multiple Attachments in SharePoint List Using Jquery

We will now explain the most important part of our Multiple upload attachment control in SharePoint List. Please follow the below steps. Step 1: Create List column like Attachment1 and datatype is single line text.   Step 2: Open List newform in SharePoint Designer 2013 Step 3: Add the below code under your list filed(Attachment1) <div id="attachmentsOnAttachC2"> <input type="file" name="AttachC20" id="AttachC20" class="ms-longfileinput" size="56" title="fupldAttachDnbReport"></input>                                                                          ...
1 comment
Read more