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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

VJR 7,635 on at

Like (0)

Report

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

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like (0)

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

%ExcelData.ColumnHeadersRow%

Was this reply helpful? Yes No

Join the conversation