Here is some context to show what is happening, here are two code snips showing the ClearCollect functions:
ClearCollect(colExcelMergedFinalExport,
If(
varExcelAssignColVis, DropColumns(varExcelMergedExport, "Branch Inventory", "Admin Name", "Admin Email", "Admin Phone", "Admin Department", "Admin Job Title", "Admin Manager",
"Job Number", "Job Supervisor Name", "Job Supervisor Email", "Job Supervisor Phone", "Job Supervisor Department", "Job Supervisor Title", "Job Supervisor Branch",
"Repair Location", "Repair Status",
"Monitor Make", "Monitor Make Other", "Monitor Model", "Monitor Model Other", "Monitor Status", "Monitor Serial", "Monitor Service Date",
"Harness Make", "Harness Make Other", "Harness Size", "Harness Status", "Harness Serial", "Harness Service Date",
"Lanyard Make", "Lanyard Make Other", "Lanyard Size", "Lanyard Status", "Lanyard Serial", "Lanyard Service Date",
"Self-Retracting Lanyard Make", "Self-Retracting Lanyard Make Other", "Self-Retracting Lanyard Size", "Self-Retracting LanyardStatus", "Self-Retracting Lanyard Serial", "Self-Retracting Lanyard Service Date",
"Anchor Sling Quantity", "Anchor Sling One Status", "Anchor Sling One Service Date", "Anchor Sling Two Status", "Anchor Sling Two Service Date",
"Lock Box Quantity", "Pad Lock Quantity", "Cable Lock Quantity", "Breaker Lock Quantity", "Scissor Lock Quantity",
"Arc Flash Suit Assigned", "Arc Flash Suit Rating", "Arc Flash Suit Serial", "Arc Flash Hood Assigned", "Arc Flash Hood Rating", "Arc Flash Hood Serial", "Arc Flash Gloves Assigned", "Arc Flash Gloves Rating", "Arc Flash Gloves Serial", "Arc Flash Gloves Service Date",
"Ear Muffs Make", "Ear Muffs Make Other", "Ear Muffs Model", "Ear Muffs Model Other",
"Bump Station Make", "Bump Station Make Other", "Bump Station Model", "Bump Station Model Other", "Bump Station Status", "Bump Station Serial", "Bump Station Service Date",
"Tablet Make", "Tablet Make Other", "Tablet Status", "Tablet Model", "Tablet Model Other", "Tablet Asset ID")
));
ClearCollect(colExcelMergedFinalExport,
If(
varExcelPersMonColVis, DropColumns(varExcelMergedExport,
"User Name", "User Branch", "User Email", "User Phone", "User Department", "User Job Title", "User Manager",
"Branch Inventory", "Admin Name", "Admin Email", "Admin Phone", "Admin Department", "Admin Job Title", "Admin Manager",
"Job Number", "Job Supervisor Name", "Job Supervisor Email", "Job Supervisor Phone", "Job Supervisor Department", "Job Supervisor Title", "Job Supervisor Branch",
"Repair Location", "Repair Status",
"Harness Make", "Harness Make Other", "Harness Size", "Harness Status", "Harness Serial", "Harness Service Date",
"Lanyard Make", "Lanyard Make Other", "Lanyard Size", "Lanyard Status", "Lanyard Serial", "Lanyard Service Date",
"Self-Retracting Lanyard Make", "Self-Retracting Lanyard Make Other", "Self-Retracting Lanyard Size", "Self-Retracting LanyardStatus", "Self-Retracting Lanyard Serial", "Self-Retracting Lanyard Service Date",
"Anchor Sling Quantity", "Anchor Sling One Status", "Anchor Sling One Service Date", "Anchor Sling Two Status", "Anchor Sling Two Service Date",
"Lock Box Quantity", "Pad Lock Quantity", "Cable Lock Quantity", "Breaker Lock Quantity", "Scissor Lock Quantity",
"Arc Flash Suit Assigned", "Arc Flash Suit Rating", "Arc Flash Suit Serial", "Arc Flash Hood Assigned", "Arc Flash Hood Rating", "Arc Flash Hood Serial", "Arc Flash Gloves Assigned", "Arc Flash Gloves Rating", "Arc Flash Gloves Serial", "Arc Flash Gloves Service Date",
"Ear Muffs Make", "Ear Muffs Make Other", "Ear Muffs Model", "Ear Muffs Model Other",
"Bump Station Make", "Bump Station Make Other", "Bump Station Model", "Bump Station Model Other", "Bump Station Status", "Bump Station Serial", "Bump Station Service Date",
"Tablet Make", "Tablet Make Other", "Tablet Model", "Tablet Status", "Tablet Model Other", "Tablet Asset ID")
));
The first If statement drops all columns except the Date Assigned and User columns from the list based on varExcelAssignColVis being 'true'. Here is the result of the first ClearCollect of colExcelMergedFinalExport:
The second If statement drops all columns except the Date Assigned and Personal Monitor columns from the list based on varExcelPersMonColVis being 'true'. Here is the result of the second ClearCollect of colExcelMergedFinalExport:
As you can see, the User columns reappear in the new iteration of colExcelMergedFinalExport even though they are clearly listed in the DropColumns function!!! This is insanity!!
Can anyone explain this behaviour and how to stop this from happening.... I have tried adding a Clear(colExcelMergedFinalExport); function on top of the ClearCollect... I am at my wits end...
I need to be able to dynamically reduce the master table to a final table for export to excel... based on user input to show/hide columns of preferred data... And am prepared to manually create all of the possible If scenarios but cannot overcome what appears to me, to be a major flaw or bug in how PowerApps handles tables.
Thanks in advance for reading and hopefully someone, somewhere knows SOMETHING about this strange issue...
