Power Automate

DataTable header

(0) Share

Report

Posted on by CU29030852-0

Dear All,

I wonder if we able to write the Header as well from a Data Table?

As it only write out the data for me but I also need the header to be written out as well.

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You will need to provide more details and context as to what you are trying to do. Your post is too vague to provide any meaningful guidance. Are you asking about an Excel table, a Dataverse table, a SQL table, etc. Depending on what you are doing will determine what you need to do. From your post it also sounds like you have started a workflow to do what you want. If so, include a screen shot of the flow showing the configuration of the actions. By seeing what you are attempting to do, it will make offering advice much easier.

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,565 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Datatable variables have .ColumnHeadersRow attribute in the variable which you can select to get the header names.

So if you want to write header names on certain row on Excel you would do it like that:

So that writes the to the first row the headers names then you can write the datatable values starting from row 2.

Was this reply helpful? Yes No
CU29030852-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi eetuRobo,

Thank you very much for your respond.

Yes, finally it works and able to write out the header using attribute .ColumnHeadersRow.

However, it also took me some time to work around on this scenario where my flow was Power FX enabled.

So I noticed something interesting that the attribute .ColumnHeadersRow only available if the flow is without enabling Power FX (refer to below screenshot).

I wonder if this is a normal case or it will get improve in future where this attribute will available in Power FX enabled environment?

Thanks

Was this reply helpful? Yes No