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 […]
Hello SharePointers, In case if you are wondering why alerts emails are not triggered on any changes in the SharePoint List /View, here is a little catch, the alerts will work only on the few column types. Below are the column types that work on alerts on views with filters: Single line Multiple line Choice […]
Hello SharePointers, In case if you want to create set level permission for a SharePoint list in way that only contributors of the group can create list item and can see only their records. Its pretty simple. Please do the below settings as below in List settings. Then create a SharePoint group with contribute […]
Hello SharePointers, SharePoint frameworks is most talked about the topic nowadays. In this blog,we will get the current logged in user on a SharePoint List using SPX framework. import Web from ‘sp-pnp-js’; let web = new Web(this.context.pageContext.site.absoluteUrl); let curruser = web.currentUser.get().then(function(res){ console.log(res.Title); }) Happy SharePointing Folks 🙂
Hello SharePointers, Here are the JSOM script to associate global reusable workflow to a SharePoint list/libraries. <script type=”text/javascript”> function AddWorkflow() { var ctx = SP.ClientContext.get_current(); var site = ctx.get_web(); var templates = ctx.get_web().get_workflowTemplates(); var template = templates.getByName(“My worklows”); ctx.load(templates); ctx.load(template); ctx.executeQueryAsync(Function.createDelegate(this, function (sender, args) { var info = new SP.Workflow.WorkflowAssociationCreationInformation(); var taskList = ctx.get_web().get_lists().getByTitle(“Workflow Tasks”); […]
Hello SharePointers, When do you have a custom webpart, if its get timed out due to various data sources involved and throws the following error. “Unable to display this Web Part. For information on how to solve the problem, open this web page in an HTML editor compatible with Microsoft SharePoint Foundation, such as Microsoft […]
Hello SharePointers, Here are the CSOM code to create a survey list in SharePoint 2010/203 or SharePoint Online. public static void CreateSurveyList() { ClientContext ctx = new ClientContext(“http://mysite”); ListCreationInformation lci = new ListCreationInformation(); lci.Description = “Test Survey”; lci.Title = “First Survey”; lci.TemplateType = 102; List newSurveyList = ctx .Web.Lists.Add(lci); ctx .Load(newSurveyList); ctx .ExecuteQuery(); } Happy […]
Hello SharePointers, Here are the powershell script to set Searchable, queryable, Sortable, Retrievable, Refinable for a managed property. $searchappln = Get-SPEnterpriseSearchServiceApplication $ManagedProperty = Get-SPEnterpriseSearchMetadataManagedProperty -SearchApplication $searchappln -Identity $_.ManagedPropertyName -ea silentlycontinue if($ManagedProperty) { $ManagedProperty.Searchable = $true $ManagedProperty.Queryable = $true $ManagedProperty.Sortable = $true $ManagedProperty.Retrievable = $true $ManagedProperty.Refinable = $true $ManagedProperty.SafeForAnonymous = $true $ManagedProperty.update() write-host “The searchable, queryable, […]
Hello SharePointers, Below is the Powershell script to delete the older version of SharePoint list item. This script will delete the older version which lasts more than 12 months or after. $SPweb = Get-SPWeb “http://mysite/goodness” $limit = (Get-Date).AddMonths(-12) $SPlist = $SPweb.Lists[“Doc1”] foreach ($SPitem in $SPlist.Items) { $VersionsCount= $SPItem.Versions.count for($v=$VersionsCount-1;$v -ge 0;$v–) { if($SPitem.Versions[$v].IsCurrentVersion){ } else{ […]
Hello SharePointers, Here are the below Pnp Scripts to enable /disable Modern Site Pages in Office 365/SharePoint 2016. # Connect to your sharepoint site $cred = Get-Credential Connect-PnPOnline -Url https://[mytenant].sharepoint.com/sites/siteurl -Credentials $cred # Disable Modern site pages Disable-PnPFeature -Identity B6917CB1-93A0-4B97-A84D-7CF49975D4EC -Scope Web #Enable Modern site pages #Enable-PnPFeature -Identity B6917CB1-93A0-4B97-A84D-7CF49975D4EC -Scope Web Happy SharePointing 🙂