• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

Need to see all the fields in a Sharepoint list with properties

I need to export to Excel all the fields that exists in a SharePoint 2010 list. It should include the name of the field, type, description and if it is required or not. Can something like this be done using PowerShell?
0
MisUszatek
Asked:
MisUszatek
  • 2
1 Solution
 
slidingfoxCommented:
Give this a go. I've only tested this on SharePoint 2007, so I've haven't tried it using 'Get-SPWeb'. It should work fine though. If you have any problems, let me know and I'll give a try on a 2010 box later.

$web = Get-SPWeb "http://url-of-site"

$list = $web.Lists["Name of List"]

$list.Fields | Select Title,Description,Type,Required

Open in new window

0
 
slidingfoxCommented:
Sorry forgot the export to excel bit

change the last line to

$list.Fields | Select Title,Description,Type,Required | Export-CSV C:\Temp\Fields.csv -NoTypeInformation

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now