what is a report library in sharepoint

SharePoint List vs Library: The Differences (Comparison)

Last Updated on May 25, 2023

Are you wondering about the differences between SharePoint lists and libraries?

You’re not alone. Most new users get confused between these two. After all, they’re not really that much different.

In this article, I’ll go into detail regarding the differences between SharePoint list and library so you can choose better which one to use.

Let’s get started.

Table of Contents:

What is a SharePoint list?

What is a sharepoint library, what are the differences between sharepoint lists and libraries, sharepoint list or document library.

Think of a SharePoint list as a table in Excel or some database. It’s basically composed of rows (data) and columns (metadata).

The truth is, you can consider any web part in SharePoint a list when it holds some kind of information.

This includes common lists being used like:

To illustrate, here’s what a contacts list look like:

With a list, you can dynamically organize data quite easily.

It’s also easy to create a list since there are templates available ( via the modern experience ). You can also start from scratch if you prefer.

Like an Excel table, a SharePoint list also has a format, filter, and sort functionalities. These help in displaying the most important data right away.

By the way, the main reason why some people confuse SharePoint lists and libraries is because you can also attach a file or document to a list.

For example, in the sample contacts list, you will find an attachments column and when you edit an entry, you can add a file or a document to it.

Sign up for exclusive updates, tips, and strategies

SharePoint libraries are technically lists — but are designed to handle documents (which allows you to preview a document, do check-in and check-out, and many more).

In SharePoint, these special lists are also called document libraries.

Here’s an example:

As you can see, a SharePoint document library still has rows (documents) and columns (metadata).

If you right-click on a file, you will also see various options that will enable you to open, preview, share the file, and a lot more.

Now, let’s get a little deeper and talk about the actual difference between lists and libraries in SharePoint.

Here are some points:

• SharePoint lists are similar to server databases with rows and columns. You can also attach documents or files into it as “metadata”. In SharePoint libraries, documents and files are treated as the main item instead.
• Although lists technically allow you to store files, you won’t be able to check in and check out a file.
• In a document library, you can publish a file or document either as a major version or a minor version. In a list, attachments are treated as major versions right away.
• Since files and documents are the main items in a library, you can’t create an item with a file or document. But in SharePoint lists, you can create an item without the need to attach any files or documents.
• For indexing and search, attachments in a list are not indexed. That means whenever you search for a word that’s inside a document, the system will return to you the list item instead. On the other hand, if the document or file is in a SharePoint library, the search will give you the document or file right away.

A document library has one purpose — to store your documents and files. While it’s technically a list, it’s the right one to use for document storage.

Both are more or less the same with so many common functionalities. But if you need to choose one, check the type of information you want to store.

For example, if all you need is similar to a database (like keeping track of customers), then a SharePoint list is the right one to use.

But if you need something to manage your documents, then obviously, a document library is the best one for the job.

If you have any questions regarding lists and libraries in SharePoint, feel free to ask me in the comment section below.

For inquiries and concerns, send me a message through my contact page and I’ll get back to you as soon as possible.

Digital Transformation

Cloud solutions, project solutions, it and web solutions.

• Jobs Portal

• Published on December 8, 2021
• Updated on October 12, 2023
• SharePoint Online

Table of Contents

Reports from SharePoint lists

Presentation is important for pretty much any data source – and SharePoint lists are no exception. Even if you have all of your SharePoint lists filled with interesting data, it would still be more or less useless unless you can present it in an understandable fashion. Especially when it comes to reports for higher-ups, you’ll most likely need dashboards, KPIs, gauges, and so on.

Luckily enough, SharePoint does have a few reporting options that can be used in this scenario. It’s also possible to figure out that there are two basic approaches to a SharePoint list report here – to use an out-of-the-box solution, or to use a dedicated reporting solution.

In our scenario, an out-of-the-box solution is represented by the ability of SharePoint to generate custom views within the SharePoint list/page, and a dedicated reporting solution that we’ll be using as an example is Power BI.

Custom SharePoint list views

SharePoint’s own capabilities when it comes to customizing how you can view a list are quite vast, to say the least. You can generate custom views on your list, filter or sort out the specific content, and even change the viewing style of the entire page. View generation can also be done in two ways: a personal view (for yourself) and a public view (for everyone who can use the list, requires specific permissions).

To begin this process, open up your SharePoint list and click a “ View options ” menu that is located at the upper right part of the screen (it shows both the chosen viewing type and the name of the view itself – although it would most likely be “ All items ” by default in most cases).

In this menu, you can both change the view type from “ List ” to “ Gallery ” or “ Compact List ”, and you can also either choose one of your own custom views to use, or create a completely new one, with buttons like “ Create new view ”, “ Save view as ”, and so on.

Aside from the fact that SharePoint allows you to sort each of your lists in accordance to one column’s data (in alphabetical or reverse alphabetical order, for example), you can also filter out specific content in your SharePoint list in that same menu (with the “ Filter by ” button), or group the content in the same way (“ Group by … ”).

After applying all of the filtering and sorting options that you want to use, you can also save this specific set of settings, or, as it is called in SharePoint, “to save a view”. To do that, you’ll have to click the “ View options ” menu again and click the “ Save view as ” button, which would prompt you to input a name for your future view, as well as to choose between making this view public or private.

On its own, modifying your view on a SharePoint list is already technically a SharePoint list report, since it shows the same data in a more accessible way – be it by filtering out specific options or by grouping options together. However, what if we want to see actual charts and diagrams as our SharePoint list report? This is where dedicated reporting tools such as Power BI come in.

Power BI reports based on SharePoint lists

Power BI is Microsoft’s own business analytics service that aims to combine business intelligence capabilities with impressive visuals and an interface that is easy enough to work with for most end users. It is mostly used to create dashboards, reports, and so on.

It is also integrated into SharePoint quite well, with the ability to generate a comprehensive SharePoint list report in several clicks, at most. All you have to do is to get to either a library or a specific list, and find an “ Integrate ” option sitting in the upper part of your screen (on the same row of features as “ New ”, “ Share ”, “ Export ”, etc.)

The “ Integrate ” menu would most likely have several different options available, but the one we’re looking for is “ Power BI ”. After clicking the “ Power BI ” option, you’ll be presented with another option called “ Visualize the list ”. This particular button uses the entirety of your currently opened SharePoint list to generate a basic report and open it in a new tab in your browser.

This new tab is already using Power BI to generate your future SharePoint list report, and you can also customize this report in several different ways. First of all, there is an upper limit for four different categories and three measures that you can show at a time in a single Power BI report. With that in mind, you can use the menu to the right of the report to add or remove particular fields to the report – it is as simple as checking and unchecking these lines.

Additionally, if your information is numerical, Power BI allows you to change the way the information is summarized using the “Summarize” pane that shows up when you hover over an option in the menu on the right side of the screen. Here, you can choose between:

• “Median”, and several other options.

To make bigger changes to your SharePoint list report as a whole, you can use the “ Edit ” button located at the upper left part of the screen. Keep in mind that switching to edit mode is a one-way street, meaning that you won’t be able to access this page with quick report editing anymore – and Power BI itself warns you about it after you click on the “ Edit ” button.

After finalizing your changes to the report, you can use a “ Publish to the list ” button (located near the “ Edit ” button) to give a name to your report and get an option to share this report with your team. It would include all of the information that you’ve left in the report, but you won’t be able to find it in the usual library – it would be located in the same “ Integrate ” menu that you’ve used to generate this report, but now you’ll be able to see the report with the name you gave it directly under the “ Visualize this list ” button.

It should be noted that, while the “Visualize the list” functionality is included in the free version of Power BI, both the ability to publish the list for someone else to see and the ability to view someone else’s reports requires a Power BI Pro license.

Generating SharePoint list reports is not an impossible task – far from it, actually. There are both built-in and third-party solutions that can offer you different levels of functionality and customizability for your reports. It is worth noting that not all of these options would be available for any use case. 

Some of these options would be only compatible with a standalone version of SharePoint (2013, 2016, or 2019), and others are flat-out discontinued (like PowerView, which was removed from both Microsoft 365’s Excel and Excel 2021, and now Power BI is the alternative for it).

Maria Kosareva

Embark on a journey with Maria, VirtoSoftware's content maestro. Her knack for crafting articles, technical manuals, and engaging video content illuminates the intricacies of VirtoSoftware products.

Related Posts

Online Kanban Boards 2023: Comprehensive Guide, Examples, and Top Apps

• Kristina Melnikova
• Microsoft Teams , SharePoint Online
• November 20, 2023

Master Your Team’s Schedule: Best Employee Scheduling Apps Reviewed

• October 11, 2023

Best Kanban Board Apps and Integrations for Microsoft Teams to Consider in 2023 

• October 5, 2023

The Ultimate Guide to Mastering Microsoft Teams Notifications & Reminders

• September 25, 2023

A Guide to Virto Kanban Board for Microsoft Teams 

• September 11, 2023

Unlock the Potential of the Office 365 Calendar: Essential Guide, Tips, and Integrations

• July 6, 2023

• Data Protection
• Public Sector
• MSP & Channel
• Microsoft 365
• Microsoft Teams
• SharePoint / Hybrid
• CEO’s Blog

9 Killer Features of SharePoint Document Libraries

Looking for advice regarding Microsoft Teams documents? Read our latest article “ 5 Quick Tips for Managing Files in Microsoft Teams. “

New to SharePoint? Learn all about SharePoint features, tools and more with our blog series!

• What Is SharePoint? A Guide For Beginners
• How does SharePoint work?
• How to Master SharePoint Management
• 7 Helpful Office 365, SharePoint Customization Best Practices
• 4 Essential Content Management Tips for SharePoint Online

SharePoint document libraries are like super folders. They provide a useful way to separate your files and folders to keep things clean and organized within a SharePoint site. In this post, we’ll cover some of the best things about libraries and why you want to make the most of them. Libraries aren’t just some replacement for old shared or network drives. No, no: they’re a major upgrade to the old-school file share systems.

Here’s a helpful infographic to remind you what document libraries can do. But let’s talk some specifics below.

Okay, not a killer feature. But one you’re used to and one that makes the SharePoint experience pretty similar to what you’ve been using for a while if you’re still on network drives. Organize your files in folders and subfolders to keep things clean! If they help you feel better about SharePoint, that would make folders a killer feature in my book.

2. Co-Authoring

Ever been hit with the dreaded “This file is locked for editing” pop-up? That pop-up is a thing of the past thanks to co-authoring. Co-authoring—available in SharePoint 2013, 2016, and Online with Office 2013 or 2016—lets you and your colleagues edit the same file at the same time. At first, you may feel like you’ve lost control. You haven’t. Co-authoring eases the collaboration and review process immensely. And if you’re worried about others editing your files, consider keeping them in OneDrive or restricting the permissions until you’re ready to share.

Learn how to deploy Office 365 backup to ensure you can restore SharePoint items at a granular level without needing to roll back the entire library.

3. Offline Syncing

If you’re using SharePoint 2016 or Online, you can sync files from a document library to your computer, tablet, or mobile device with the OneDrive app . That means you can be working on shared files where you have no wi-fi (airplane, anyone?) and OneDrive will automatically push the updated file to the cloud the next time you get connected.

4. Groups, Yammer, and Teams

If you use Outlook Groups, Yammer  Feeds, or Microsoft Teams , you know they each have a place to save files. But did you know those file folders are in a SharePoint site that was created specifically for that Group, Feed, or Team? Yes indeed . While many of the SharePoint features aren’t (yet) available directly in those apps, you can always open the library in SharePoint for all the goodness that I’m covering in this post.

5. Metadata

In many cases, you need to be able to categorize your files in multiple ways. Maybe by year, office location, and document type, for instance. If you use folders, you’re stuck with one arbitrary way. You may prefer Office Location > Year > Document Type. Your colleague may prefer Year > Document Type > Office Location. It really depends on how you think and what type of work you do. But thanks to metadata, you can tag files with these multiple ideas then sort and filter your library to display the files however you prefer. Learn the basics of metadata here .

If you end up liking metadata and how you can sort and filter to show what you want, how you want it, you’ll like how SharePoint gives you the option to save that setup as a view. Once you create a view, you don’t have to manually sort and filter each time you load the library. Learn more about views here .

7. Version History

Have you ever saved a file and realized, “Whoops, I saved it after doing a lot of unintended damage. I need the old copy back!” File shares don’t have a built-in way to go back. Document libraries do. Version history lets you restore old versions, delete versions that are no longer relevant, and even revert changes made by others that you don’t want to keep. Learn more about version history here .

Did you know you can get an automated email notification if someone makes a change to a file, uploads a new file, or deletes a file in your library? This is extremely handy when you have a document out for review and want to know when your reviewers went in to make comments. Learn more about alerts here .

Instead of just uploading files, sometimes you also want quick access to links that point to other websites (even public ones). Document libraries in SharePoint 2013 need a quick tweak to enable links; libraries in SharePoint 2016 and Online include links from the start. Link away!

I hope you find these features as useful as I have. I use all these at least sometimes when using document libraries and find they really come in handy, especially when I remember all the amazing things a seemingly simple document library can do. Keep that infographic handy, too. It’s a nice way to remind yourself what you’re able to do.

Parting tip: if you’re still using SharePoint 2010 or 2013, it’s time to pester your IT department to upgrade to SharePoint 2016 or SharePoint Online . Many of these features are only available in those versions (or are at least significantly improved by them). You’ll be glad you made the upgrade.

The Conference Modern Workplace Pros Don’t Want To Miss

Find this document libraries post useful? Subscribe to our blog for more SharePoint tips!

• document libraries
• sharepoint document libraries
• SharePoint Online

Hey, Matt – thanks for another great post, and infographic.

Re items 1 and 5, where Folders may leave you “stuck with one arbitrary way” of categorizing files, compared to Metadata. There’s a way to mitigate that, using both folders and metadata.

Here’s the challenge: Many content owners see their folders as anything but arbitrary, and are unwilling to give them up to rely solely on metadata. Some owners may also want to set different permissions on different folders, but have all content available in the same library.

Unfortunately it’s a pain for the content consumers, who do see those folders as both arbitrary, and difficult to browse through.

In those scenarios, it may help to use both folders and metadata, and then create a “flat” view that shows all items without folders. Now your users will have a security-trimmed view that lets them sort and filter all files that they are allowed to see from across the entire library, without respect to how the content owner(s) chose to organize them.

Agreed! That’s a tad higher level than this intro, but I do recommend this on a regular basis.

The main issue I run into with using metadata instead of folders is when users need to be able to open a pdf in Acrobat so they can edit. You can browse a SP library and use metadata to find a pdf document, but from there you can only view. If you connect to a SP site using Acrobat (which you can’t if you turn on require modern authentication), you can browse in a file explorer way, but metadata is useless at that point because it can’t be viewed/used. Same if you sync a library with OneDrive, metadata isn’t available in OneDrive desktop client. As much as I’d like to use metadata instead of folders, there are several use cases that metadata isn’t available for use by the end user. What do you suggest?

LEAVE A REPLY Cancel reply

Save my name, email, and website in this browser for the next time I comment.

More Stories

#shifthappens Conference 2023: Final Day Wrap-Up

#shifthappens conference day 2: embracing the shift together.

#shifthappens Conference 2023: Recapping All the Action from Day 1

• Partner Network
• Investor Relations
• All Products
• Cloud Products
• Hybrid Products
• Operational
• Information Lifecycle Management
• Account Portal
• User Guides
• Terms & Conditions
• Trust Center
• Privacy Policy

© 2023 AvePoint, Inc. All Rights Reserved.

Subscribe to our blog

Receive weekly digests delivered to your inbox.

Abonnieren Sie unseren Blog

Erhalten Sie unseren wöchentlichen Newsletter direkt in Ihr Postfach.

Abonnez vous à notre blog

Recevez des newsletters hebdomadaires dans votre boîte de réception.

AvePoint ニュースレターを購読する

AvePoint ブログ更新情報など、便利なお知らせが満載の ニュースレターをメールで配信しています。是非ご購読ください。

每週接收郵件閱讀我們的部落格

• What is a document library in SharePoint

This SharePoint tutorial explains, what is a document library in SharePoint 2013? what are various out of box library templates in SharePoint 2013/2016/Online? How to create a document library in SharePoint Online ?

We will see how to upload documents into a document library, quick edit documents, edit document properties, check-in and check out a document in SharePoint 2013 document library.

Also, we will see how to work with versions in a document library, check version history, restore the previous version of a document, how to follow, document and delete a document from a document library in SharePoint.

Table of Contents

SharePoint document libraries are a special kind of list which are used to store documents. Each file is known as an item in the document library in SharePoint.

We can use document libraries to store documents on the SharePoint site so that other employees can find and work with and should be able to access it from any device.

Unlike the list which is used to store data, libraries are used to store files. Like the list, libraries will also have metadata which will be helpful to find, sort, filter, and group items in the document libraries.

Whenever you will create a site using Team site template, by default it will add a Document library known as Documents.

• Out of box document libraries in SharePoint

SharePoint provides various templates for document libraries likes: Document Library, Form Library, Wiki Page Library, Picture Library, Asset Library, Data Connection Library, Report Library, etc. You can create various libraries using the above templates.

• Document Library – A place for strong documents or other files that you want to share. Document libraries allow folders, versioning, and check out.
• Asset Library – A place to share, browse and manage rich media assets, like images, audio and video files.
• Picture Library – A place to upload and share pictures.
• Report Library – A place where you can easily create and manage web pages and documents to track metrics, goals, and business intelligence information.
• Slide Library – Create a slide library when you want to share slides from Microsoft Office PowerPoint, or a compatible application. Slide libraries also provide special features for finding, managing, and reusing slides.
• Wiki Page Library – An interconnected set of easily editable web pages, which can contain text, images, and web parts.
• Data Connection Library – A place where you can easily share files that contain information about external data connections.
• Form Library – A place to manage business forms like status reports or purchase orders. Form libraries require a compatible XML editor, such as Microsoft InfoPath. (To be covered in Infopath chapter)
• Create Document Library in SharePoint

Now, we will see how to create a document library in SharePoint Online or SharePoint 2013/2016/2019.

To create a document library, Open your SharePoint 2016 site and then click on the gear icon and then click on Add an app like below:

Then from Your Apps page, you can select the document library template from the available templates.

Then it will ask for a name for the document library and click on Create .

Once it is created successfully, the Site Contents page will open and the document library will be available there.

Click on the Document library name to open the SharePoint document library.

By default the document library will look like below:

Also, read some SharePoint online tutorials:

• SharePoint Online modern experience
• How to move from classic to modern experience in SharePoint online list or document library?
• Upload Documents to a Document Library

To upload a document to a document library in SharePoint , click on the Upload button which will open the “Add a document” dialog box like below:

Once you click on OK , it will show the progress as well like below:

• Drag and Drop files to Document Library

You can also drag and drop files to upload a document to the SharePoint document library . Simply drag and drop like below:

• Create Column for Document Library

We can add additional columns to the SharePoint document library. To add a column from Ribbon click on the LIBRARY tab and then click on Create Column like below:

This will open the Create Column dialog box like below. Give a name, choose a type for column, Description. Few sections will change based on the data type you select. Here we will try to add a choice column.

To add choices to the choices column, go to “Type each choice on a separate line” section and add the options in a separate line.

Read another SharePoint tutorial:

• Document Set in SharePoint 2013

The choice options can appear in Drop-down list, Radio buttons or Checkboxes. Choose the option from Display Choices using section.

In the default value section, you can select the option in the Default Value section. Various other options will appear when you will click on the ECB menu which looks like below:

The above options are specific to documents.

• Quick Edit in a SharePoint document library

We can edit the SharePoint document properties by using the Quick Edit button which is available in the ribbon. Here you can edit like datasheet view.

Once edit over click on the Stop editing this list button which will Save the changes.

• Edit Document in a SharePoint document library

You can click on the document name to edit the document in SharePoint. It may ask you to enter credentials like below:

Once you modify the document, Click on the Save icon to Save the document and then close the document.

• Edit Document Properties

To edit document properties, click on the ECB menu and then click on “Properties” like below:

Then it will open the Edit Properties windows. Modify and Save the changes.

• Check Out and Check-in Document in SharePoint document library

Check in and check out is a good feature in SharePoint. When you check out a file, you lock the file for editing to prevent other users from editing the file at the same time. When you have finished editing the file, you check the file back in, allowing other users to edit the file.

Also, you can check out the document from the ECB menu like below:

Once you check out a file, a check out symbol will appear like below:

After modification, you can check in the document, so that the changes will be available to other users. Select the document and then from the ribbon, go to the FILES tab and then click on Check-in.

In the Check in the dialog box, it will ask for if you want to Retain your check out after checking in? And also it will add Comments like below:

• Working with Versions in a SharePoint document library

When versioning is enabled, SharePoint Foundation 2013 creates a separate copy of the document each time it is edited. Although this takes up extra space on the server, it also makes it easy to revert to an older version of the document if necessary.

You can keep major versions only, or major and minor versions. Major versions are whole numbers such as 1, 2, 3, and so on. Minor versions are decimals such as 1.1, 1.2, 1.3, and on. A major version number is associated with a version that has been published. A minor version number is associated with a version that is in progress but is not yet published.

• Check Version History of a Single Document in SharePoint document library

You can individually see the versions of a particular document. Select an individual document and then click on the Version History button in the ribbon which will open the Version History dialog box with all the versions of the document.

• Restore the Previous Version of a document in document library

To restore any previous version, click on version and then click on Restore as shown in the fig below:

• Follow, Download and Delete Document from Document Library

You can follow, download and delete a document from the buttons available in the Ribbon (FILES) tab in the document library.

• Setup Alert in a document library

Settings up alert are the same as setting up an alert for the list which you can check out: Setting up Alerts in SharePoint Online list .

SharePoint 2013 includes the ability to follow documents to track their updates in your newsfeed. Whereas setting an alert for document changes keeps you notified of specific changes on a predefined frequency via email or SMS, following a document adds a link to this document in your newsfeed and provides notifications of all document changes via your newsfeed.

In addition, people who are following you will get a newsfeed notification that you’re following this document, provided that they have appropriate permissions to access it. All documents that you follow are shown in one place in your newsfeed, in the list of followed documents.

• Few Points to remember in SharePoint document library

Below are a few points you should remember about SharePoint document library.

• In a document library, the default maximum file size is 250 MB, but this can be increased up to 2 GB.
• There can be 30,000,000 documents stored inside a document library. You can create a folder for the same.
• You can have 400,000 major versions inside a document library. If you exceed this limit, basic file operations: such as file open or save, delete, and viewing the version history, might fail.
• The maximum number of minor file versions is 511. This limit cannot be exceeded.
• SharePoint allows a maximum of 100 items to be selected for bulk operations in the user interface.
• SharePoint supports up to 12 lookup fields which are also known as List view lookup threshold.
• List view threshold is 5000 per normal users and 20,000 for auditor or administrator with appropriate permissions.
• In terms of Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files, there can be 10 concurrent editors per document. The boundary is 99.

You must check out this item before making changes. Do you want to check out this item now?

Recently one of my clients said, in one of the document library in SharePoint Online, it is asking to check out before modification, but in another document library it is not asking. The message it is showing as “ You must check out this item before making changes. Do you want to check out this item now? ” It shows like below:

• You must check out this item before making changes

We need to change the Require Check Out option. For this: Open document library settings page and then click on Versioning settings which is under General Settings .

Then in the Versioning Settings page, go to the “ Require Check Out ” option and choose “No” for “ Require documents to be checked out before they can be edited? “. It should look like below:

After this setting, it will not ask to check out the file before modification. This is how to fix the error, You must check out this item before making changes. Do you want to check out this item now?

You may like following SharePoint document library tutorial:

• PowerApps upload file to SharePoint Online document library using Microsoft Flow
• How to add Link to a Document library in SharePoint Online/2013/2016
• Add multiple Office templates as a content type to a document library in SharePoint Online/2013/2016
• Rating and Generate File plan Report in SharePoint 2013/2016 Document Library
• SharePoint Unique Permissions to List & Document Library in SharePoint Online Step by Step Tutorial
• Sync SharePoint Online Document Library with OneDrive and Work with Files Offline
• Migrate files or documents from File Shares to SharePoint Online document library Using FREE Microsoft SharePoint Migration Tool

In this SharePoint tutorial, we learned how to work with SharePoint document library. We discussed the below things:

I am Bijay a Microsoft MVP (10 times – My MVP Profile ) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com

Session expired

Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

how to generate a report for files and folders access level in sharepoint

I need to generate a report that shows each user's access to each file and folder in the document library in Sharepoint (O365). Can you please help me? I need it and I need it urgently.

Your assistance is highly appreciated!

SharePoint A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications. 8,541 questions Sign in to follow

Hi @Sasan , do you have any progress on this thread? Please feel free to let us know if you need further assistance.

Hi @Sasan , if you find an Answer helpful, please remember to accept it as answer. If you manage to solve the problem yourself, please share your solution as a new Answer in this thread and accept it as answer. It will help others who meet similar questions in this forum. Thank you for your understanding.

This is one I use for management: sharepoint-online-powershell-script-to-view-permissions-on-library-folders

Here is a sample script to generate a report for Library, Folder, Item level permissions, please find it in attachment: 23686-librarypermissionreport.txt

Reference: SharePoint Online: Get Document Library Permissions and Export to CSV using PnP PowerShell.

If an Answer is helpful, please click " Accept Answer " and upvote it. **Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **

This is promising and EXACTLY what I need for a client but am getting this error: "Error Generating List Permission Report! Value does not fall within the expected range."

I have used this script in the past and is exactly what I need Good work on this and easy to understand for someone new to Powershell like me.

I have used this script to generate Site reports for a client previously without any issues, until now. I have another client, which I need to generate the same reports from his tenant. I had to tweak the script a bit, since 2FA is enabled and the way it was coded to sign in, was not working correctly.

Another issue that I'm facing is that near the end of generating the report I'm getting this error:

Error Generating List Permission Report! The cloud operation was not completed before the time-out period expired.

Any help would be really appreciated, as this has been on my mind for the past couple of weeks now!

Thanks in advance! Brian

Hello, I'm new to this and get the following error when running the script without make changes? Error Generating List Permission Report! Invalid URI: The format of the URI could not be determined.

• Power Apps Community
• Welcome to the Community!
• News & Announcements
• Get Help with Power Apps
• Building Power Apps
• Microsoft Dataverse
• Power Apps Governance and Administering
• Power Apps Pro Dev & ISV
• Power Apps Portals
• Connector Development
• Power Query
• GCC, GCCH, DoD - Federal App Makers (FAM)
• Power Platform Integration - Better Together!
• Power Platform Integrations
• Power Platform and Dynamics 365 Integrations
• Community Blog
• Power Apps Community Blog
• Community Connections & How-To Videos
• Community App Samples
• Webinars and Video Gallery
• Canvas Apps Components Samples
• Emergency Response Gallery
• 2021 MSBizAppsSummit Gallery
• 2020 MSBizAppsSummit Gallery
• 2019 MSBizAppsSummit Gallery
• Community Engagement
• Community Calls Conversations
• Hack Together: Power Platform AI Global Hack
• Experimental
• Error Handling
• Power Apps Experimental Features
• Community Support
• Community Accounts & Registration
• Using the Community
• Community Feedback
• Edit properties of a record in a Sharepoint librar...
• Subscribe to RSS Feed
• Mark Topic as New
• Mark Topic as Read
• Float this Topic for Current User
• Printer Friendly Page
• All forum topics
• Previous Topic

• Mark as New
• Report Inappropriate Content

Edit properties of a record in a Sharepoint library via a Form in Power Apps

Solved! Go to Solution.

• General Questions

View solution in original post

Helpful resources

Back to Basics Tuesday Tip #10: Community Support

This is the TENTH post in our ongoing series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!   This Week: All About Community Support   Whether you're a seasoned community veteran or just getting started, you may need a bit of help from time to time! If you need to share feedback with the Community Engagement team about the community or are looking for ways we can assist you with user groups, events, or something else, Community Support is the place to start.   Community Support is part of every one of our communities, accessible to all our community members.     Power Apps: https://powerusers.microsoft.com/t5/Community-Support/ct-p/pa_community_support Power Automate: https://powerusers.microsoft.com/t5/Community-Support/ct-p/mpa_community_support Power Pages: https://powerusers.microsoft.com/t5/Community-Support/ct-p/mpp_community_support Copilot Studio: https://powerusers.microsoft.com/t5/Community-Support/ct-p/pva_community-support   Within each community's Community Support page, you'll find three distinct areas, each with a different focus to help you when you need support from us most.     Community Accounts & Registration is the go-to source for any and all information related to your account here in the community. It's full of great knowledge base articles that will help you manage your community account and know what steps to take if you wish to close your account.  ●  Power Apps  ●  Power Automate  ●  Power Pages, ●  Copilot Studio      Using the Community is your source for assistance with everything from Community User Groups to FAQ's and more. If you want to know what kudos are, how badges work, how to level up your User Group or something else, you will probably find the answers here. ●  Power Apps   ● Power Automate    ●  Power Pages  ●  Copilot Studio      Community Feedback is where you can share opportunities, concerns, or get information from the Community Engagement team. It's your best place to post a question about an issue you're having in the community, a general question you need answered. Whatever it is, visit Community Feedback to get the answers you need right away. Our team is honored to partner with you and can't wait to help you!   ●  Power Apps  ● Power Automate   ● Power Pages   ● Copilot Studio  

Microsoft Ignite 2023: The Recap

What an amazing event we had this year, as Microsoft showcased the latest advancements in how AI has the potential to reshape how customers, partners and developers strategize the future of work. Check out below some of our handpicked videos and Ignite announcements to see how Microsoft is driving real change for users and businesses across the globe.   Video Highlights Click the image below to check out a selection of Ignite 2023 videos, including the "Microsoft Cloud in the era of AI" keynote from Scott Guthrie, Charles Lamanna, Arun Ulag, Sarah Bird, Rani Borkar, Eric Boyd, Erin Chapple, Ali Ghodsi, and Seth Juarez. There's also a great breakdown of the amazing Microsoft Copilot Studio with Omar Aftab, Gary Pretty, and Kendra Springer, plus exciting sessions from Rajesh Jha, Jared Spataro, Ryan Jones, Zohar Raz, and many more.     Blog Announcements Microsoft Copilot presents an opportunity to reimagine the way we work—turning natural language into the most powerful productivity tool on the planet. With AI, organizations can unearth value in data across productivity tools like business applications and Microsoft 365. Click the link below to find out more.     Check out the latest features in Microsoft Power Apps that will help developers create AI-infused apps faster, give administrators more control over managing thousands of Microsoft Power Platform makers at scale, and deliver better experiences to users around the world. Click the image below to find out more.     Click below to discover new ways to orchestrate business processes across your organization with Copilot in Power Automate. With its user-friendly interface that offers hundreds of prebuilt drag-and-drop actions, more customers have been able to benefit from the power of automation.     Discover how Microsoft Power Platform and Microsoft Dataverse are activating the strength of your enterprise data using AI, the announcement of “plugins for Microsoft Copilot for Microsoft 365”, plus two new Power Apps creator experiences using Excel and natural language.       Click below to find out more about the general availability of Microsoft Fabric and the public preview of Copilot in Microsoft Fabric. With the launch of these next-generation analytics tools, you can empower your data teams to easily scale the demand on your growing business.     And for the rest of all the good stuff, click the link below to visit the Microsoft Ignite 2023 "Book of News", with over ONE HUNDRED announcements across infrastructure, data, security, new tools, AI, and everything else in-between!        

Back to Basics Tuesday Tip #9: All About the Galleries

This is the ninth post in our series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!     Today's Tip: All About the Galleries Have you checked out the library of content in our galleries? Whether you're looking for the latest info on an upcoming event, a helpful webinar, or tips and tricks from some of our most experienced community members, our galleries are full of the latest and greatest video content for the Power Platform communities.   There are several different galleries in each community, but we recommend checking these out first:   Community Connections & How-To Videos Hosted by members of the Power Platform Community Engagement  Team and featuring community members from around the world, these helpful videos are a great way to "kick the tires" of Power Platform and find out more about your fellow community members! Check them out in Power Apps, Power Automate, Power Pages, and Copilot Studio!         Webinars & Video Gallery Each community has its own unique webinars and videos highlighting some of the great work being done across the Power Platform. Watch tutorials and demos by Microsoft staff, partners, and community gurus! Check them out: Power Apps Webinars & Video Gallery Power Automate Webinars & Video Gallery Power Pages Webinars & Video Gallery Copilot Studio Webinars & Video Gallery   Events Whether it's the excitement of the Microsoft Power Platform Conference, a local event near you, or one of the many other in-person and virtual connection opportunities around the world, this is the place to find out more about all the Power Platform-centered events. Power Apps Events Power Automate Events Power Pages Events Copilot Studio Events   Unique Galleries to Each Community Because each area of Power Platform has its own unique features and benefits, there are areas of the galleries dedicated specifically to videos about that product. Whether it's Power Apps samples from the community or the Power Automate Cookbook highlighting unique flows, the Bot Sharing Gallery in Copilot Studio or Front-End Code Samples in Power Pages, there's a gallery for you!   Check out each community's gallery today! Power Apps Gallery Power Automate Gallery Power Pages Gallery Copilot Studio Gallery

Unlocking the Power of Community: A Journey with Featued User Group leaders Geetha Sivasailam and Ben McMann

In the bustling world of technology, two dynamic leaders, Geetha Sivasailam and Ben McMann, have been at the forefront, steering the ship of the Dallas Fort Worth Power Platform User Group since its inception in February 2019. As Practice Lead (Power Platform | Fusion Dev) at Lantern, Geetha brings a wealth of consulting experience, while Ben, a key member of the Studio Leadership team at Lantern, specializes in crafting strategies that leverage Microsoft digital technologies to transform business models.   Empowering Through Community Leadership Geetha and Ben's journey as user group leaders began with a simple yet powerful goal: to create a space where individuals across the DFW area could connect, grow their skills, and add value to their businesses through the Power Platform. The platform, known for its versatility, allows users to achieve more with less code and foster creativity.   The Power of Community Impact Reflecting on their experiences, Geetha and Ben emphasize the profound impact that community engagement has had on both their professional and personal lives. The Power Platform community, they note, is a wellspring of resources and opportunities, fostering continuous learning, skill enhancement, and networking with industry experts and peers.   Favorite Moments and Words of Wisdom The duo's favorite aspect of leading the user group lies in witnessing the transformative projects and innovations community members create with the Power Platform. Their advice to aspiring user group leaders? "Encourage diverse perspectives, maintain an open space for idea-sharing, stay curious, and, most importantly, have fun building a vibrant community."   Building Bridges, Breaking Barriers Geetha and Ben encourage others to step into the realm of user group leadership, citing the rewarding experience of creating and nurturing a community of like-minded individuals. They highlight the chance to influence, impact, and positively guide others, fostering connections that extend beyond mere technology discussions.   Joining a User Group: A Gateway to Growth The leaders stress the importance of joining a user group, emphasizing exposure to diverse perspectives, solutions, and career growth opportunities within the Power Platform community. "Being part of such a group provides a supportive environment for seeking advice, sharing experiences, and navigating challenges."   A Year of Milestones Looking back at the past year, Geetha and Ben express pride in the group's growth and global participation. They recount the enriching experience of meeting members in person at the Microsoft Power Platform conference, showcasing the diverse range of perspectives and guest speakers that enriched the community's overall experience.   Continuous Learning on the Leadership Journey As user group leaders, Geetha and Ben recognize the continuous learning curve, blending interpersonal skills, adaptability, and dedication to foster a vibrant community. They highlight the importance of patience, persistence, and flexibility in achieving group goals, noting the significance of listening to the needs and suggestions of group members.They invite all tech enthusiasts to join the Dallas Fort Worth Power Platform User Group, a thriving hub where the power of community propels individuals to new heights in the dynamic realm of technology.

Visit the Community Lounge at Microsoft Ignite!

Are you attending Microsoft Ignite in Seattle this week? If so, we'd love to see you at the Community Lounge! Hosted by members of our Community team, it's a great place to connect, meet some Microsoft executives, and get a sticker or two. And if you're an MVP there are some special opportunities to meet up!     The Community Lounge is more than just a space—it's a hub of activity, collaboration, and camaraderie. So, dive in, explore, and make the most of your Microsoft Ignite experience by immersing yourself in the vibrant and dynamic community that awaits you.Find out the schedule and all the details here: Community Lounge at Ignite! See you at #MSIgnite!    

Back to Basics Tuesday Tip #8: Subscriptions & Notifications

This is the eighth post in our series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!   This Week: All About Subscriptions & Notifications Subscribing to a CategorySubscribing to a TopicSubscribing to a LabelBookmarksManaging & Viewing your Subscriptions & BookmarksA Note on Following Friends on Mobile   Subscriptions ensure that you receive automated messages about the most recent posts and replies. There are multiple ways you can subscribe to content and boards in the community! (Please note: if you have created an AAD (Azure Active Directory) account you won't be able to receive e-mail notifications.)   Subscribing to a Category  When you're looking at the entire category, select from the Options drop down and choose Subscribe.   You can then choose to Subscribe to all of the boards or select only the boards you want to receive notifications. When you're satisfied with your choices, click Save.   Subscribing to a Topic You can also subscribe to a single topic by clicking Subscribe from the Options drop down menu, while you are viewing the topic or in the General board overview, respectively.   Subscribing to a Label You can find the labels at the bottom left of a post.From a particular post with a label, click on the label to filter by that label.          This opens a window containing a list of posts with the label you have selected. Click Subscribe.   Note: You can only subscribe to a label at the board level. If you subscribe to a label named 'Copilot' at board #1, it will not automatically subscribe you to an identically named label at board #2. You will have to subscribe twice, once at each board.   Bookmarks Just like you can subscribe to topics and categories, you can also bookmark topics and boards from the same menus! Simply go to the Topic Options drop down menu to bookmark a topic or the Options drop down to bookmark a board.   The difference between subscribing and bookmarking is that subscriptions provide you with notifications, whereas bookmarks provide you a static way of easily accessing your favorite boards from the My subscriptions area.   Managing & Viewing Your Subscriptions & Bookmarks To manage your subscriptions, click on your avatar and select My subscriptions from the drop-down menu. From the Subscriptions & Notifications tab, you can manage your subscriptions, including your e-mail subscription options, your bookmarks, your notification settings, and your email notification format.     You can see a list of all your subscriptions and bookmarks and choose which ones to delete, either individually or in bulk, by checking multiple boxes.     A Note on Following Friends on Mobile Adding someone as a friend or selecting Follow in the mobile view does not allow you to subscribe to their activity feed. You will merely be able to see your friends’ biography, other personal information, or online status, and send messages more quickly by choosing who to send the message to from a list, as opposed to having to search by username.              

SharePoint in operator delegation warning

• Remember me Not recommended on shared computers

Forgot your password?

• Join the Community
• Download Jaspersoft

JasperReports® Library Community Edition 6.20.6

By Guest IPS Temp Admin

1 Screenshot

Description

The JasperReports Library is the world's most popular open source reporting engine written entirely in Java. It can use data from any source and produce pixel-perfect documents that can be viewed, printed, or exported in a variety of formats including HTML, PDF, Excel, OpenOffice, and Word.

Basic Features 

• Embeddable Java Report Engine
• Pixel-perfect report generation
• Output to PDF, HTML, CSV, XLS, TXT, RTF and more

License Type 

We highly encourage you to read more about the LGPL License associated with JasperReports® Library Community Edition to understand any risks/challenges and consult with your Legal counsel. If you or your organization has a policy against using software governed by the LGPL or GNU Affero GPL, a commercial subscription may also be of interest to you.

Interested in Professional Licensing? 

If you are looking for more features, better support, and improved scalability, security, and integration capabilities, professional licensing provides organizations with the following advantages: 

• Flash Charts
• Flash Widgets
• Support : Certified platform support for operating system, application servers, or databases; guaranteed support covering mission-critical production applications and/or older releases; and managed release cycles that offer product enhancements rolled up into fewer releases. 
• Legal Matters : Product warranties and indemnification are included offering users assurances that the information they have relied upon is correct and also that any risk to them is limited.
• Scalability : Designed for enterprise-level deployments and built to scale supporting large numbers of users and data sources. 
• Security : Advanced security features such as data encryption, user authentication, and role-based access control with multi-tenant support are included to help organizations protect sensitive data and prevent unauthorized access to reports.
• Integration : The commercial version of Jaspersoft simplifies integration within your application and includes other enterprise software platforms, such as Salesforce, SAP, and Microsoft SharePoint. This can help organizations to streamline workflows and improve efficiency.
• Customization : More customization options allowing organizations to tailor reports and dashboards to specific business needs helping to create more relevant and actionable reports.

Take a 30-day trial of our Jaspersoft BI Enterprise

What's New in Version 6.20.6    See changelog

Released November 9

• 6.20.5 November 9
• 1.0.0 November 9
• 1.0.0 November 7
• Knowledge Base
• Documentation
• All Activity
• Create New...

© 2023 Cloud Software Group , Inc. All rights reserved

• Terms of Use
• Privacy Policy
• Cookie preferences
• JasperReports Server
• JasperReports Library
• Jaspersoft Studio
• Jaspersoft Cloud BI

University Libraries

• Contact a Librarian
• Databases A-Z
• Guides by Subject
• Resources by Type
• Find Books & Articles
• Government Information
• Iowa Digital Library
• Iowa Research Online
• Special Collections & University Archives
• Iowa Women's Archives
• Course Reserves
• Office Delivery
• Borrowing From Another Library & Document Delivery
• Undergraduate Research Services (The SEAM)
• Research Consultations
• Instructional Services
• Research Data Services
• Open Educational Resources
• Distance Education
• Scholarly Publishing & Copyright
• More services...
• Check My Account
• Renew My Books
• My Interlibrary Loan
• Recommend Library Purchase
• EndNote Basic
• Departments
• Collection Management
• Diversity, Equity, and Inclusion
• Publications, Plans & Reports
• Make a Gift
• History of the Library
• For the Media
• Research Guides & Tutorials
• Directions & Maps
• Assistance for Users with Disabilities
• All Campus Libraries
• Learning Commons
• Main Library Gallery
• Art Library
• Business Library
• Engineering Library
• Health Sciences Library
• Law Library
• Music Library
• Sciences Library
• Contact a Librarian or the UI Libraries
• Staff directory by name
• Staff directory by organizational unit
• Campus Libraries

CINE:3361 Screenwriting: Short Form - Elgin, Fall 2023: Home

• Library Resources
• Online Resources

Library Links

• InfoHawk+ InfoHawk+ is the University of Iowa Libraries' catalog and provides information about books, articles, and media. This is typically the best place to start your research.
• WorldCat The world's most comprehensive catalog of items held by libraries, particularly libraries in North America. WorldCat is valuable for finding items that have been published but are not held at the University of Iowa Libraries.
• Interlibrary Loan (ILL) Found an item, but we don't have it? ILL it! Log in and provide information about the item you would like to borrow from another library.
• Recommend a Purchase Is there a book, journal, DVD, or database you think the University of Iowa Libraries should purchase? Submit a suggestion!
• Have a different question? The Library FAQ's have answers to many of your library questions.

Special Collections

Don't forget to utilize Special Collections for their holdings related to film, scripts, and production. You can email them at [email protected] . You might be surprised at what we have! Here's a hint about some of our holdings..."Live Long and Prosper."

Welcome to the guide for CINE:3661, Screenwriting: Short Form with Bruce Elgin. Due to the varied nature of your writing projects, this guide will address research and library resources in a broad overview. If you encounter roadblocks while researching, reach out to a librarian . We are here to help!

Staying current on topics around the world can provide lots of inspiration for your writing. We have a number of regional, national, and international newspapers available in The Perch (1st Floor Main) or its corresponding guide .

The New York Times requires an individual account - University of Iowa students and staff can  create an account here  for enhanced access to The New York Times - digital edition. Then log in at  www.nytimes.com .

Land Acknowledgement

The University of Iowa is located on the homelands of the Ojibwe/Anishinaabe (Chippewa), Báxoǰe (Iowa), Kiikaapoi (Kickapoo), Omāēqnomenēwak (Menominee), Myaamiaki (Miami), Nutachi (Missouri), Umoⁿhoⁿ (Omaha), Wahzhazhe (Osage), Jiwere (Otoe), Odawaa (Ottawa), Póⁿka (Ponca), Bodéwadmi/Neshnabé (Potawatomi), Meskwaki/Nemahahaki/Sakiwaki (Sac and Fox), Dakota/Lakota/Nakoda (Sioux), Sahnish/Nuxbaaga/Nuweta (Three Affiliated Tribes) and Ho-Chunk (Winnebago) Nations. The following tribal nations, Umoⁿhoⁿ (Omaha Tribe of Nebraska and Iowa), Póⁿka (Ponca Tribe of Nebraska), Meskwaki (Sac and Fox of the Mississippi in Iowa), and Ho-Chunk (Winnebago Tribe of Nebraska) Nations continue to thrive in the State of Iowa and we continue to acknowledge them.

Click here for the Acknowledgement of Land and Sovereignty from the UI Native American Council.

• Next: Library Resources >>
• Last Updated: Nov 27, 2023 12:07 PM
• URL: https://guides.lib.uiowa.edu/cine3361