SharePoint Online - Custom List not displaying all List items

Question

So sometimes when I view my custom List it doesn't load all existing List items (if I view in classic mode I can see all items), The tooltip says "Saved to your device, Your changes will sync when we reconnect." (snippet below) rather than being a tick saying "This list is in sync." and displaying all items. So I am wondering how to get my List syncing again, how do I get it to reconnect?

It is the same no matter what browser I use, and it differs from machine to machine, it also happens on one List only at present. Any help would be appreciated.

Answer 1

So looks like the issue was Internet connectivity. Though I was connected to the Internet the machine was saying that there was no Internet connection (network notification in the notification tray area) even though I could ping google and other remote sites. This was resolved by moving to another subnet on our network, the network notification now says it has internet access and the List is syncing.

The List still wasn't always syncing, so I have turned off "offline client availability" in the Lists Advanced Settings which seems to have fix the issue.

See https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-list-does-not-show-saved-item-from-customized-Power/m-p/1321833#M345084

Answer 2

Hi StaticJa3,

Thanks for sharing updates with us and I really appreciate your effort and your precious time and I know it effect on your daily work and I apologize for this.

First please accept my apologize for late reply due to out of work.

It seems issue only happened to only specific machine. However, other machines display List without the issue.

Since you figure it out this issue related with internet connection and after change the internet connection and now the List is syncing. I really appreciate your effort and your kind words.

If there is any issue related with office 365 application in future, please feel free to post back in this community and we will be here to help you.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 3

Hi Jeff Mills,

As per your description, it seems issue only occur with specific SharePoint online custom list using the Modern list view. However, if you switch to classic view all my items are displayed in the view. May I know if my understand is correct? If so, this is really abnormal behavior.

Based on my test result after creating a custom list it seems I cannot meet same behavior as lie yours. See image below for your reference:

Have you tried to edit the current view for columns and see if it displays any list items?   How about the libraries under the same site? Technically, the library is a special list in SharePoint.

After search and based on my experience, this issue related with some different columns type you created in your custom list and some users fix it by remove the JSON code of column and the items are back. You may also try and check if this also help for you.

Meanwhile, could you please share with us your column type in your custom list.   Also if you don't mind could you please confirm if you are using any custom column in your SharePoint list.                      

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 4

Hi Jeff Mills,

May I know have any updates regarding to this issue? Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 5

Thanks for your reply,

Yes, classic view displays all list items, the issue is in Modern list view. I have tried editing the view but had no success.

The Libraries are working properly, it's just the List with the issue. There is no JSON code being used on columns that I know of.

Note that this behaviour is only happening on one machine, all my other machines display this List without the issue.

Below is my List's columns: