Create sharepoint site in Office365 using powershell script

Just do copy/paste the below script in you powershell and see the magic..You will be able to new site in your office 365 application.

Am sharing the below script to all of my SharePoint colleges once did the experiments from my side.

*********************************************************************************
$wc = New-Object System.Net.WebClient
$wc.Headers.Add("User-Agent","Mozilla/4.0+")      
$wc.Proxy = [System.Net.WebRequest]::DefaultWebProxy
$wc.Proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials
Add-Type –Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type –Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type –Path "C:\Program Files\SharePoint Client Components\16.0\Assemblies\Microsoft.Online.SharePoint.Client.Tenant.dll"
$siteUrl = “http://xxx.xxxx.com”
$password = convertto-securestring "*****" -asplaintext -force
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("username", $password)
$ctx.Credentials = $credentials
$webCreationInformation = New-Object Microsoft.SharePoint.Client.WebCreationInformation
$webCreationInformation.Url = "URLName"
$webCreationInformation.Title = "Title"
$webCreationInformation.WebTemplate = "STS#0"
$newWeb = $ctx.Web.Webs.Add($webCreationInformation)
$ctx.Load($newWeb)
$ctx.ExecuteQuery()
**********************************************************************************
Please let me know for any concerns.

-Thanks,
Sasi Kumar Reddy
https://sharepointquicksolutions.blogspot.com

Setup [Today] as default to the sharepoint date time control through browser

Step1:

Create a new date time field and set the calculated value as “Today”. That’s it.

Create a new item into the list. There you can see set the Today’s date as default to the date time field.

Step2: 
Creata new item into the list and there you will see the set the Today's date as default to the sharepoint date time field.[PFB the image]

SharePoint choice field using powershell

$docSite = new-object Microsoft.SharePoint.SPSite($siteURL)
$docWeb = $docSite.OpenWeb()
$lncustomListName listName
$CustomfieldName = "MyChoiceColumn"

/* To create choice field */
Add-SPMultiChoiceField -listName $lncustomListName

/* Method to create choice field */
function Add-SPMultiChoiceField([string]$listName)
{
  $OpenList = $docWeb.Lists[$listName]
  $multiChoiceCol = "<Field Name='"+ $CustomfieldName +"' Type='MultiChoice' FillInChoice='FALSE' DisplayName='"+ $CustomfieldName +"'><Default>MyChoice1</Default><CHOICES><CHOICE>MyChoice2</CHOICE><CHOICE>ERM</CHOICE><CHOICE>MyChoice3</CHOICE></CHOICES></Field>"
 $OpenList.Fields.AddFieldAsXml($multiChoiceCol,$true,
 [Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView) 
}

Creating a Site using Nintex workflow

1. Create a new list and the fields: Project Name(single line of text) , site name(hyperlink) and Author( people picker)
2. Create a new nintex workflow
3. Insert Action and Sites and Workspace and then Create a new Site.
4. Configure the above action as shown below
5. If the parent site permissions has to be inherited ,check the Inherit Permissions check box
   

How to view the large number of records in a list/library even if exceeds the threshold limit value

There is a work around to view the large number of records in a list/library even if exceeds the SharePoint threshold limit value(5000 records).

 

Let me explain you briefly, I have a custom list/library and it is having one lac records approximately and now  we wants to show the results of one lac records in my list/library. But it is not possible because Sharepoint can not view the large number of records if exceeds the sharepoint threshold limit value(5000 records). 

Solution: create a new view and remove the filters/orderby/sortby/group by and select the show items with out folder option. We can view large number of records by removing all the these.

Benefit: we can search the results.

Please let me know for any issues.

-Thanks,

Sasi kumar Reddy