Microsoft data list

Set up metadata navigation for a list or library. Manage lists and libraries with many items. Note: Note that the information here and the types of lists available to you depend on the version of SharePoint you are using.

Select a heading below to open it and see the detailed information. Organizations typically use many types of lists, including links, announcements, contacts, issue tracking, and surveys, to name a few. Lists can also include tasks that you can use as a focal point for team collaboration or in a business solution. In many cases, lists can provide quick, effective solutions with little or no modifications.

Tasks Include tracking of ownership and progress as well as an in-page timeline for an attractive visual presentation the list content. Issue tracking Includes versioning and version-history storage, for deeper analysis of workgroup projects and common work tasks.

Lists are rich and flexible and have many built-in features that provide a robust way to store, share, and work with data.

You can also attach one or more files to a list item to provide additional details, such as a spreadsheet containing supporting numbers or a document containing background information. Create list views to organize, sort, and filter data in different and specific ways; change the metadata, such as adding and deleting columns, and modifying validation rules; and use lists consistently across sites with content types, site columns, and templates.

For example, you can view just the current events from a calendar on a home page and create a visual view — similar to a wall calendar — on another page. Create relationships between lists by using a combination of unique columns, lookup columns, and relationship enforcement cascade and restrict delete , all of which enhance your ability to create more sophisticated business solutions and help preserve the integrity of your data. Create custom lists, display the data in Web Parts and Web Part Pages, and import, export, and link to data from other programs, such as Excel and Access.

Track versions and detailed history, require approval to modify data, use item-level and folder security, check-in and check-out, and automatically stay informed about changes by using alerts and RSS feeds. Organize content in a single list into folders for added convenience and better performance, and improve performance in general with large lists by using indexing. The following are some ways you can work with lists to help you to manage information for your group.

Track versions and detailed history Track versions of list items , so that you can see which items have changed from version to version, as well as who changed the list items. If mistakes are made in a newer version, you can restore a previous version of an item. Tracking the history of a list is especially important if your organization needs to monitor a list as it evolves.

Require approval Specify that approval for a list item is required before it can be viewed by everyone. Items remain in a pending state until they are approved or rejected by someone who has permission to approve them.

You can control which groups of users can view a list item before it is approved. Customize permissions Specify whether participants for your list can read and edit only the items they created or all items in the list.

People who have permission to manage lists can read and edit all list items. You can also apply specific permission levels to a single list item, for example, if the item contains confidential information. Create and manage views Create different views of the same list. The contents of the actual list don't change, but the items are organized or filtered so that people can find the most important or interesting information, depending on their needs.

Update lists Regardless of the type of list you are updating the process is similar for adding, editing, and deleting list items. If the list is set up to track versions, a new version of the list item is created each time you edit a list item.

You can view a history of how the list item has changed and restore a previous version if you make a mistake in a newer version. Use formulas and calculated values Use formulas and calculated values to dynamically generate information in the columns of a list. The operations can include information other columns in a list as well as system functions such as [today] to indicate the current date. For example, you can specify a default due date that is seven days from the current date.

Keep informed about changes Lists and views can use RSS, so that members of your workgroup can automatically receive updates. RSS is a technology that enables people to receive and view updates or RSS feeds of news and information in a consolidated location.

You can also create email alerts to notify you when the lists are changed or when new items are added. Alerts are a convenient way to keep track of the changes that are important to you. Create list relationships Create a relationship between two lists, in the source list, you create a lookup column that retrieves or "looks up" one or more values from a target list if those values match the value in the lookup column in the source list.

If you want, you can continue to add additional columns from the target list to the source list. When you create a lookup column, you can also decide to enforce relationship behavior by setting a cascade delete or restrict delete option that helps keep your data valid and helps prevent inconsistencies that might cause problems down the road. Share list information with a database program If you have a database program installed, such as Access, you can export and import data to and from your site, as well as link a table from the database to a list.

When you work with your list data in an Access database, you can also create queries, forms, and reports. See Import data into an Access database. Use lists consistently across sites If your group works with several types of lists, you can add consistency across multiple lists with content types, site columns, and templates. These features enable you to reuse the settings and list structure in an efficient way. For example, you can create a content type for a customer service issue that specifies certain columns such as customer contact and business processes for the content type.

Another example is creating a site column for department names that has a drop-down list of departments. You can reuse the column in multiple lists to ensure that the names always appear the same way in each list. Work on list items from an email program Use an email program that is compatible with Microsoft technologies, you can take important list information with you.

For example, with Outlook, you can view and update tasks, contacts, and discussion boards on your site from Outlook. RobElliott Pasting one at a time works, i can't paste any more than that. I'm testing with 2 records, the first one inserts then there's a blank row with no info from the second source row.

RRMX01 Copy a few lines from your Excel schedule into your clipboard and paste into the first line of the list when editing in grid view. This will populate all lines from your clipboard one below each other in your list. Once saved in your list, you can request a new line be added to your list and copy the next block in the same manner into the new line and repeat until all lines from your schedule have been added to your list.

I couldn't get it to work in Edge, but was able to paste a few hundred lines by opening it in Internet Explorer. Good luck! Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. With this token, any application is authorized to access with Azure role-based access controls and fine-grain control to the expiration, rate, and region s of use for the particular token.

In other words, the SAS Token can be used to allow applications to control access in a more secured way than the shared key. For publicly exposed applications, our recommendation is to configure a specific list of allowed origins on the Map account resource to limit rendering abuse and regularly renew the SAS Token.

Type: apiKey In: header. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Data - List Preview Reference Is this page helpful? Please rate your experience Yes No.

Any additional feedback? To learn more about the recent renaming of Microsoft security services, see the Microsoft Ignite Security blog. For information about the response fields, see Properties. If you run into any problems, we're here to help. To get assistance or support for your product issue, please open a support ticket. Skip to main content.