Power Automate not detecting items with high ID

%3CLINGO-SUB%20id%3D%22lingo-sub-1776251%22%20slang%3D%22en-US%22%3EPower%20Automate%20not%20detecting%20items%20with%20high%20ID%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776251%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Power%20Automate%20that%20should%20detect%20all%20items%20within%20a%20folder%20and%20modify%20them%20all%20depending%20on%20the%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noticed%20that%20doesnt%20matter%20in%20which%20folder%20I%20activate%20this%2C%20it%20always%20ignores%20some%20items%2C%20the%20last%20ones%20thus%20with%20the%20latest%20ID%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20someone%20know%20the%20cause%20of%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Automate%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Azaak_0-1602606249274.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226362iBA9B07849E62B3F5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Azaak_0-1602606249274.png%22%20alt%3D%22Azaak_0-1602606249274.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20showing%20as%20the%20last%203%20folders%20from%20the%20Folder%20don't%20have%20any%20updateed%20info%20(they%20should%20be%20marke%20as%20%22Expedient%22%2C%20too%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Azaak_1-1602606704333.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226366i24ED270F7A3873F6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Azaak_1-1602606704333.png%22%20alt%3D%22Azaak_1-1602606704333.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1776251%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1785503%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20not%20detecting%20items%20with%20high%20ID%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785503%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362975%22%20target%3D%22_blank%22%3E%40Azaak%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20your%20list%20have%20more%20than%205%2C000%20items%3F%20Lists%20can%20store%20more%20than%205%2C000%20but%20a%20view%20can%20only%20return%205%2C000.%20It%20might%20explain%20why%20your%20app%20is%20not%20getting%20the%20results%20that%20you%20expect.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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:

 

Azaak_0-1602606249274.png

 

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

 

Azaak_1-1602606704333.png

 

 

 

2 Replies

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 

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.

How to get more than 5000 items from SharePoint Online in Flow

by Alex Tofan's blog

 

Hope it can help you too.
Lars