Is it possible to update a Sharepoint list with data from three different Excel files with different columns?

Question

Hello community,

I am trying to create a PowerApp using a Sharepoint list, but need to create the list first. Three different Excel files will be used to build the list. The files have some matching column titles and some unique ones. The list should be updated with the data from the different files when they are added to a folder in Sharepoint.

I already created the list based on one of the Excel files, and will add the other necessary columns if this request is possible.

Or do I need to create three different lists for this instead?

Answer 1

Hi @Nadja Schwizer ,

In the Sharepoint out-of-the-box approach, you can only export one Excel table to one SharePoint list. You need to create three different lists for this instead.

As a workaround, You can export From multiple Excel sources to a Sharepoint list using Power Automate.

Since Power Automate is currently not supported in the Q&A forum. Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

Hope this can help you.

---

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.