Hello, i have an excel file in sharepoint, and i want to email it.
The workflow works great, but the excel file has like 5 sheets that i dont really need, and the file is so heavy that i can't send it via mail, even the workflow sends an error.
I already tried to get table and create a new file with the table. But there are no tables names in this file.
Is there a way to get only the sheet that i need and create a new excel/send it via mail?
Thanks!
Solved! Go to Solution.
Hi @franbatta
One possible way to do this is to use the 2nd of two office scripts in this video https://youtu.be/4ZiMjjV1c3Q which allows you to delete sheets from an existing file.
Please consider accepting my answer as a solution if it helps to solve your problem.
Cheers
Damien
Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks
Hi @franbatta
One possible way to do this is to use the 2nd of two office scripts in this video https://youtu.be/4ZiMjjV1c3Q which allows you to delete sheets from an existing file.
Please consider accepting my answer as a solution if it helps to solve your problem.
Cheers
Damien
Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks
Yes, that helped me! Thank you 😁
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
49 | |
46 | |
27 | |
25 |