Hello. I have a SharePoint 2016 list which we currently extract into a CSV file and then read with our PowerShell script. The list has about 100 different columns. I would like to read directly from the SharePoint list using my PowerShell program.
I’ve made some progress in that I can log onto the system, get a list of fields, and then run the Get-PnPListItem to see the rows. Get-PnpListItem returns just 3 columns (ID, Title, and GUID). Now I want to load the actual list data into an array so I can work with it in my script. How can I do this? Thank you in advance!!!
$credential = Get-Credential Connect-PnPOnline –Url "https://mysite.com/sites/mpgxp/tech" –Credentials $credential Get-PnPField -List "MPGXP Server App List" # Get a list of available fields Get-PnPListItem -List "MPGXP Server App List" # Read the items in the list