web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : TrKwPuwPBNQGCKvLFkaPFh
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2023 09:46:13 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

Announcing our 2025 Season 2 Super Users!

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

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete