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.
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
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.