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 new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.