Answered

Cloning the structure of a data table in Power Automate Desktop

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PriyaSekar_21 ,

Please try this

Best Regards,

Wearsky

Was this reply helpful? Yes No
PriyaSekar_21 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No