I have an existing SharePoint list with about 2000+ records in it. I forgot to make an index column and need to add one now. However when i add a new column and enforce value in it, its still empty and need to fill it like serial number. I am not able to use drag and fill like excel or copy paste from Excel. Can someone suggest a solution please.
PS - I understand there is an existing ID field how ever I can not utilize this for a function in powerapps where i am trying to grab latest 1000 items from SharePoint to avoid delegation issues.