Share
ReportHello,
I have a question re. what might seem like a simple flow to the more experience users, but as a beginner, I'm struggling to put this together properly. I have an excel file that comes to me every week, always has the same first row and number of columns, but with data below being updated or more data rows being added. I'm looking to do the following with it:
- Format the received excel range (say all data is within range A1:D10) into a table to allow us to key the rows into a SP list
- Read each row and key it into an existing SP list
The excel's table columns have the exact same titles as the SharePoint list columns.
If we want to use a sample data set, let's imagine a table as below.
| Name | Type | Quantity | Price |
| Apple | Fruit | 5 | $1.00 |
| Banana | Fruit | 10 | $0.50 |
| Celery | Vegetable | 20 | $0.75 |
Any help is most appreciated!
Categories:
I have the same question (0)
All responses (
Answers (
304
