Cloning the structure of a data table in Power Automate Desktop

Like (0) Share

Report

Posted on 4 Dec 2023 16:05:40 by PriyaSekar_21

Hi all,

I am trying to copy the structure (just the column headers no values) of one data table to another. My newly created data table should have the same columns as the other data table.

I am trying to see if there are any functions that's similar to the Datatable.Clone function. I can create columns one by one but I don't think that's the effective way to do it.

All responses (3)

Answers (1)

v-xiaochen-msft on 06 Dec 2023 at 01:11:05

Like (0)

Report

Re: Cloning the structure of a data table in Power Automate Desktop

Hi @PriyaSekar_21 ,

Please try my solution above. It will copy the data table and remove all the items in it.

If you have 10k rows, please filter your data table first, then copy the data table after filtering and delete the items in it.

Best Regards,

Wearsky
PriyaSekar_21 2 on 05 Dec 2023 at 15:21:46

Like (0)

Report

Re: Cloning the structure of a data table in Power Automate Desktop

Thank you for responding!

I am confused as to how this would copy the headers of one data table to another. Can you expand on that?

Also, to be clear, let's I have data table with 20 columns (A,B,C etc.) with 10k rows. I want to create a data table that will have the same 20 columns with the same column headers with 0 rows.
Verified answer

v-xiaochen-msft on 05 Dec 2023 at 02:37:43

Like (0)

Report

Re: Cloning the structure of a data table in Power Automate Desktop

Hi @PriyaSekar_21 ,

Please try this

Best Regards,

Wearsky