cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Try
Helper I
Helper I

Data table to excel

  • 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
2 REPLIES 2
VJR
Super User
Super User

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-na...

 

momlo
Impactful Individual
Impactful Individual

Hi @Try  

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

 

%ExcelData.ColumnHeadersRow%

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,178)