Using Power Automate to create New List items when data is added to Excel

Jeremy_Carnes  the previous answer (AI-generated I think) is not correct as the trigger is wrong; you don't want it to trigger when a new file as created, you want it to trigger and create a SharePoint list item when a new row is added to an Excel table. There isn't a trigger for that yet so I would use a recurrence schedule trigger set to run every hour for example and have a column in the spreadsheet for whether the row is new or not new and get the flow to add only new items into the list then update the row to not new. This is described in more detail here.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

Hi Jeremy_Carnes,

it is possible to create a Power Automate flow that will move new rows that are created in an Excel document and create new list items in a SharePoint list:

1. Create a new Power Automate flow.
2. Select the "When a new file is created" trigger.
3. Select the SharePoint library where the Excel document is located.
4. In the "File name" field, enter the name of the Excel document (or use a wildcard character to match multiple Excel documents).
5. Click "Next".
6. In the "Actions" section, add the "List rows present in a table" action.
7. Select the Excel document that you want to monitor.
8. Select the table in the Excel document that contains the data.
9. Click "Next".
10. In the "Actions" section, add the "Create item" action.
11. Select the SharePoint list where you want to create new list items.
12. Map the columns in the Excel table to the corresponding columns in the SharePoint list.
13. Click "Next".
14. Click "Save".

The flow should be triggered whenever a new file is created in the SharePoint library that you specified. The flow will then get the data from the Excel table and create new list items in the SharePoint list.

• You can use a filter in the "List rows present in a table" action to only get the new rows that have been added to the Excel table. For example, you could filter the rows based on a date column.
• You can also use a condition in the "Create item" action to only create new list items if certain criteria are met. For example, you could only create new list items if the value in a particular Excel column is greater than zero.