Microsoft Lists calculated column error

Question

Split from this thread.

Hi,

I'm having similar issues with Lists, and it also all worked fine for me before the latest update.

I first noticed an issue when I added a new item to a List. The List I'm using is very basic with no advanced functionalities. When I added a new item it showed on the calendar, but when I clicked on it, it opened on an error page. I tried in the App and Browser version and both led to the same error. And other users couldn't see the new item at all.

I then noticed another issue. When I added a new column to a list and then went to edit or add a new item, the new column field didn't show. So I could only add/edit that column by "edit in grid view".

Both errors were fixed by selecting "stop syncing".

What's the problem here? It was all fine before the update.

And what does it mean now that I've selected to "stop syncing"?

And feedback would be much appreciated, thanks!

Answer 1

Will do, thanks so much Jazlyn!

Answer 2

Hi RoisinT,

Thank you for the reply.

I understanding is that old lists which linked to SharePoint site have same problem, and the problem disappeared when you click "stop syncing".

However, to find the root cause for this issue, more resources need to be involved on the issue in your environment. I suggest you contact the administrator in your company if you aren’t the administrator and follow the steps in the article to open a ticket, this is a most efficient way to fix the issue in your environment. Because support team there will have specific diagnostic tools that can help troubleshoot this issue further, and their support will continue to investigate this issue and provide suggestion for you.

Appreciate your understanding.

Best regards,

Jazlyn

Answer 3

Thanks for the quick response!

For the new item error, it happened on a List linked to a specific SharePoint site. When I selected to "stop syncing" it worked again.

The same was true for the other List where the columns weren't working properly - this was on a List linked to a different SharePoint site. And when I selected to "stop syncing" on that, it also started working again.

Now that they are working again it is no longer an issue, but I'm not sure what it means that these Lists are no longer syncing?

And no, the error doesn't occur on new Lists that I set up following the update.

Answer 4

Hi RoisinT,

Thank you for posting your query in our community.

Based on your description, when you add new items in the list, it will be opened in an error page.

To narrow down the scope of the issue, could you please provide some information for me?

1. Does the problem happen on this specific site, or all the SharePoint sites?
2. If you create a new list in this site, will the same problem happen?

Additionally, you could also try to re-index for this site to see the result. Check the article for more information: Manually request crawling and re-indexing of a site, a library or a list

Best regards,

Jazlyn