Update Excel Spreadsheet from email attachment

[Sean499]

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.

[v-yuazh-msft]

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

[farhandsome]

@v-yuazh-msft ,

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