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

Save an excel attachment, then copy rows into master excel document

I receive a daily email with an excel attachment.

 

I want to save this attachment to sharepoint, then copy rows from this document into a master document.

 

Then when the next day's email comes through, I want to save this down, copy rows, the paste them below the previous day's data in the master document.

 

I have created a flow to save the attachments, but need help on the data transfer part. Is this possible?

3 REPLIES 3
MarconettiMarco
Super User
Super User

Hello @JackTommo92 ,

you should be able to use the Excel "Add a row into a table" action.

Can you share the full flow in Edit Mode, so that we could better help you?

 

BR,

Marco

JackTommo92
New Member

I have started with the "Add row into a table" action - but I am unsure how to pull in the correct information from the newly created file. How do I select the relevant data to bring in?

JackTommo92_2-1660927570642.png

 

 

 

 

Hello @JackTommo92 ,

please follow these steps:

AddRow.gif

Using the dynamic content, you're able to grab available data from the trigger.

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

My blog site about Power Automate: https://powerautomatejoy.com/ 

BR,

Marco

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,526)