
Hello All, I appreciate this may be in the wrong place but looking for some help!
I have wanted to create a custom ID starting from a 90000. So i have created a calculated column for 90000+[ID].
This works when I first update, but whenever I create a new item the custom ID field resets? Any ideas how to stop this from resetting every time?
above is an example of when modified it changes?
The above is the calculation I am using, but it keeps resetting!
Please Help!
Don't use SharePoint calculated columns they don't react reliably with PowerApps. Do the calculation in PowerApps and save it to a number column. In your case, create a new number column say, xid, and enter a dummy record with xid=9000. In PowerApps use the formula First(Sort(splist,xid,Descending)).xid+1 to assign the next number in the series to the new record.