cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pmarino100
Regular Visitor

Add all rows to Excel master file from incoming email attachments

Hello All,

 

I have a Flow that saves Excel spreadsheets from email (O365) attachments to OneDrive for Business.  I would like to update a master Excel file with all the rows from these Excel spreadsheets when they are saved to OneDrive.  Is this possible?  If not, would it be possible if I saved the email attachments to SharePoint instead?  Note that the Excel attachments are not in table format and each spreadsheet has a variable number of rows.  The master Excel file is in table format.

 

Thank You

2 REPLIES 2

Hi @Pmarino100 

 

For the Excel connector to read the excel file, it is required that the spreadsheet contains data formatted as an appropriate table. So if you save it on SharePoint or on OneDrive as long as the data is not formatted as a table, the excel connector in flow will not be able to read it. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi Yashag2255,

 

Thanks for your input.  I was finally able to do this by adding a Create Table step and choosing a large table range to accommodate the largest numbers of rows I expect to come through from the email attachments.  I then added a condition to the end of the Flow to only add rows with data to the master file.  The other difficulty was in getting the table variables to come through with no permanent file to pull from.  This was accomplished by following the suggestion from LuisGuzman98 on this post:  https://powerusers.microsoft.com/t5/Building-Flows/List-rows-present-in-table-dynamic-content-not-ap....

 

Thank You

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,617)