Is it possible to append the rows of an excel spreadsheet in an email attachement to an excel spreadsheet stored in sharepoint?
Every day we are sent a report for the last 24hrs as an excel spreadsheet attached to an email. Each row in this daily report needs to be copied into a yearly spreadsheet which is stored in a sharepoint library.
I have made a test on my side, please refer to screenshot below to create the flow:
1.Please makre sure the Excel table would always have the same Table name, My excel table in the flow with Table name "Table1".
2.The expression of column Carrier as below:
The expression of column E-mails as below:
The expression of column Path as below:
The expression of column DATE as below:
The flow would run successfully as below:
Thank you for the great answer. Is it possible to ask a follow-up?
Is there a workaround if the Excel data is not presented within a table?
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.