Adding headings to a CSV file in PowerApps

(0) Share

Report

Posted on by cnr

144

Hi all,

My code below works fine when exporting to a CSV. I just need to figure out how to add headings to the columns, would anyone know how ?

ForAll(
 Gallery4_4.AllItems,
 Collect(
 ExportCSVCol,
 {
 TradeNumber: Label34_9.Text,
 FundName: Label35_17.Text,
 TD: Label36_7.Text,
 CCY: Label38_7.Text,
 MarketPrice: Label39_7.Text,
 AMT: Label37_14.Text,
 RevisedAmt: Label37_15.Text,
 Borrowers: Label33_7.Text,
 CounterParties: Label40_7.Text,
 TradeStatus: Label41_9.Text,
 Comments1: Label41_10.Text
 }
 )
);
Set(
 ExportCSVVar,
 Concat(
 ExportCSVCol,
 TradeNumber & "," & FundName & "," & TD & "," & CCY & "," & MarketPrice & "," & AMT & "," & RevisedAmt & "," & Borrowers & "," & CounterParties & "," & TradeStatus & Char(10)
 )
);
Set(
 SuccessVar,
 ExportCSVDemo.Run(
 "CSVTradesFile",
 ExportCSVVar
 ).completed
);
If(
 SuccessVar = "true",
 Launch("https://ofiz-my.sharepoint.com/:x:/g/personal/kiansean_lee_vistra_com/ER5_4KCLBfBFh8qyZo9nv-wB0ou4dCFf01WbvAVivLLO_Q?e=xNyPac&Download=1")
)

Thanks,

Conor

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@cnr

Please consider changing your Formula to the following:

With({_ExportCSVVar: "TradeNumber,FundName,TD,CCY,MarketPrice,AMT,RevisedAmt,Borrowers,CounterParties,TradeStatus" & Char(10) & Concat(Gallery4_4.AllItems, Label34_9.Text & "," & Label35_17.Text & "," & Label36_7.Text & "," & Label38_7.Text & "," & Label39_7.Text & "," & Label37_14.Text & "," & Label37_15.Text & "," & Label33_7.Text & "," & Label40_7.Text & "," & Label41_9.Text & Char(10) ) }, Set(SuccessVar, ExportCSVDemo.Run("CSVTradesFile", _ExportCSVVar).completed) ); If( SuccessVar = "true", Launch("https://ofiz-my.sharepoint.com/:x:/g/personal/kiansean_lee_vistra_com/ER5_4KCLBfBFh8qyZo9nv-wB0ou4dCFf01WbvAVivLLO_Q?e=xNyPac&Download=1") )

There really is no need for a collection to do any of this, so the above does everything in context.

This will add a header to the text being sent to the flow, then followed by the rows from the gallery.

I hope this is helpful for you.

Was this reply helpful? Yes No
cnr 144 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes
Thanks for coming back to me. It is downloading in CSV but not with the headers you've put in, below what the output on the last run. Could I need a refresh somewhere or is it possible its showing me an old CSV?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@cnr

Your issue is going to be in how you create that file in the flow you are calling. You app is now sending the correct data including the header. So when it gets to your flow, somehow that you are creating the excel file is excluding the header.

I would look at any previous run of the flow and see what is happening at each step and where the header is being removed/ignored.

Was this reply helpful? Yes No
cnr 144 on at

Like
a
(1)

Report
Copy link

Link copied!

Ah yes I see it in there now. Thanks a mill for your help!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@cnr

Happy to help!

Was this reply helpful? Yes No