Unanswered

Update OneDrive excel from outlook compressed attachment

(0) Share

Report

Posted on by bunty_1244

Hi Experts,

I am new to Flow. I am trying to search my problem on internet however couldn't find proper solution. Here is the typicall process look like:

I receive two email from system everyday at 5am which contains prior day's data. The excel attachment is compressed
I save both attachments and unzip it
Copy data from excel file from row 2 and append this data to OneDrive (for business) file. This file has two tabs for both email excel files so I update both the tabs.

My OneDrive file is a source file of PowerBI dashboard which is scheduled to refresh everyday at 8am. I wonder if flow can automate above manual steps then my PowerBI dashbord will stay updated all the time.

Is this possible?

Appreciate your time!

Thanks,

Bunty

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Depending on what was used to compress the file you can use the OneDrive Extract Folder action to unzip the file and store it in OneDrive. There are some compression algorythms that it doesn't work with though.

Was this reply helpful? Yes No
v-lin-msft 728 on at

Like (1)

Report

Hi @bunty_1244,

It is possible to achieve the first and second points based on your requirements.

But in your third point, you need to add data from the excel file from email everyday received to the existing OneDrive excel file, which is almost impossible to do.
Because at present, if you want to extract data in excel file, you must fill in fixed file path of the file instead of dynamic path, which should be followed including table in excel.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
bunty_1244 5 on at

Like (0)

Report

Hi @v-lin-msft

I really appreciate your time and help with this.

Regarding the 3rd point, good thing is that the zipped folder I receive in email everyday has the same file name. Also the path it is going to extract the file will remain the same.

The bad thing is the version of excel which is .xls. What that means is when I use "List rows present in a table" it doesn't show anything. I manually converted the version and I was able to locate the file here.

With your direction, I was able to create a flow that extracts the file from email everyday. Do you think adding a step that can convert .xls to .xlsx would help me move forward?

Best

Was this reply helpful? Yes No
v-lin-msft 728 on at

Like (0)

Report

Hi @bunty_1244 ,

Yes, you can add an action named Move or rename a file using path in the Connector OneDrive for Business after you extract the folder to rename the xls file into the xlsx file. (Please attention to the "x").
Please have a try, I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No