Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import

In this blog, I will show How to solve the below import Excel sheet issue in SharePoint

The specified file is not a valid spreadsheet or contains no data to import


Scenario

I have an Excel file as shown below,

The specified file is not a valid spreadsheet or contains no data to import

I have tried to import this Excel file to SharePoint using Import spreadsheet feature

The specified file is not a valid spreadsheet or contains no data to import

But unfortunately, I got this error

The specified file is not a valid spreadsheet or contains no data to import

The specified file is not a valid spreadsheet or contains no data to import


Cause

Continue reading Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import

Show SharePoint Document Library files with folders and subfolders in SSRS

In this article, I will explain

How to show a SharePoint Document Library files with folders and subfolders in SSRS recursively

 

Show Recursive Document Library files with folders and subfolders in SSRS


Scenario

I have a SharePoint Document Library with multiple folders and subfolders as shown below:

Show Recursive SharePoint Document Library files with folders and subfolders in SSRS.gif

I have tried to retrieve all files, folders, and subfolders from this Document Library in Reporting Service (SSRS) report, but unfortunately, it doesn’t recursively read all the subfolders and files, it only read the root folder and files as shown below:

Document Library

Show Recursive Document Library files with folders and subfolders in Reporting Service

SSRS report

Show Recursive Document Library files with folders and subfolders in SSRS Continue reading Show SharePoint Document Library files with folders and subfolders in SSRS

Auto-Populate List Form Fields Based On Lookup Selection In SharePoint

In this article, I will show

How to populate the new form fields like (Lookup field, People and Group Field) based on the selected lookup field value?


Scenario

I have two lists, One list has a lookup field called “Issue ID” that holds the ID from the second List as shown below

First List

Auto Populate List form fields based on Lookup Selection In SharePoint

Second List

Autofill List form fields based on Lookup Selection In SharePoint

When adding a new item, I would like to populate the Issue name based on the selected lookup issue ID as shown below.

Auto Populate List form fields based on Lookup Selection In SharePoint


Continue reading Auto-Populate List Form Fields Based On Lookup Selection In SharePoint