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
Microsoft
Microsoft

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,589)