cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
borowiakn
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

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

GabrielStJohn
Community Champion
Community Champion

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

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,162)