Unable to export gallery items to CSV

[Anonymous]

Hi,

After watching a youtube tutorial (https://www.youtube.com/watch?v=QTbVMu6DIfQ&t=2s) on how to export filtered data to a CSV file, I tried replicating it for my app. However, the output is inconsistent. 

These are the steps I followed:

1. Created an empty variable to store my CSV data
2. Created a collection to store all labels of each item from my gallery as individual rows
3. Concatenated each item of the collection with a comma and saved it to the variable I created in Step 1. ( I also concatenated column names in the beginning to reflect as headers in my CSV file)
4. I created a flow with a manual powerapps trigger, which creates a sharepoint file in a fixed location.
5. CSV file generated

Following is the code:

Set(ExportCSVVar,"");
ForAll(ExportGallery.AllItems,Collect(
ExportCSVCol,{
TaskID:TaskID_Gal.Text,
RequestorSite:RequestorSite_Gal.Text,
RequestorDepartment:RequestorDepartment_Gal.Text,
CostCenterCode:CostCenterCode_Gal.Text,
RequestorName:RequestorName_Gal.Text,
RequestorEmail:RequestorEmail_Gal.Text,
TaskType:TaskType_Gal.Text,
BillingType:BillingType_Gal.Text,
TaskPriority:TaskPriority_Gal.Text,
TaskTitle:TaskTitle_Gal.Text,
TaskDescription:TaskDescription_Gal.Text,
TaskJustification:TaskJustification_Gal.Text,
TaskStatus:TaskStatus_Gal.Text,
ReferenceNumber:ReferenceNumber_Gal.Text,
FinancialImpact:FinancialImpact_Gal.Text,
FICurrency:FICurrency_Gal.Text,
Resource_TO:Resource_TO_Gal.Text,
Resource_TO_email:Resource_TO_email_Gal.Text,
Resource_AQE:Resource_AQE_Gal.Text,
Resource_AQE_email:Resource_AQE_email_Gal.Text,
Resource_RA:Resource_RA_Gal.Text,
Resource_RA_email:Resource_RA_email_Gal.Text,
Resource_PKG:Resource_PKG_Gal.Text,
Resource_PKG_email:Resource_PKG_email_Gal.Text,
Resource_BML:Resource_BML_Gal.Text,
Resource_BML_email:Resource_BML_email_Gal.Text,
OpenDate:OpenDate_Gal.Text,
DueDate:DueDate_Gal.Text,
ExpectedBackOrderDate:ExpectedBackOrderDate_Gal.Text,
AssignDate:AssignDate_Gal.Text,
CloseDate:CloseDate_Gal.Text,
Stakeholders:Stakeholders_Gal.Text,
StakeholdersEmail:StakeholdersEmail_Gal.Text,
Coordinator:Coordinator_Gal.Text
}
));

Set(
ExportCSVVar,
"Task ID,Requestor Site,Requestor Department,CostCenter Code,Requestor Name,Requestor Email,Task Type,Billing Type,Task Priority, Task Title,Task Description,Task Justification,Task Status,Reference Number,Financial Impact,FI Currency,Resource TO,Resource TO_email,Resource AQE,Resource AQE_email,Resource RA,Resource_RA_email,Resource PKG,Resource PKG_email,Resource BML,Resource BML_email,Open Date,Due Date,Expected BackOrderDate,Assign Date,Close Date,Stakeholders,Stakeholders Email,Coordinator,"
& Char(10) & Concat(ExportCSVCol,
TaskID&","&RequestorSite&","&RequestorDepartment&","&CostCenterCode&","&RequestorName&","&RequestorEmail&","&TaskType&","&BillingType&","&TaskPriority&","&TaskTitle&","&TaskDescription&","&TaskJustification&","&TaskStatus&","&ReferenceNumber&","&FinancialImpact&","&FICurrency&","&Resource_TO&","&Resource_TO_email&","&Resource_AQE&","&Resource_AQE_email&","&Resource_RA&","&Resource_RA_email&","&Resource_PKG&","&Resource_PKG_email&","&Resource_BML&","&Resource_BML_email&","&OpenDate&","&DueDate&","&ExpectedBackOrderDate&","&AssignDate&","&CloseDate&","&Stakeholders&","&StakeholdersEmail&","&Coordinator&","&Char(10))
)

I am facing problems. The output is inconsistent. Please refer to the screenshots. The collection is getting created accurately (refer to the temporary table) but the CSV file is misplacing many values. Also, it is showing blank values for many entries.

Can anyone help? Also, please tag Daniel Christian who created the youtube video.

Regards,

Aakash

[Anonymous]

@eka24  I did as you suggested

@timl I substituted the delimiters as you suggested 

Substitute(Substitute(Substitute(ThisItem.TaskDescription,",",""),Char (10)," "),Char (13)," ")

Unfortunately, it didn't influence the output.

I am also wondering that even if I missed to substitute some delimiters, at least the entries should have moved to the next cell, right? Right now, more than 50% of the cells are empty which shouldn't be the case.

What are your thoughts?

[timl]

Hi @Anonymous 

To diagnose this, I think the best thing to is to open the CSV file in a text editor, for example notepad or notepad++. I would turn off the word wrap option so that I could see where the line breaks occur.

I would find the section of the file around T-0007 and I would count the commas in that row. Do they correspond to the number of headings?

[Anonymous]

@Anonymous 

In your Step 4, how are you creating the SP file? I was able to follow Daniel's video and get the results he gets. I was also able to add Row headers (like you have done) and add a file to SharePoint. I did this by getting the created OneDrive file and copying it across, using this flow:

The above Flow calls for 5 parameters in PowerApps, which I thought odd, but I just added what was need as follows:

ExportToCSV.Run("CSVOneDriveFile",ExportCSVVar,"CSVOneDriveFile",ExportCSVVar,ExportCSVVar)

The extra parameters may have come from me messing around with the Flow to get it working?

You've used a manual trigger whereas I (and Daniel) used an Instant one, but I don't think that's an issue.

If the Flow isn't the issue then, as @timl suggested, maybe look at your data. I'd specifically be looking at the data for Coordinator of the record for T-0007 because this is the last value in that row and also where your file seems to start playing up.

Whilst I was able to reproduce a result for myself I only used 4 columns - not sure that's an issue either?