Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(1) ShareShare
ReportReport
Posted on 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

  • 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
    v-yuazh-msft on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics