web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Export with Headings!

Power Apps

Unanswered

Export with Headings!

(0) Share

Report

Report

Posted on by AmeliaDwight

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!!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
AmeliaDwight 92 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft
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!!

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:
Set(varA,Concat(Tracks,Market & "," &Char(10))); Set(varA,JSON(Tracks,JSONFormat.Compact) ); 'PowerAppV2->Createfile'.Run(varA);

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No

Join the conversation