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

[David54]

this is brilliant! Thank you so much! I was looking the whole day for a solution to this!!

Thank you!!!

[Akashb]

Hello, I have some issues while trying this flow, could you please help me

[Akashb]

@Sean499