cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Merging Excel files

I receive daily automated emails from our helpdesk ticketing system containing excel attachments that contain statistical data. 

 

I have built a flow to pull these specific attachments and save them into a dedicated OneDrive folder.  What I would like to do next is to build a second flow task that looks for added/modified files in this OneDrive location, get the rows of the new file and append them to a master document located in the same folder so that I can create a PowerBI dashboard off of the compiled data.

 

One caveat worth noting is the excel files do not have tables in them, nor is a way to programmatically add a table (unless there is a flow task for that?)

 

Any help would be greatly appreciated.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @jaraber,

 

Microsoft flow could only get the rows from a excel file with table in onedrive folder,and there is no any function to create a excel table in onedrive connector microsoft flow currently

If the excel files do not have tables in them, I afraid there is no any way to achieve your needs in Microsoft Flow currently.

 

If you would like this feature to get the rows from a excel file without table, or the feature to create a excel table in onedrive connector to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @jaraber,

 

Microsoft flow could only get the rows from a excel file with table in onedrive folder,and there is no any function to create a excel table in onedrive connector microsoft flow currently

If the excel files do not have tables in them, I afraid there is no any way to achieve your needs in Microsoft Flow currently.

 

If you would like this feature to get the rows from a excel file without table, or the feature to create a excel table in onedrive connector to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

View solution in original post

Highlighted
Administrator
Administrator

Hello, @jaraber!

 

If you have already posted your idea to the Flow Community Ideas Forum then you need to post the URL to your idea’s thread as a reply to this thread and then "Accept as Solution" on that reply so other users may vote for your Flow Idea and identify the information easily.

 

Thank You!

 

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities
Highlighted
New Member

You can save a flow, connect to the OneDrive folder in PowerBI (without the table) and perform the transformations in the query editor. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (12,772)