June 7, 2019 / Last updated : June 7, 2019 Sethu Office 365

How to insert table in Modern Pages using PnP Powershell in Office 365/Sharepoint Online?

Hello SharePointers, Modern pages doesn’t support adding images in a table using text web part. To achieve that, We can use the below Pnp Powershell Connect-PnPOnline -Url https://mysites.sharepoint.com/sites/Test -Credentials (Get-Credential) Get-PnPClientSideComponent -Page Image.aspx |Format -Autosize textWebpart = Get-PnPClientSideComponent -Page Image.aspx -InstanceId 1d5bfd23-766c-4e24-aa34-8e08527a29d7 $textWebpart.Text | clip $htmlToInject = ‘ <div class=”canvasRteResponsiveTable”> <div class=”tableWrapper”> <table title=”Table”> <tbody> […]
May 11, 2019 / Last updated : May 11, 2019 Sethu Office 365

How to set up Access Requests in SharePoint online using Powershell?

Hello SharePointers, Below are the powershell commands to set up the access requests in SharePoint Online. $URL= “https://laks.sharepoint.com/sites/happy/” $AccessRequest=”SharePointadmin@mycompany.com” $Cred = Get-Credential $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password) $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($URL) $Ctx.Credentials = $Cred $Web = $Ctx.Web $Ctx.Load($web.AllProperties) $web.RequestAccessEmail $Ctx.ExecuteQuery() #Set Access request Email $Web.RequestAccessEmail =$AccessRequest #Member settings $Web.MembersCanShare = $True $web.AssociatedMemberGroup.AllowMembersEditMembership = $True $web.AssociatedMemberGroup.Update() $Web.Update() […]
April 27, 2019 / Last updated : April 27, 2019 Sethu Office 365

How to add metadata to Document libraries in SharePoint online using powershell.

Hello SharePointers, Below are the Power shell command to add metadata to Document libraries in SharePoint online using powershell. $Path = “D:SharePoint docx” $listTitle = “My Documents” $targetList = $Context.Web.Lists.GetByTitle($listTitle) $filecreation= New-Object Microsoft.SharePoint.Client.FileCreationInformation $filecreation.Overwrite = $true $filecreation.Content = [System.IO.File]::ReadAllBytes($Path) $filecreation.URL = [System.IO.Path]::GetFileName(ePath) $File = $targetList.RootFolder.Files.Add(filecreation) $listItem = $uploadFile.ListItemAllFields $listItem[“LastReviewed Time “] = [System.DateTime]::Now $listItem.Update() $Ctx.Load($File) […]
April 17, 2019 / Last updated : April 17, 2019 Sethu Office 365

How to get Sharepoint site details using Powershell in Office 365?

Hello SharePointers, Below are the powershell code to site title, url, last modified date and creation date for a given sharepoint site collection. Get-SPWebApplication | Get-SPSite -Limit ALL | Get-SPWeb -Limit ALL | where { $_.HasUniquePerm -and $_.AssociatedOwnerGroup -ne $null } | foreach { $Title=$_.title;$TTNweburl = $_.Url; $_ ;$SiteCreatedDate=$_.Created; $SiteModifiedDate=$_.LastItemModifiedDate}| Select -ExpandProperty AssociatedOwnerGroup | Select […]
February 20, 2019 / Last updated : February 20, 2019 Sethu Client Object Model

How to report SharePoint list item versions in Office 365/SharePoint online?

Hello SharePointers, Below are Powershell script to get all the version history of all list items in SharePoint online/Office 365. $List = $Ctx.Web.Lists.GetByTitle($ListName) $Ctx.Load($List) $Ctx.ExecuteQuery() $Query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery() $ListItems = $List.GetItems($Query) $Ctx.Load($ListItems) $Ctx.ExecuteQuery() $VersionHistory = @() Foreach ($Item in $ListItems) { write-host “Processing Item:” $item.id -f Yellow #Get all versions of the list item $Versions […]
December 19, 2018 / Last updated : December 19, 2018 Sethu Customization

How to get SharePoint List Version using JSOM in SharePoint Online?

var Ctx = new SP.ClientContext.get_current(); if (Ctx) { var Web = Ctx.get_web(); var List = Web.get_lists().getByTitle(Name); var query = new SP.CamlQuery(); query.set_viewXml(xmlQuery); var listItems = List.getItems(query); Ctx.load(listItems); Ctx.executeQueryAsync(function (sender, args) { that.DataSet = []; var objlistEnumerator = objlistItems.getEnumerator(); while (objlistEnumerator.moveNext()) { var objListItem = objlistEnumerator.get_current(); var id = objListItem.get_item(‘ID’); var filePath = ‘https://mysharepoint/Lists/Preservenature/’+id+’_.000’ var web […]
December 12, 2018 / Last updated : December 12, 2018 Sethu Client Side Object Model

How to remove a site collection administrator in Office 365 using SharePoint Online PnP Powershell?

Hello ShaerPointers, Below are the piece of power shell code to remove a site collection administrator in Office 365 Using Pnp Powershell. param( [Parameter(Mandatory)] [String]$Url, [Parameter(Mandatory)] [String]$UserName)Remove-PnPSiteCollectionAdmin -Owners $loginName -Connection (Connect-PnPOnline $siteUrl -Credentials (Get-Credential) -ReturnConnection)$object = New-Object PSObject$object | Add-Member “SiteUrl” $Url$object | Add-Member “LoginName” $UserName$object| Add-Member “IsSiteAdmin” (Get-SPOUser -Site $siteUrl -LoginName $loginName | select […]