Syncing Error with SharePoint List

Question

I have SharePoint list linked with Excel. Basically we are populating data from Excel into List. It auto update list in SharePoint as we update in excel(guessing they must have used power automate for that). But it's showing Synch issue under list in SharePoint. Already tried clearing cache and using different browser( issue still persist). Does someone encountered similar issue? Thanks in advance.

Answer 1

Hi @Deepu C,

Thank you or your reply.

Since we can't reproduce your situation, we need to narrow down the problem and try some things.

1. Please try manually adding an item from excel to the list and then see if the problem persists. If the manual addition is successful, please see if there is a problem with the stream.
2. If you have problems adding manually, please check if there is a URL link column in the data you are adding. Sometimes this link can cause problems with illegal values. Please try leaving the column unfilled to see if the problem persists.
3. Please check that the value of each column matches the type of the column. For example, uploading a string in a number column can also cause this problem.
4. Are other users with permissions facing the same problem? View through another computer or account.
5. Whether other SharePoint lists have the same problem? You could create a new SharePoint list to check.
6. Check if the same issue occurs with other SharePoint site collections.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.