Skip to main content
Community site session details

Community site session details

Session Id : Tsqudv3ClK+QjBBhAnAlvm
Power Automate - Using Connectors
Answered

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

Like (1) ShareShare
ReportReport
Posted on 23 Aug 2018 06:05:39 by 40

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.PNGFlow 2.PNGFlow 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

  • GabrielStJohn Profile Picture
    on 27 Aug 2018 at 17:49:37
    Re: Use Case: Export an Email attachment and its contents to OneDrive for Business Excel file on a D

    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

  • Verified answer
    v-yuazh-msft Profile Picture
    on 24 Aug 2018 at 07:56:40
    Re: Use Case: Export an Email attachment and its contents to OneDrive for Business Excel file on a D

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Featured topics