Answered

Use Case: Export an Email attachment and its contents to OneDrive for Business Excel file on a Daily

(1) Share

Report

Posted on by borowiakn

Hi everyone,

Use Case: I get an email every night at 11:59PM that has an attachment that is an Excel file. I then want to take that attachment and have it take the contents in that Excel File and have it get pushed out to an Excel file that's living on my OneDrive for Business environment. It will add whatever rows are in the Excel File to the OneDrive for Business file but have it add them to the end of the Excel File workbook (last row). This keeps the OneDrive for Business Excel file as a very dynamic and living document that all of my team can use for Asset Tracking.

If anyone else has a better method of doing this, please let me know. We can use PowerApps, PowerBI or SSIS but we just need the direction on how to go about doing that! Much appreciated!

Current Microsoft Flow: I am trying to export an Email attachment (Excel File) to OneDrive for Business using Microsoft Flow daily at 11:59PM CST.

Flow 1.PNG Flow 2.PNG Flow 3.PNG

Above is my current Flow and it says it works but I don't think it's doing what I want it to do.

Thanks again,

Neal Borowiak

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @borowiakn,

I afraid that you couldn't achieve your requirement only in one flow.

If you create a new excel file in the onedrive for business with the attachment content, the flow couldn't get rows of the excel file because the "Get rows" action of excel connector could only get a existing file before the flow runs, the "Get rows" action of excel connector couldn't get a new file which would created when the flow runs.

Best regards,

Alice

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report
Copy link

Link copied!

Hello, @borowiakn!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No