Automate the copy table steps

[Angie_]

Hi,

I'm trying to export a few tables in Data view into an Excel file. Is there a direct way to export them out to Excel in different tabs or I need to go table by table to right click and select copy table and paste it to Excel 1 by 1 manually. Is there any automation that I can select those tables that I need and export them into 1 Excel in different tab.

Thank you.

[SanketBhagwat]

Hi @Angie_ .
You can do that with Power Automate.
Please follow the below links for reference;
https://www.youtube.com/watch?v=BsXZUaarFWM

https://www.youtube.com/watch?v=BnTipbooeP0

Regards,
Sanket.

If this post helps then give it a Kudos and if it answers your question, then mark it as 'Accept as Solution'