I have a onedrove folder with a flow that adds an excel document each day. I need to pull data from the new excel file added each day. The file name changes each day with the layout being the same.
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:
Please take a try with it on your side.
Thank you for posting on the Flow Community Forum! It appears as though would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!
Thank you for being an active member of the Flow Community!
Flow Community Manager
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.