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 😁
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
73 | |
27 | |
22 | |
15 | |
15 |
User | Count |
---|---|
143 | |
43 | |
42 | |
34 | |
31 |