
Announcements
Hello,
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:
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!