Hi, I believe I need to clear my collection, but I'm not entirely sure how.
The problem is whenever I try to export to .csv from Power Apps using the download icon, it only appends whatever new data was produced in my most recent filter and search of the gallery. When it appends, the prior information is not deleted. We need a way to completely remove whatever was in that collection (I'm assuming), for this to work. What do I do?
As you can see, there should be 3 sets of duplicates here. There should be NO duplicates or appended data. All new reports should have fresh data from the search and filter.
Here is the code:
Set
(ExportFinanceCSVVar,"");
ForAll(FinanceBrowseGallery.AllItems,Collect(ExportCSVCol,
{
Name: FinanceEntryOwnerTitle.Text,
Project: FinanceProjectTitle.Text,
TaskCategory: FinanceTaskCategoryTitle.Text,
Department: FinanceDepartmentTitle.Text,
Region: FinanceRegionTitle.Text,
HoursWorked: FinanceEntryHoursWorked.Text,
DateWorked: FinanceEntryDateWorked.Text,
CapEx: FinanceCapExTitle.Text
}));
Set(ExportFinanceCSVVar,Concat
(
ExportCSVCol,
Name & "," & Project & "," & TaskCategory & "," & Department & "," & Region & "," & HoursWorked & "," & DateWorked & "," & CapEx & Char(10)
));
Set(
CSVExportSuccessVar,
ExportFinanceCSVEmail.Run
(
"Finance ERP Report",
ExportFinanceCSVVar
).completed
);
Thanks, all!
