cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sean499
New Member

Update Excel Spreadsheet from email attachment

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.

5 REPLIES 5
v-yuazh-msft
Community Support
Community Support

Hi @Sean499,

 

I have made a test on my side, please refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

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:

Capture.PNG

 

Best regards,

Alice

 

@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

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

 

Thank you!!!

Akashb
Frequent Visitor

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

Akashb
Frequent Visitor

@Sean499 

  

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,128)