Gotcha
So you would want to
1. Use the Received Email Trigger
2. Grab the Attachment
3. Im guessing save the report to onedrive or sharepoint (Using Create FIle)
4. List rows of the Table Action on the file you just saved
5 for each row use the Add a Row to a Table action (for excel)
6. Once those are all written, you want to use the Create Table action
--Where are you going to create this, you said you want to email it but if you create the Table in excel you need a file and then to attach the file to the email, not just send the Table. Unless you simply generate an HTML table using the excel data and put that in the body of the email.
7. Anyhoo after Create Table, you will then again use
8. Now you use List Rows of aTable Action to get all the rows from the Master Table
9. In an Apply to each, you would again use Add a Row to a Table Action to write the data from the previous step
10. When done, use the Send email V2 with whatever body etc you want and attach the Contents of the file to the email
Does that sum up what you want? Can you show how you did it, and what was wrong with it versus what you expected? Might be easier that way.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
