You’re offline. This is a read only version of the page.
92
Hi everyone,
I have a table that i am exporting to excel using power automate. This is what i am using:
Set(varA,Concat(Tracks,Market & "," &Char(10))); 'PowerAppV2->Createfile'.Run(varA)
and it is working fine!
Only thing is, is that i would like it to have a header,
e.g from this to this
any suggestions please?
Thanks!!
Hi , @AmeliaDwight
In my understand , the 600 rows is no problem , you can try to use this in your side and pass it to the flow:
Share
Report
All responses (
Answers (
Set(varA,Concat(Tracks,Market & "," &Char(10)));
Set(varA,JSON(Tracks,JSONFormat.Compact) );
'PowerAppV2->Createfile'.Run(varA);
Best Regards,
Yueyun Zhang
Thanks for this!
Unfortunately my data table is very large (600 rows!!) so not sure i can do this?
Is there a way i can edit the formula i used slightly? thanks!!
Hi , @AmeliaDwight
According to your description, you want to create a excel file with the headers in Power Apps.
You can refer to this steps:
(1)This is my code in Power Apps Button-OnSelect:
ClearCollect(Tracks , {Market:"Africa"},{Market:"UK"},{Market:"Spain"});
Set(varA,JSON(Tracks,JSONFormat.Compact) );
ExportwithHeadings.Run(varA);(2)This is my flow:
The result is as follows:
Best Regards,
Yueyun Zhang
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
