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:
- Created an empty variable to store my CSV data
- Created a collection to store all labels of each item from my gallery as individual rows
- 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)
- I created a flow with a manual powerapps trigger, which creates a sharepoint file in a fixed location.
- 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
