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
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.