Answered

Merging Excel files

(1) Share

Report

Posted on by jaraber

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GabrielStJohn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No