Power Automate and Excel with Outlook

[Jaffabfc]

HI,

Does anyone have any experience with Power Automate and Excel?

I am creating a table with a forecast so in column D i will have a code, each code will have its own assigned email address.

I am wanting to be able to create multiple tables based on each code.

For example
Code 123 will have a table created
Code 456 will have a table created
Code 789 will have a table created

I am wanting to create the full spreadsheet and then a power automate to create the seperate spreadsheet and then send to the relevant email addresses.

There will be around 500 seperate codes but only around 30-50 that will be emailed using power automate.
Each seperate code could have between 10-600 lines connected to them.

I am just really struggling to get it to work, i can work it out so it will create a table in the email but not a table in a seperate spreadsheet to attach as a file.

thanks

 

[jkpieterse]

That probably requires writing some Office Script.

 

[ExcelToDAX]

for creating a separate spreadsheet and attaching it, I would create a template with an identical table without any rows in it. And then you can copy the template file into a folder, and then use Office Scripts to update the table, and then you can email out the newly created excel file and archive it if needed.

 

[Jaffabfc]

not as straight forward as i would have hoped then