October 4, 2018 / Last updated : October 4, 2018 Sethu PowerShell

How to set the status of workflow task in SharePoint 2010,2013,2016, online using Powershell?

Hello SharePointers, Below is the Powershell script to update the status of the workflow task column in SharePoint. $site = Get-SPSite(“http://myssharepointsite”) $web = $site.RootWeb $list = $web.Lists[“CloudEnablement”] $item = $list.GetItemById(20) $task = $item.Tasks[0] $ht = new-object Hashtable $ht[“TaskStatus”] = “Approved” [Microsoft.SharePoint.Workflow.SPWorkflowTask]::AlterTask($task, $ht, $false) Happy SharePointing Folks 🙂

October 3, 2018 / Last updated : October 3, 2018 Sethu Client Side Object Model

How to resolve 404 error in SharePoint List attachment in SharePoint online/Office 365/SharePoint 2010/2013/2016?

Hello SharePointers, When you try to download a file attachment, there are time you receive “404 not found” Error. You need to rebind the onlick event using Content editor web part like below <Script type=”text/javascript”> var attachmenttable = document.getElementById(“idAttachmentsTable”); var attachmentanchor = attachmenttable.getElementsByTagName(“a”); for (var j = 0; j < attachmentanchor.length; j++) { var […]

September 13, 2018 / Last updated : September 13, 2018 Sethu Office 365

How to consume Graph API in SharePoint Client framework-spFX in SharePoint online?

Hello SharePointers, You can consume Microsoft graph API in sharepoint framework using AADhttpclient. Here is the source code to achieve the same. private getUserDetailsGraphAPI(): void { const aadClient: AadHttpClient = new AadHttpClient( this.props.context.serviceScope, “https://graph.microsoft.com” ); // Get users with givenName, surname, or displayName aadClient .get( ‘https://graph.microsoft.com/v1.0/users?$select=displayName,mail,userPrincipalName’ AadHttpClient.configurations.v1 ) .then(response => { return response.json(); }) .then(json […]

September 13, 2018 / Last updated : September 13, 2018 Sethu SharePoint Pnp

How to enable MegaMenu in SharePoint Modern sites in SharePoint Online/Office 365?

Hello SharePointers, In case if you want to enable the megamenu in the header of your sharepoint page, here is the Powershell PnP Script to achieve the same. Connect-PnPOnline -Url https://mysite.sharepoint.com $web = Get-PnPWeb $web.MegaMenuEnabled = $true $web.Update() Invoke-PnPQuery Happy SharePointing Folks.!!

August 31, 2018 / Last updated : August 31, 2018 Sethu Client Object Model

How to hide fields in SharePoint display form using Javascript in SharePoint 2010/2013/2016 /2019 and office 365?

Hello SharePointers, If you add external column in list, those columns will be visibile in your sharepoint display form by default. To hide sharepoint fields in sharepoint display form, you have to write the below script. <script language=”javascript” src=”https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js”></script><script language=”javascript”> $(document).ready(function () { $(“.ms-standardheader:contains(‘FieldName1’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName2)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName3’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName4)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName5)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName6’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName7’)”).closest(“tr”).hide(); $(“.ms-standardheader:contains(‘FieldName8’)”).closest(“tr”).hide(); }); </script><br/><br/> Happy […]

August 22, 2018 / Last updated : August 22, 2018 Sethu Client Object Model

How to add multiple users to People picker using JSOM in SharePoint 2010, 2013,2016,2019 Online & Office 365?

Hello SharePointers, Below is the JSOM script to add multiple user to people picker field in SharePoint list forms. function InsertUserstopeoplePicker() { var ctx = new SP.ClientContext(appWebUrl); var CtxSite = new SP.AppContextSite(ctx, hostWebUrl); var web = CtxSite.get_web(); var List = web.get_lists().getByTitle(‘Mytestlist’); var itemCreateInfo = new SP.ListItemCreationInformation(); var oListItem = List.addItem(itemCreateInfo); //Get User info var peoplePicker […]

August 15, 2018 / Last updated : August 15, 2018 Sethu PowerShell

How to move all the items in recycle bin stage 1 to recycle bin stage 2 in SharePoint Online/Office 365/Sharepoint 2010/2013/2016?

Hello SharePointers, Below are the powershell script to move recycle bin items from stage1 to stage 2. This would come to us in handy in case if we can to move it on our own rather than depending on the job. $ctx=New-Object Microsoft.SharePoint.Client.ClientContext($Url) $ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username, $Password) $ctx.ExecuteQuery() $ctx.Load($ctx.Web) $recyclebin=$ctx.Web.RecycleBin $ctx.Load($rb) $ctx.ExecuteQuery() Write-Host $ctx.Web.Url […]

August 15, 2018 / Last updated : August 15, 2018 Sethu PowerShell

How to loop through all the azure subscriptions in a powershell?

Hello SharePointers, In this blog, I will share the script to loop through all the azure subscriptions in a tenant $allResources = @() $subscriptions=Get-AzureRMSubscription ForEach ($vsub in $subscriptions){ Select-AzureRmSubscription $vsub.SubscriptionID Write-Host Write-Host “Working on “ $vsub Write-Host $allResources += $allResources |Select-Object $vsub.SubscriptionID,$vsub.Name Get-AzureRmVM | Select Name,REsourceGroupName,Location } Happy SharePointing Folks 🙂

July 25, 2018 / Last updated : August 15, 2018 Sethu Client Object Model

How to validate SharePoint list for First and Last name should be unique in Office 365/SharePoint online/2010/2013/2016?

Hello SharePointers, SharePoint online doesn’t allow two columns to be set as unique value for validation. Let us consider the business scenario, where first name and last name has to be unique in a SharePoint list. This can be achieved using REST API calls . Below are the code snippet that will help you to […]