Let's SharePoint

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 […]
April 16, 2019 / Last updated : April 16, 2019 Sethu Customization

How to get alerts for a specific policy in Cloud app security using Powershell

Hello Bloggers, In this blog, we can see how to get alerts for a specific policy in Cloud app security using Powershell. —————————————————————————————————————————– $Body = @{ “filters” = @{ “entity.policy”=@{“eq”=”5ae2481bfddeab61625fb5ef”} “resolutionStatus”=@{“eq”=0} } } | ConvertTo-Json $Header = @{Authorization =”Token Your Token”} $response = Invoke-RestMethod  -Uri “https://yourportal.us2.portal.cloudappsecurity.com/cas/api/v1/alerts/” -Headers $Header -Method POST -body $body -Verbose $response.data
April 9, 2019 / Last updated : April 9, 2019 Sethu Customization

How to get the list of custom apps in App catalog using Powershell?

Hello Sharepointers. Below are the powershell script get the list of custom apps in App catalog using Powershell using (ClientContext context = new ClientContext(“https://youroffice-admin.sharepoint.com”)) { Tenant tenant = new Tenant(context); tenant.Context.Load(tenant); tenant.Context.ExecuteQueryRetry(); var appCatalogAppInfoCollection = tenant.GetAppInfoByName(string.Empty); tenant.Context.Load(appCatalogAppInfoCollection); tenant.Context.ExecuteQueryRetry(); foreach (var app in appCatalogAppInfoCollection) { Debug.WriteLine(“APP: ” + app.Name); Debug.WriteLine(“Source: ” + app.Source); } } Happy […]
April 4, 2019 / Last updated : April 4, 2019 Sethu Windows Powershell

How to get the list of policies in Microsoft Cloud app security using window powershell?

Hello Team, Below are the powershell command to get the list of policies in Microsoft Cloud app security using window powershell. $response = Invoke-RestMethod  -Uri “https://yourorganisation.us2.portal.cloudappsecurity.com/cas/api/v1/policies/” -Headers @{Authorization = “Token 34343dQUpdTV1AXA34343dW05DA3434343343433TEBCU01NTBkfHRYbGRcdTBhJSUlMTRkXTklOHEkZSR4dFxgaFhpNSx9JHks3434343343E0232=”} -Method Post  -Verbose                                              […]
April 4, 2019 / Last updated : April 4, 2019 Sethu SharePoint Online

How to get the list of List and Document library item counts in SharePoint online using Pnp Powershell ?

Hello SharePointers, Below are the powershell commands to get the list of List and Document library item counts in SharePoint online using Pnp Powershell . $siteurl = “https://organisation.sharepoint.com/sites/selfservice/” $credentials = Get-Credential Connect-PnPOnline -Url $siteurl -Credentials $credentials $Subsites= Get-PnPSubWebs $ListItemCollection = @() Write-Host “Subsite count is ” $Subsites.Count ” in the site” foreach ($subsite in $Subsites) […]
April 2, 2019 / Last updated : April 2, 2019 Sethu SharePoint Online

How to restore subsite in a Sharepoint online site collection using Pnp Powershell

Hello SharePointers, Below are the power shell commands to restore subsite in a SharePoint online site collection using Pnp Powershell. $URL=”https://yourcompany.sharepoint.com/sites/selfservice/” $title=” KDM Monitor” $credentials=Get-Credential # Connect to SharePoint Online Connect-PnPOnline -Url $URL -Credentials $credentials Get-PnPRecycleBinItem | ? Title -eq $title | Restore-PnPRecycleBinItem Happy SharePointing 🙂