cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jediah_Hill
Frequent Visitor

pull data from excel document in onedrive folder with a new document each day

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. 

 

flow 1.PNGflow 2.PNG

3 REPLIES 3
MarkStokes
Skilled Sharer
Skilled Sharer

What is the structure of the file name? Is any of it consistent? I’ll take an assumption that the file name is the same appened with a unique iderifier like a number or a date.

If that is the case then you can trigger your Flow when a new document is added to your OneDrive account and then run a Condition that checks if the file name “starts with” a certain string value.

-Mark
v-yamao-msft
Community Support
Community Support

Hi @Jediah_Hill,

 

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']

1.PNG

 

Please take a try with it on your side.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GabrielStJohn
Administrator
Administrator

Hey, @Jediah_Hill!

 

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!

 

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (77,647)