I am very new to PowerApps and programming. I have built a canvas app from a list of records in excel. I realised after I had built the app that there were limitations to using excel so transferred the record to a SharePoint list and deleted the excel file. I switched over the data source to the SharePoint list and the app is working well. I have increased the amount of records to look up to 2000 which easily covers the amount of records in my database (1500).
The difficulty I am now facing is that when I create a new record within the app, it adds it to the SharePoint list. However, the record does not appear within the gallery view/search in other parts of the app.
I have used the refresh function on the data source and used refresh as part of the formulas within the app and still the records do not appear.
Looking at the SharePoint list the only difference between the new records and the old records I imported from excel is that there is a _powerappsid_ column with a code which the new records do not have. Is this the cause of the problem? Any ideas?
