Forum Discussion

Azaak's avatar
Azaak
Copper Contributor
Oct 13, 2020

Power Automate not detecting items with high ID

I have a Power Automate that should detect all items within a folder and modify them all depending on the name.

 

I have noticed that doesnt matter in which folder I activate this, it always ignores some items, the last ones thus with the latest ID

 

Does someone know the cause of this issue?

 

Power Automate:

 

 

Here showing as the last 3 folders from the Folder don't have any updateed info (they should be marke as "Expedient", too:

 

 

 

 

Microsoft Flow
sharepoint

2 Replies

  • Lars365's avatar
    Lars365
    Iron Contributor
    Oct 16, 2020

    Hi Azaak
    As mentioned by stormin_30 there is the 5000-item limit for the "Get Item" trigger.
    Even when "Top Count" attribute is set higher than five thousand.

    I was confronted with a similar problem.
    This link was immensely helpful to me at that time.

    http://How%20to get more than 5000 items from SharePoint Online in Flow

    by https://alextofan.com/

     

    Hope it can help you too.
    Lars

  • stormin_30's avatar
    stormin_30
    MVP
    Oct 15, 2020

    Hi Azaak,

     

    Does your list have more than 5,000 items? Lists can store more than 5,000 but a view can only return 5,000. It might explain why your app is not getting the results that you expect.

     

    I hope this helps.

     

    Norm 

Resources