Category: Document Library

List view threshold error(5000 items issue) in SharePoint On-Premise/SharePoint Online

Many times when we deal with big list in SharePoint, we get the error : “This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator”. In this article we will learn about the root cause of this error and its fix. Introduction The threshold concept was introduced

Continue reading

SharePoint Online Automation – O365 – Upload files to document library using PowerShell CSOM

Here in this post – I will show how we can upload multiple files or documents to SharePoint online document library using PowerShell CSOM programmatically from the given directory. Below are the list of files – located in my local directory which I am going to upload to SharePoint online document library using the PowerShell

Continue reading

SharePoint Online Automation – O365 – Download files from a document library using PowerShell CSOM

Here in this post – I will show how we can download files or documents from SharePoint online document library using PowerShell CSOM programmatically from the given date by passing “From Date” and “To Date” to the query. Lets say we want to download certain files from SharePoint document library those were created between these

Continue reading

Get SharePoint list URL by list ID

Sometimes due to some reason when SharePoint developer is shared only with SharePoint site url and list id – using this two combination, they need to generate the default view URL.  Then how can we construct the list URL? I will show here in this post how we can get SharePoint list URL by list

Continue reading

How to create indexed column in SharePoint on-premise and online – O365?

When we talk about the slowness of SharePoint list view loading – we go with the indexing the column. In this article we will learn how to create indexed column in SharePoint. Introduction If you are not clear about what indexing actually is – I would recommend to read my previous article how does the

Continue reading

SharePoint – O365 – How does the database column indexing work in SharePoint?

Introduction Being a SharePoint developer, administrator and architect, we quite often discuss about SharePoint list items loading issue and when it comes to list items loading performance issue, we straight away go for indexing the columns to speed up the performance. So in this article I will focus on what exactly happens in the SQL

Continue reading

SharePoint – O365 – What is the right way to iterate or loop through List Items?

In this article we will learn what is the right way to iterate or loop through the SharePoint list items either from SharePoint on-premise or SharePoint online – o365. Introduction Generally when developer writes the code quickly – this might be observed. Lets say in SharePoint “PurchaseOrder” list, there are 500 items. And thru the

Continue reading

SharePoint On-Premise – Online O365 : Static Name vs. Internal Name vs. Display Name in SharePoint

Introduction: During our SharePoint development or customization we often come across about the need of SharePoint column “Display Name” and “Internal Name”. Apart from these two there are one more name which is column “static” name, generally we don’t much deal with this name(at least myself) during the SharePoint customization. However, I was curious to

Continue reading

How to fix “Upload failed: Path not found” or The specified path, file name, or both are too long error.

Issue description – scenario 1: Couple of years back I was working in a big migration project where I was migrating more than 200 GB of data thru the third party tool. Migration was failing again and again so it needed my constant monitoring. The 90 percent of error was “The specified path, file name,

Continue reading