SharePoint list's All Items view not displaying latest items

Question

My SharePoint list's All Items view isn't displaying the latest items. However, it does show all items when opened in a private window of Edge, but when reloaded or reopened, the issue arises again. I have tried various solutions (clearing browser cache, cookies, etc.), but none have resolved the issue. I want to export all data from my SharePoint list.

Answer 1

Hi @Zainab Ejaz/Management Trainee/PTCL ,

In your case, unfortunately, I can't determine the cause of the problem. Is this the case for all lists?

If you want to export all data from the SharePoint, here are the writing methods for you to choose from:

1. Save list as template

Go to the List Settings and selecting "Save list as template" under the "Permissions and Management" section. This will create a .stp file that you can download and use to create a new list with all of the data from the original list.

2. Use the built-in Export to Excel function

Select your export method by clicking export to excel and export the list to excel file.

3. Use PnP PowerShell to export the list to a csv file

#Config Parameter
$SiteURL = "https://tenant.sharepoint.com/sites/sitename"
$ListName = "listname"
$CSVPath = "C:\Temp\ListData.csv"
$ListDataCollection= @()
 
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)
$Counter = 0
$ListItems = Get-PnPListItem -List $ListName -PageSize 2000
 
#Get all items from list
$ListItems | ForEach-Object {
        $ListItem  = Get-PnPProperty -ClientObject $_ -Property FieldValuesAsText
        $ListRow = New-Object PSObject
        $Counter++
        Get-PnPField -List $ListName | ForEach-Object {
            $ListRow | Add-Member -MemberType NoteProperty -name $_.InternalName -Value $ListItem[$_.InternalName]
            }
        Write-Progress -PercentComplete ($Counter / $($ListItems.Count)  * 100) -Activity "Exporting List Items..." -Status  "Exporting Item $Counter of $($ListItems.Count)"
        $ListDataCollection += $ListRow
}
#Export the result Array to CSV file
$ListDataCollection | Export-CSV $CSVPath -NoTypeInformation -Encoding UTF8

For more information, please refer to:

https://www.sharepointdiary.com/2016/03/export-list-items-to-csv-in-sharepoint-online-using-powershell.html

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Hope this helps. :-)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.