Appending Data to an existing SharePoint List

Question

Hi,

I have an existing SharePoint list with various categories of data (with multiple columns and rows). I need to append data (same categories) from an MS Excel sheet coming in every month from a client.

I would like to know how to do that (preferably automatically and not through Edit in Grid view) so that the new table does not affect the existing information in the list. I do not want to create a completely new SP list version as the existing one is linked to multiple Power BI reports.

Please help.

Note: Power Automate is an option that I tried, however I faced multiple data coherency and date related issues. MS Access is the other option. However, that's an additional tool and step that others in my team would love to avoid. Nevertheless, if it is the only option, then please share a workflow.

Best

Dave

Answer 1

Hi,

Welcome to Microsoft Community!

Per your description, it seems that you would like to automatically append data to an existing SharePoint list. (If this is not what you mean, please point out.)

Given this situation, based on my test and experience, there might have no out-of-box way to automatically update Excel data to the existing SharePoint list, however, I 'm trying to test again in Access which link the data to SharePoint list, if you are willing, you can see my steps:

1. Create a SharePoint list> then go to Access> click External Datatab> New Data Source > From Online Services > SharePoint List.
2. Once I update the Access data, it will automatically update to SharePoint list.

More details please see Import, link, or move data to SharePoint

Update some data in Access:

If this does not meet your scenario or there has any misunderstanding, please point out, we will try our best to help you. 😊

And we also welcome any community members who have some new ideas share here.

Best regards,

Gloria

Answer 2

Thanks Gloria!

I would definitely try the workaround using the Access solution.

Regards

Debashis

Answer 3

Hi,

I'm glad to hear you are willing to try the Access workaround, if you have other issues in the future, please feel free to post a new thread, we will try our best to help you.

Wish you a nice day and please take care!😊

Best regards,

Gloria