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
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