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

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.