web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Data table to excel

Power Automate

Unanswered

Data table to excel

(0) Share

Report

Report

Posted on by Try

33

Hi i want to convert data table to excel when i changed variable to excel. Spreadsheet the headers not coming only values comes in excel spreadsheet how to retrieve headers alao

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

By design the headers are not written to the Excel. PAD should have had a checkbox whether or not to write headers.

I have shared a post here to use the ColumnHeadersRow property to write the headers.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-Write-Data-with-columns-name-In-Excel-worksheet/m-p/1894184/highlight/true#M20555
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Try
You need to write ColumnHeadersRow to your first row, it contains the names of the columns.

%ExcelData.ColumnHeadersRow%

Join the conversation