Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Auto Update Excel File saved in Sharepoint with data from Excel attached to Email

(0) ShareShare
ReportReport
Posted on by

Greetings, I read a few posts but could not find the right solution. I am looking to create a flow where I can add rows to an existing excel file on SharePoint with data from excel file attached in daily email. I encountered problems and need help.

Initially, I tried the method from Update Excel Spreadsheet from email attachment - Power Platform Community (microsoft.com) to get data directly from email and encountered a problem, where I could not choose a file to get the data source since that file has not been created.

Dar1_0-1676958482906.png

I tried another method to save all attachment to SharePoint, then try to get the data. Here I encountered another problem, which is every attachment in the email such as PNG file is also saved into SharePoint. I only need the excel file attached to the email. I used the method shown in Solved: Beginner Questions Saving Excel attachments from N... - Power Platform Community (microsoft.com)
without success, the flow run successfully but none of the file satisfy the condition as an excel file. Hence, no file is saved in SharePoint

Dar1_0-1676972092751.png

In case I ignore all attachment downloaded issue, I still have no idea how to get data from recently generated excel because power automate flow require the file path to be stated during the creation of flow.

In summary there are 2 issues:
1. How create a flow to download only Excel attachment
2. How to get data from the generated Excel file and add rows to existing Excel file in SharePoint.

Thank you for reading this long post. Looking forward to your inputs.

Additional information:
All data in the attached excel file are in one sheet and table format.

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