The data source is an excel file. The removeif is structured as follows:
RemoveIf(datasource,true) where datasource is a table defined in the excel file.
The collect function is structured as follows:
Collect(datasrouce,collection) where collection is a collection created in the app from a series of other data sources and some adjustments.
It appears I am having the most difficulty in the formats that have dates. When I run the removeif and then the collect - after the first run (runs 2 onward) - it changes the formats from date to general and places <dateTtimeZ> in them. ie: it is changing 2/1/2017 to 2017-02-01T04:00:00.000Z.