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.
Hi @Sean499,
I have made a test on my side, please refer to screenshot below to create the flow:
Note:
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:
items('Apply_to_each_2')['Carrier']
The expression of column E-mails as below:
items('Apply_to_each_2')['E-mails']
The expression of column Path as below:
items('Apply_to_each_2')['Path']
The expression of column DATE as below:
items('Apply_to_each_2')['Date']
The flow would run successfully as below:
Best regards,
Alice
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?
Farhan
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
41 | |
37 | |
36 | |
22 |
User | Count |
---|---|
44 | |
36 | |
31 | |
28 | |
27 |