SharePoint list's All Items view not displaying latest items

2023-10-25T10:29:19.9533333+00:00

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.

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,757 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yanli Jiang - MSFT 22,426 Reputation points Microsoft Vendor
    2023-10-26T06:57:50.16+00:00

    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.

    1. Use the built-in Export to Excel function

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

    User's image

    1. 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.