Collection keeps changing column name

[IncursioML1]

When I exit the Power App altogether, does any collection get deleted altogether?

There seems to be something that's happening in which a collection keeps using the name of another collection.

In the below example, the SumOfUsage is from a Filtered SharePoint List in which a field is set up as 'Order Number'.

However, when I create a new collection called CleanUsage, I noticed that even if I use a new naming convention of 

RecordType: "Usage,"
OrderNumber: SumOfUsage[@'Order Number'],

some times PowerApps converts it to this

RecordType: "Usage",
'Order Number': SumOfUsage[@'Order Number'],

This results in some funny behavior in the 'CleanUsage' collection in which I get 2 fields of 'Order Number' and OrderNumber.

I thought when I use the assignment of the field name that it should just use that new naming convention that in a new collection?

Maybe the collection isn't being cleared when the app closes?

[RandyHayes]

@IncursioML1 

Variables (including Collections) do not persist beyond the app session.

Your formula is a little backward, so if you could describe that it is that you're trying to do and what the purpose of a collection is in this case, perhaps I could provide more assistance. 

[IncursioML1]

There is a collection created from a sharepoint list in which doesn't become record base and has tables within some of those fields since SharePoint has some of that other meta data like GUID, user meta data etc. That forall was just trying to get things into records so that I could ultimately join up 3 sharepoint lists into 1 collection by appending them altogether.  (appending vertically that is with the same field order created from a new collection)

Would you have any other suggestion? Ultimately I just want those 3 sharepoint lists in a collection, but the Purchase one from Sharepoint had to get created into a collection vs. straight SharePoint list due to the record limitation the other two lists don't have the record limitation nuance.

I think I also messed up created the collection initially with the naming convention and have been trying to remove references to that collection to clean up some things.  There seems to be no way to delete a collection object and references vs. just deleted records itself when you have the app open.  

[RandyHayes]

@IncursioML1 

So, the first question I would have then is why a collection?  Are you planning to treat this as an in-memory database?  

Although a collection can take multiple datasource and sort-of combine them together, the schemas are usually all over the place.  Once a collection is given a schema in the designer, it remembers it until the app is closed and reopened, and then the editor will reassess the schema again based on definitions.  The editor is ALWAYS reevaluating schemas based on any changes you make...so, if you make a schema change that you didn't really want...it's too late - the editor has now inferred the schema and will not let that go until you exit and reenter. It's quite a pain!  That's why personally, I like to have a well defined schema - in the case of an underlying datasource, that is the schema...when combining datasources, I opt to define the schema so that all sources match the same schema.

So, perhaps I can shed some help on the overall scenario with some answer to - what is the purpose of the collection and why a collection?

[IncursioML1]

The collection is to display data in a tabular format - I'd rather not have a gallery.