Hi Guys,
I have the following patch formula saved on a Save Icon within a Gallery: Patch('CN FX Imports Tracker', ThisItem, {Remarks: TextInput1.Text}). It used to work wonders until I updated my collection to pull out more than 2000 line items. Initially, I was working with my SP list (CN FX Imports Tracker) as my gallery datasource. However, I noticed that I was not pulling records beyond 2000 rows. So I followed some guide and used Microsoft Flow PowerAutomate to pull all data records first and throw back the consolidated result to PowerApps. I then collected that data into a collection (let's put it as 'New FX Imports Tracker') and can confirm to see all records beyond 2000 rows now. However, when I updated the gallery to this new collection, my patch function is now returning an error message in the ThisItem line saying 'Some column is not existing'.
However, I'm pretty sure that the column it's saying is existing. I created 2 datatables using the SP list (CN FX Imports Tracker) and another one using the New FX Imports Tracker, pulled out the column, and I can definitely see the data for both, so it's not missing! Now, if I update my Patch function to put the 'New FX Imports Tracker' as the datasource, the error disappears! BUT, i want to patch the SP list directly instead, not my collection. Below are some pictures:
My Data for your information
Sharepoint List - CN FX Imports Tracker
Collection (for more than 2000 rows) - New FX Imports Tracker
What I want to do: Patch a single record (column) directly to my SP list
Gallery Datasource before issue: CN FX Imports Tracker
Patch Function that was previously working - Patch('CN FX Imports Tracker', ThisItem, {Remarks: TextInput14_1.Text})
Gallery Datasource with issue: New FX Imports Tracker
