Export data to csv comes with many brackets

(0) Share

Report

Posted on by nchandran

426

Can someone advise one how to get a cleaner data export.

Currently i have a collection that is being exported out to CSV file however i get alot of brackets.

Below is the syntax to export collection to csv.

ClearCollect(ColConsumAll,AddColumns(ColConsumMain,"OrderNo",Filter(ColConsumDetails,MasterID=ID).OrderNo,"NCRNo",Filter(ColConsumDetails,MasterID=ID).NCRNo,"Description",Filter(ColConsumDetails,MasterID=ID).Description,"OpsNo",Filter(ColConsumDetails,MasterID=ID).OpsNo,"WorkCentre",Filter(ColConsumDetails,MasterID=ID).WorkCentre,"Batch",Filter(ColConsumDetails,MasterID=ID).Batch,"HeatNo",Filter(ColConsumDetails,MasterID=ID).HeatNo,"Mass",Filter(ColConsumDetails,MasterID=ID).Mass,"Qty",Filter(ColConsumDetails,MasterID=ID).Qty,"Dia",Filter(ColConsumDetails,MasterID=ID).Dia,"Brand",Filter(ColConsumDetails,MasterID=ID).Brand,"PartNo",Filter(ColConsumDetails,MasterID=ID).PartNo,"Balance",Filter(ColConsumDetails,MasterID=ID).Balance));Set(ConsumableSumVar,Exporttoexcel.Run(JSON(ColConsumAll,JSONFormat.IncludeBinaryData)));Download(ConsumableSumVar.filelink)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @nchandran,

Based on the issue that you mentioned, do you want to remove the brackets within the CSV file?

Could you please tell me that how you configure your flow?

I think the key to the issue may be that your variable is a type of array. I guess that you want to pass array of multiple objects which should contain multiple objects, that needs to be bind into an array, otherwise it will not be a valid JSON.

If so, here is a similar thread that you could check for details.

Solved: I don't want any square brackets "[ ]" around my a... - Power Platform Community (microsoft.com)

If the above could not work, please provide your flow configuration.

Hope it could helps.

Regards,

Qi

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report

I actually followed Reza's video on exporting to excel. Here is the flow screenshot. I find it complicated to follow the solution you sent me since its not a array type of configuration.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report

bump, can someone help me on this please.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report

@v-qiaqi-msft Are you able to suggest a solution, the example you sent me did not quite align with what i am using.

Was this reply helpful? Yes No