Showing results for 
Search instead for 
Did you mean: 
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


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:


Thank You

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,255)