Skip to main content

Posts

How to Export Users inside group in Excel in SharePoint

1.In SharePoint, navigate to the group you want to export.  2.Copy the URL from the browser.  3.In Excel Toolbar Goto Data > From Web and paste the URL in address and click Go. 
Recent posts

Rest API Curd Operations

Reference urls https://www.codeproject.com/Articles/990131/CRUD-operation-to-list-using-SharePoint-Rest-API https://social.technet.microsoft.com/wiki/contents/articles/33795.sharepoint-2013-crud-operation-on-list-items-using-rest-api-services.aspx Retrive LIst Items function retriveListItem()  {  03.      04.      $.ajax  05.      ({  06.          url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('companyInfo')/items?$select=Company,Industry",  07.          type: type,  08.          data: data,  09.          headers:  10.          {  11.              "Accept": "application/json;odata=verbose",  12.              "Content-Type": "application/json;odata=verbose",  13.              "X-RequestDigest": $("#__REQUESTDIGEST").val(),  14.              "IF-MATCH": "*",  15.              "X-HTTP-Method": null  16.          },  17.

Setting default value for person column to current user in SharePoint 2013 using REST

Add a content editor WebPart to the New form of custom list and add the below code,  replace the  ID of your column highlighted yellow  SetUserFieldValue function parameter to your people picker column name. < script src = " //ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js " >< /script > < script type = " text/javascript " > $( document ).ready( function () { var userid = _spPageContextInfo.userId; function GetCurrentUser () { var requestUri = _spPageContextInfo.webAbsoluteUrl + " /_api/web/getuserbyid( " + userid + " ) " ; var requestHeaders = { " accept " : " application/json;odata=verbose " }; $.ajax({ url : requestUri, contentType : " application/json;odata=verbose " , headers : requestHeaders, success : onSuccess, error : onError }); } function onSuccess ( data , request ){ var loginName = data.d.Title; SetUserFieldValue(

Accordion "Left Navigation" (Quick Launch) for SharePoint 2013

For Expand/collapse "Left Navigation (Quick Launch) for sharepoint 2013 Copy the below code and paste in Master page jQuery(document).ready(function () {  /*set dynamic css logic*/  if($('#sideNavBox .menu-item.selected').length){   //propagates the selected class, up the three.   $('li.static').removeClass('selected');   $('#sideNavBox .menu-item.selected').parents('li.static').addClass('selected');   //collapses top siblings of selected branch   $('#sideNavBox .menu-item.selected').parents('li.static').last().siblings()    .find('> ul').hide();  }  else $('#sideNavBox .root.static > li.static > ul').hide();  /*set accordion effect*/  $('#sideNavBox .root.static > li.static').each(function(){   if($(this).find('ul').length){    $(this).addClass('father').click(function(){     if($(this).children('ul').css('display')

Powershell Script to empty admin recyle bin in SharePoint

a script wherein if we give an user name for ex Deleted By "Bai,Mala(Mala)",it should delete the all the files which were deleted by user. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $siteURL = "your site url" $site = New-Object microsoft.sharepoint.spsite ( $siteURL ) $query = new-object Microsoft.SharePoint.SPRecycleBinQuery ; $query . ItemState = “FirstStageRecycleBin” ; $itemcoll = $site . GetRecycleBinItems( $query ); #Delete items those are deleted by Mala $files = $itemcoll | where { $_ . DeletedByName -match "your name" } #Delete output foreach ( $file in $files ) { $site . RecycleBin . Delete( $file . ID) }

Control when a document is displayed: Managing Item Scheduling

How to enable Scheduling Start Date and Scheduling End Date for pages /Documents library for Subsites. 1. After creating new Document library  / pages  go to List Settings. 2. In section General Settings select the link Versioning Settings, and enable" 1) Content approval to Yes . 2) Dcoument version history to created major and minor(draft) version . 3. In Section General Settings select the link " Manage Item Schueduling and select the option Enable scheduling of items in this list . 4. You will see Scheduling Start Date and Scheduling End Date in allitems pages.