SharePoint Online: How to Create a New List from Existing List?

May 30, 2019    ,
Requirement: Create a list from an existing list in SharePoint Online. SharePoint Online: Create a List from an Existing List Creating a list as same as the existing list structure is a common requirement in SharePoint. We used the "Site list as Template" approach in previous versions of SharePoint and in Classic experience of SharePoint Online site. Now, in modern sites, this approach is not supported. The modern SharePoint Online sites provide a nifty way to create a list from existing lists. Here is how: Go to Site Contents Page (Click on "Settings" gear >> Choose "Site Contents"), click on the "New" menu and choose List. This opens a new list creation page which provides an option to create a new list from the existing list. Not just a list from the same site, but you can select different site collections even! Provide a name to your new list, Select the source list to clone and click on the "Create" button on the
SharePoint Online: How to Create a New List from Existing List? SharePoint Online: How to Create a New List from Existing List? Reviewed by Salaudeen Rajack on May 30, 2019 Rating: 5

SharePoint Online: Remove a Custom Theme using PowerShell

May 30, 2019    , , , ,
Requirement: Remove a custom theme in SharePoint Online SharePoint Online: PowerShell to Delete a Theme Here is the PnP PowerShell to remove a theme in SharePoint Online. #Config Variables $AdminSiteURL = "https://crescent-Admin.sharepoint.com" $ThemeName = "Corporate Theme" #Connect to PnP Online Connect-PnPOnline -Url $AdminSiteURL -UseWebLogin #Get the Custom Theme $Theme = Get-PnPTenantTheme | Where {$_.Name -eq $ThemeName} If ($Theme.Count -eq 0) { Write-host "The specified Theme '$themeName' doesn't exist!" -ForegroundColor Yellow Break; } #Remove the Theme Remove-PnPTenantTheme -name $Theme.Name Write-host "Custom Theme '$ThemeName' Removed Successfully!" -ForegroundColor Green If you remove a custom theme, any site uses the particular theme will not have any effect! They continue to use the colors of the deleted theme until you change it to a new theme.
SharePoint Online: Remove a Custom Theme using PowerShell SharePoint Online: Remove a Custom Theme using PowerShell Reviewed by Salaudeen Rajack on May 30, 2019 Rating: 5

SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell

May 30, 2019    , , , ,
Requirement: Get all items from a list where a particular filed value is Null. SharePoint Online: CAML Query IsNull Example Here is the example of how IsNull operator can be used in CAML: #Parameters $SiteURL = "https://crescent.sharepoint.com/sites/marketing/" $ListName= "Documents" $FieldName = "Title" $ReportOutput = "C:\Temp\ListInventory.csv" #Connect to SharePoint Online site Connect-PnPOnline $SiteURL -UseWebLogin #Array to store results $Results = @() #Define CAML Query to get items where the field value is null $CAMLQuery = "<View><Query><Where><IsNull><FieldRef Name='$FieldName' /></IsNull></Where></Query></View>" #Get all Items filtered by CAML query $ListItems = Get-PnPListItem -List $ListName -Query $CAMLQuery -PageSize 1000 Write-host "Total Number of Items Found:"$ListItems.Count $ItemCounter = 0 #Iterate through each item Foreach ($Item
SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell Reviewed by Salaudeen Rajack on May 30, 2019 Rating: 5

SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell

May 19, 2019    , ,
Requirement: Change Classic Experience to Modern Experience and Modern UI to Classic in SharePoint Online. How to Activate Modern Experience from Classic? The modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use.  It brings new functionalities and components, However, some features can only be used in the classic experience. So, you may need to switch between modern UI and classic experience in SharePoint Online. To enable modern experience in SharePoint Online, use the link "Exit classic Experience" at the bottom left corner. This turns ON modern experience. To disable modern experience and switch back to classic in SharePoint Online use the link "Return to Classic SharePoint" Please note, this script doesn't convert your classic team site home page to modern. You have to create a new modern page and set it as Home page! PowerShell to Switch Between Modern Experience and Classic Experiences To ena
SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell Reviewed by Salaudeen Rajack on May 19, 2019 Rating: 5

SharePoint Online: Copy Values from One Column to Another using PowerShell

May 04, 2019    , , ,
Requirement: Copy values from site column to another column in SharePoint Online list PowerShell to Copy List Column Value in SharePoint Online Make sure the new column is of same type. #Function to copy values from one column to another in a list Function Copy-SPOListColumnValues() { Param ( [Parameter(Mandatory=$true)] [string] $ListName, [Parameter(Mandatory=$true)] [string] $SourceColumnName, [Parameter(Mandatory=$true)] [string] $TargetColumnName ) Try { #Get All Items from the Source List in batches Write-Progress -Activity "Reading Source..." -Status "Getting Items from Source List. Please wait..." $ListItems = Get-PnPListItem -List $ListName -PageSize 2000 Write-host "Total Number of Items Found:"$ListItems.count #Get fields to Update from the Source List - Skip Read only, hidden fields, content type and attachments $SourceField = Get-PnPField -List $List
SharePoint Online: Copy Values from One Column to Another using PowerShell SharePoint Online: Copy Values from One Column to Another using PowerShell Reviewed by Salaudeen Rajack on May 04, 2019 Rating: 5
Powered by Blogger.