Hi @Anonymous,
Do all the files have a table with the same name, say Table1?
If yes, please try the following configuration. I am trying to get all the rows from the newly added file, then insert the rows to a SharePoint list.
The flow is triggered by When a file is created, then use the Excel action Get rows. When configuring this action, please make sure select dynamic content File identifier for the File name, then enter a custom value of the common table name in Table name field.
Adding an Apply to each, get Value from the action Get rows, selecting the SharePoint action Create item. In the Title field and Startdate field, enter the following code:
item()?['name']
item()?['date']
Please take a try with it on your side.
Best regards,
Mabel Mao
