Skip to main content

Posts

Unable to create a list from the custom template uploaded to the list gallery in SharePoint online

SharePoint lists can be reused on multiple sites just with a list template without having to create a custom list from the scratch.  This can be accomplished by saving the list as a template (.stp) file from the "List Settings" page. Once the template has been created, it can be uploaded to any number of sites in their "List template Gallery" at the site collection level. From here, the list can be created on any of the subsites under that site collection. The approach is same for SharePoint online as well.  But, in SharePoint online, the list could not be found under the "Add an App" section even after uploading the list template to the gallery. So how to create a list from the template in SPO when it is not listed in the Apps? 1.  Create a Custom List from the site contents and save it as a list template.  2. Click on "Add an App" and choose the OOTB list template. In the pop up where the list name to be mentioned, click on "Advanced optio...
Recent posts

Remove the page title from SharePoint online modern page

SharePoint Online supports two basic designs; The  “Classic”  and the  “Modern”  experience.  The “Classic” experience is a highly customizable user interface much similar to an On-Prem experience.   The “Modern” experience has some limitations on the design customizations unlike the "Classic" experience.  The "Modern" page can be created from Site Contents-> New->Page. The modern page would be created in edit mode where you can choose the page layout and add the necessary webparts and publish the page. But, how to remove the page title from the page where the customizations are limited? It's quite simple!!! 1. Open the page in the SharePoint designer -> "Advanced Edit Mode". 2. Look for the tag <mso:PageLayoutType msdt:dt="string">Article</mso:PageLayoutType>. Replace "Article" with "Home" as below and save the file. <mso:PageLayoutType msdt:dt="string">Home</mso:PageLayoutType> ...

Create a Hyperlink column in SharePoint Online Custom List

“We would accomplish many more things if we did not think of them as impossible.” It is possible to create a hyperlink column in SharePoint list but is it possible to create a hyperlink column as a calculated column? The Answer is "Yesssssssssssssssssss". Following are the steps to accomplish the same. 1. Create a Calculated Column say URL with the formula to link the list column id to a page.  For example: ="http://sharepoint.com/sites/Test/Page.aspx?ID="&ItemID . 2.Create another calculated column say Info and refer the previously created calculated column here in anchor tag. For example:  =IF(ISBLANK(URL),"No URL",("<a href="&URL&" target='_blank'></a>"))  Make sure the data type returned in both the calculated columns are Numbers. Now its time to render the Calculated column as a HTML markup in SPO. 1. Ensure that the list is in the modern experience. 2. Click on the URL column-> Column settings-...

"An unexpected error has occurred. Changes to your data cannot be saved" excel SharePoint

“If you’re not making some notable mistakes along the way, you’re certainly not taking enough  business and career chances .” After creating a custom "Export to Excel" button on the SharePoint page as in my previous post:   https://nethrasb.blogspot.com/2020/05/export-to-spreadsheet-option-in.html we encountered an issue, where one of the user received "An unexpected error has occurred. Changes to your data cannot be saved" in the excel sheet to which the data has been exported. But I was able to export the data using "System Account" without any issue!  The user has full control over the site and there should not be any permissions related issues.  What could be the issue then?  It might seem silly but this is what happened. Humans make mistakes :) My fellow team mate who had been asked to create the view, created a "Personal" view instead of creating a "Public" view !  "Personal" view is i...

SharePoint Folder not available under site contents but can be accessed in the Windows Explorer

Recently we received an issue from one of the user that a folder is not available in SharePoint site contents page but could be found in the Windows Explorer. It's a well known fact that we have an option to open the SharePoint Document Library in Windows Explorer and the site can be mapped to a network drive to view the contents. But what could be the cause of folders missing in the site contents page but can be accessed through Windows Explorer? The cause might seem unusual :) but this is what it is, the folders were created in the Windows Explorer. The SharePoint Document library can be opened in the Windows Explorer and the sub folders can be created in the Explorer which would reflect in the site. But creating a folder in the Windows Explorer does not create a Document Library in the SharePoint site. Seems very simple but would definitely help! Happy SharePointing!!! 

"Export to Spreadsheet" option in SharePoint list web part does not export all the columns

We all knew that the SharePoint list can be embedded in a web part page using the list web part. The list web part provides us with various properties which can be customized as per the requirement. One such property is the "Toolbar" . If "Show Toolbar" option is set, we would be provided with 3 tabs namely "New", "Actions" and "Settings".  The list data can be exported to an excel using the "Export to Spreadsheet"  option found under the "Actions" tabs.  Now here is the issue, suppose we have 10 columns in the list and we would like to show only 5 columns in the page, we would create a view in such a way that the page shows only the 5 columns.  If the data is exported from this page using the "Export to Spreadsheet" option, all the columns would definitely get exported, but the values would be exported only for those 5 columns which are shown on the page. This is because, the "Export to Spread...

Retrieve SharePoint last modified details using Powershell

Below is a simple script to retrieve the SharePoint webapplication last modified details along with the site/subsite URL and folder size. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $siteInfo = @(); Get-SPWebApplication http://yourwebapplication/ | Get-SPSite -Limit All | Get-SPWeb -Limit All|%{ $web = $_; $listInfo = "" $versionCount = "" $strHomePage = $web.RootFolder.WelcomePage        $WebSize = CalculateFolderSize($Web.RootFolder)        $row = New-Object -TypeName PSObject        $row | Add-Member -Name 'Site' -MemberType Noteproperty -Value $web.Title        $row | Add-Member -Name 'URL' -MemberType Noteproperty -Value $web.Url        $row | Add-Member -Name 'LastModifiedDate' -MemberType Noteproperty -Value $web.LastItemModifiedDate.tostring('dd/MMM/yyyy')        $row | Add-Member -Name 'Size' -MemberType Notepr...