Sharepoint list view is not shoiwng the latest results

john john 946 Reputation points
2023-04-08T13:02:08.9133333+00:00

I have a sharepoint list which contains 100,000++ items, and i define this view to show all items (without any filters), but the view is only showing the items which was modified 9 hours ago:- 1qaz

here is where the panel is showing that there are items added 1 minute ago, but it is not showing inside the list view:- 12qwasax

also when i write a power automate flow to get all items, it is not getting the latest items User's image

so what is going on?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,823 questions
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,706 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yanli Jiang - MSFT 21,691 Reputation points Microsoft Vendor
    2023-04-10T06:25:45.91+00:00

    Hi John ,

    This issue is relatively complicated and I could not reproduce it, so let's do some general troubleshooting:

    • Switch browsers or use private mode to see if the problem is resolved.
    • Switch accounts and check to see if the problem is resolved.
    • It is recommended to create multiple views to reduce the number of items in each view and see if the problem is solved.
    • Check whether a custom code has been added, and if so, delete the code to see if the problem is resolved.

    For Get items, there are corresponding restrictions, and only a certain number of items can be returned.

    Item limits The default item limit is 100 and items are paginated by default as well. If you are using the default options, and simply specifying the site address and list or library name, Power Automate returns 100 items from the list or library. If you are working with large lists, you can increase this limit up to the list view threshold limit of 5,000.

    For more information, please refer to:

    https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files


    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.