Hi All, since the last couple of days i'm experiencing very strange problem in Power Apps.
When a new record is created in the app, I usually take the last number of the Title column from SPO (which column contains only numbers!) and increase it with one to generate the next item number. Pretty simple formula which everyone here used at least once in an app.
SPO list name: Purchase Requests
Collection name: NewPurchaseCollection
So, the formula shows that the next number should be 2036, which means the previous was 2035, but this is not correct as the last number is 2038, so the next one must be 2039, and so on.
The problem is that every record that is created is considered as 2036 so every time the formula finds only 2035 as the last number.
I've refreshed the lists multiple times (the data sources) but still the same, i've tried using ID filed instead, but also the same issues
Any suggestions what is going on here?
Regards,
Kiril