Flow: Cannot fetch new changes - exceeds the list view threshold

%3CLINGO-SUB%20id%3D%22lingo-sub-145423%22%20slang%3D%22en-US%22%3EFlow%3A%20Cannot%20fetch%20new%20changes%20-%20exceeds%20the%20list%20view%20threshold%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145423%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20list%20with%20over%2015.000%20items.%20After%20file%20migration%2C%20Microsoft%20flow%20was%20not%20able%20to%20fetch%20all%20changes.%20I%20got%20the%20following%20error%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20attempted%20operation%20is%20prohibited%20because%20it%20exceeds%20the%20list%20view%20threshold%20enforced%20by%20the%20administrator%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20this%20a%20known%20in%20issue%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-145423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-177656%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%3A%20Cannot%20fetch%20new%20changes%20-%20exceeds%20the%20list%20view%20threshold%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-177656%22%20slang%3D%22en-US%22%3EHi%20Bernd%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20ran%20into%20this%20very%20issue%20recently%20after%20having%20gone%20live%20with%20a%20new%20document%20library%20to%20store%20a%20large%20number%20of%20files%20that%20were%20being%20hosted%20on%20a%20different%20(and%20costly)%20cloud%20platform.%20Of%20course%2C%20during%20testing%20the%20Flow%20was%20working%20great%20(picking%20up%20newly%20created%20and%20modified%20files)%20-%20but%20as%20soon%20as%20I%20brought%20everything%20over%20(73k%2B%20files%20in%20total)%20and%20'turned%20the%20lights%20on'%20the%20trigger%20would%20no%20longer%20trigger!%3CBR%20%2F%3E%3CBR%20%2F%3EAnyways%2C%20I%20was%20able%20to%20resolve%20it%20by%20turning%20on%20indexing%20on%20the%20'Modified'%20column.%20Since%20I%20hadn't%20seen%20this%20documented%20anywhere%20(and%20I%20did%20a%20lot%20of%20searching)%2C%20I%20went%20ahead%20and%20created%20a%20post%20to%20walk%20you%20through%20the%20process%20in%20case%20you%20need%20more%20detailed%20guidance.%20Here's%20the%20link%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ohthreesixtyfive.org%2F2018%2F03%2Fmicrosoft-flow-overcoming-the-list-view-threshold.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ohthreesixtyfive.org%2F2018%2F03%2Fmicrosoft-flow-overcoming-the-list-view-threshold.html%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOf%20course%2C%20if%20you%20have%20exceeded%2020k%20items%20you'll%20need%20to%20trim%20it%20below%20that%20to%20be%20able%20to%20turn%20on%20indexing%2C%20but%20otherwise%20it%20should%20be%20pretty%20painless.%20Let%20me%20know%20how%20it%20goes!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3E%3CBR%20%2F%3ERamiro%3C%2FLINGO-BODY%3E
Contributor

I have a large list with over 15.000 items. After file migration, Microsoft flow was not able to fetch all changes. I got the following error: 

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

 

Is this a known in issue? 

 

Cheers

1 Reply
Hi Bernd,

I ran into this very issue recently after having gone live with a new document library to store a large number of files that were being hosted on a different (and costly) cloud platform. Of course, during testing the Flow was working great (picking up newly created and modified files) - but as soon as I brought everything over (73k+ files in total) and 'turned the lights on' the trigger would no longer trigger!

Anyways, I was able to resolve it by turning on indexing on the 'Modified' column. Since I hadn't seen this documented anywhere (and I did a lot of searching), I went ahead and created a post to walk you through the process in case you need more detailed guidance. Here's the link:

https://www.ohthreesixtyfive.org/2018/03/microsoft-flow-overcoming-the-list-view-threshold.html

Of course, if you have exceeded 20k items you'll need to trim it below that to be able to turn on indexing, but otherwise it should be pretty painless. Let me know how it goes!

Best regards,

Ramiro