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?
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
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?
Hello @JackTommo92 ,
please follow these steps:
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
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |