Adding entries to list causing error, refresh clears it

Question

Hello,

When I try to add a new entry to a list in Sharepoint, or update information in an existing entry, as soon as I hit enter to add the line or information (quick edit mode), I get an error like the attached.

If I hit refresh, it will reload the list and my entry is there and the error is gone.

If I edit multiple lines in a row, I will get an error on each line as I leave it and once again it will clear with a refresh.

If I add multiple new lines in a row, I will get the error on the first new line, but not the ones after it, and a refresh will only add the line with the error on it, the other data will disappear.

Any idea what the error is, and how to get it to stop occurring?

Answer 1

I didn't change anything about my description of the problem.  Just added information about the site.

The list with the issue was the list with an indexed column.  I believe the index was created by SharePoint since I enforced one of the columns to have unique values.

As I stated above, a different list on the same site that is without an indexed column has no issue.  It is only the one with an indexed column.

I am the owner of the site.  I have full control of the list and the site.  However, it is the only site I have control of so I cannot duplicate it on another site.

I made a new list on the same site and duplicated it as much as possible.  In doing so I may have found the problem.

The list with the error msg had a lookup to a 'Model Number' list for the PN.  

The PN column on the model list had been indexed at one time (to maintain unique values) but it was a straight text entry column.  Then I decided to break up the PN and calculate it by concatenating part of the PN together with a unique number on the model list.   The calculated column had much of the same information as the old text column but the old one hadn't been maintained once the calculated column was made.  But for some reason, I couldn't delete the old column, so I just hid it from the view.  

The original list this post is about (with the error message) was still pointing to the old text column, not the new calculated column.  That text column had some blank cells.

I changed the lookup to point to the correct calculated column and now I no longer get the error.

The error message would have been more helpful if it gave some info instead of just #ERR.

Answer 2

Hi GennyG95,

Thanks for your updates.

Since what you described is a little different from your first post, for troubleshooting, please confirm the following and let us know the results. We’ll appreciate your effort.

1. Does the issue happen in the list configured with the indexed columns? What about the lists without the indexed columns?
2. To clarify if the issue happen in the specific site collection, I’d like you create a new list with the same configurations in another site collection to do a test and let us know the outcome.
3. Check your permissions on the list level and the site collection level, and then provide us with the screenshots showing your permissions on them.

To check your permission on the list level, do that via List Settings>Permissions for this list under Permissions and Management>Check Permissions.

To check your permission on the site collection level, do that via Site settings>Site permissions under Users and Permissions>Check Permissions.

Note: You may do that by contacting the site collection administrator if you aren’t the role.

4. Is the affected list a customized list? Could you provide us with some detailed steps about how to create it? Some screenshots are appreciated.
5. I noticed that you can’t remove the indexed column and an error message popped up. What error message pops up? Could you also give us some related screenshots? Have you tried removing the indexed column via List Settings>Indexed columns under Columns>selecting the indexed column you created>Delete?
6. If the site collection administrator edits the affected list, what's the result?

Moreover, I suggest you try the final suggestion in my last post to see if there are some improments in the issue if you can delete the affected list.

a. Clear IE caches via Tools>Safety>Deleting browser history and reset IE.

b. Remove your permissions on the site collection level and on the site collection level (You may do that by contacting the site collection administrator if you aren’t the role.).

c. Remove and re-add the affected list.

d. Sign out of the Office 365 portal and re-sign into it to edit the re-added list with the corresponding permissions.

Please let us know your updates at your convenience.

Thanks,

Cliff

Answer 3

I haven't tried everything you've asked yet, but so far, I know of at least one other list on the site that does NOT exhibit this problem.  

I have full control for this team site, the list does not have unique permissions.  

We are a small organization and I believe that I am the only one that is editing this list right now.  

It did the same thing in Chrome, IE, and Edge.

This list does have an indexed column on it, although my understanding of how to use indexes is incomplete, and I don't think I need it, (it isn't doing anything valuable for me).  I just tried to remove it and it gave me an error.

Answer 4

Hi GennyG95,

To clarify the issue, I’d like to confirm the following.

1. To clarify if the issue happen in the specific site collection, I’d like you create a new list in another site collection to do a test and let us know the outcome.
2. Does the issue occur in other lists in the site collection?
3. Do other people in your organization encounter the same issue?
4. If you change a browser, what’s the outcome?

Given the situation, please confirm, provide and try the following for our troubleshooting.

a. Does the affected list have a unique permission?

b. Check your permissions on the list level and the site collection level, and then provide us with the screenshots showing your permissions on them.

To check your permission on the list level, do that via List Settings>Permissions for this list under Permissions and Management>Check Permissions.

To check your permission on the site collection level, do that via Site settings>Site permissions under Users and Permissions>Check Permissions.

Note: You may do that by contacting the site collection administrator if you aren’t the role.

c. Clear IE caches via Tools>Safety>Deleting browser history, reset IE, remove your permissions on the site collection level and on the site collection level (You may do that by contacting the site collection administrator if you aren’t the role.), remove and re-add the affected list, sign out of the Office 365 portal and re-sign into it to give a shot with the corresponding permissions.

Thanks,

Cliff