SOLVED

Formatted List View Limited To 30 Items

%3CLINGO-SUB%20id%3D%22lingo-sub-1530200%22%20slang%3D%22en-US%22%3EFormatted%20List%20View%20Limited%20To%2030%20Items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530200%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20formatted%20a%20list%20with%20JSON%20and%20it%20looks%20good%20but%20I%20have%20found%20a%20peculiar%20error%2C%20no%20matter%20what%20I%20set%20the%20view%20item%20limit%20to%2C%20it%20only%20shows%20the%20first%2030%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20second%2C%20none%20formatted%20view%20that%20shows%20all%20of%20the%20items%20as%20expected%20so%20I%20know%20the%20items%20are%20in%20the%20list%20and%20I%20no%20that%20setting%20the%20item%20limit%20is%20working%20on%20un-formatted%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20noticed%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1530200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EJSON%20formatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530870%22%20slang%3D%22en-US%22%3ERe%3A%20Formatted%20List%20View%20Limited%20To%2030%20Items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530870%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Marion%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F288947%22%20target%3D%22_blank%22%3E%40smithme%3C%2FA%3E)%2C%20similar%20issues%20have%20been%20reported%2C%20for%20example%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsharepoint%2Fjson-list-view-format-doesn-t-load-all-items%2Ftd-p%2F1321674%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsharepoint%2Fjson-list-view-format-doesn-t-load-all-items%2Ftd-p%2F1321674%3C%2FA%3E%26nbsp%3Bbut%20it%20doesn't%20seem%20to%20be%20universal.%20This%20will%20be%20no%20help%20at%20all%20(sorry)%20and%20I%20don't%20have%20a%20solution%2C%20but%20I've%20just%20looked%20at%20a%20formatted%20view%20with%20over%201400%20items%20and%20they%20all%20displayed%20as%20I%20scrolled%20through%20the%20list.%20The%20last%20few%20items%20are%20shown%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Catalog2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206220iE9BD5ABDE064A095%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Catalog2.png%22%20alt%3D%22Catalog2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have formatted a list with JSON and it looks good but I have found a peculiar error, no matter what I set the view item limit to, it only shows the first 30 items.

 

I have a second, none formatted view that shows all of the items as expected so I know the items are in the list and I no that setting the item limit is working on un-formatted lists.

 

Has anyone else noticed this?

1 Reply
best response confirmed by smithme (Contributor)
Solution

Hi Marion (@smithme), similar issues have been reported, for example at https://techcommunity.microsoft.com/t5/sharepoint/json-list-view-format-doesn-t-load-all-items/td-p/... but it doesn't seem to be universal. This will be no help at all (sorry) and I don't have a solution, but I've just looked at a formatted view with over 1400 items and they all displayed as I scrolled through the list. The last few items are shown below:

 

Catalog2.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User