I have a collection which is taken from a Sharepoint list of Students. This has FullName, FirstName, etc.
I then have another collection, but this is taken from a Sharepoint list of Staff with StaffFullName, StaffCode, etc.
When I add a new item to the Student collection, that works fine.
When I add a new item to the Staff collection, it appears to add it to the Staff collection as the gallery displays the right information. However, on Collections, the name is Staff collection on the right, then when I click on it it says Student Collection and displays the Student Collection columns. There's no data in it either, which I think is the reason why I cannot patch it.
I've tried closing the app but the collections are always there on opening, which I didn't think would happen, given they are local?
I can't get rid of the collections and setting up a new one just does the same thing by setting the columns up to match the Student one every time. I've ensured all column names are different, but I cannot change some Sharepoint column names, such as ID.
Has anyone had this problem and if so, how on earth do I resolve it? I've searched any button which adds data to the collection and they all appear good.