Forum Discussion
Power Query for Excel uploads to SharePoint
The work flow involves 2 lists ( I will call them List A and B for simplicity)
List A is a spreadsheet containing 4 columns (illustrated below after being uploaded as a SP list, showing grouped by the unique Offering code. )
The only column that does not necessarily contain data is Attendance. The Offering code is a unique course code against which an evaluation is made in which further columns may be added with data via the app interface shown below.
One of two things can happen. If all controls contain data, it means a course has already been evaluated. If the same course needs to be re-evaluated at a later point in the year, the Add Data button should be used to add the data to a new row. If data is being added for the first time, the Update button should be used to post data to the same row.
My challenge is that the data that comes from the external source (first 4 columns, starting with Offering code, ending with Attendance) can be updated from time time - either with a new offering code and with an updated Attendance data. As a consequence, that data from the external source will need to be merged with the existing SP list.
I was thinking that the SP list will have to be downloaded to another place, then merged with the data from the external source via Power Query. The resulting output would then need to be uploaded to SP, replacing the existing list. Or is there a way to do this inline on SP?
Hope that makes sense.