Unique Row ID

Hi guys

I cant seem to figure this one out, so I would love some input on this:

Basically I am looking for a way to create a unique ID for each Row. Each row has 30 columns of Data.

The Excel sheet is stored in a SharePoint and there are daily entries with new rows from multiple users and the table will increase with approx.. 5000 rows each month.

I have tried to use the =ROW() formula, but as it is an excel365 document that has new entries from multiple users, they often sort the table, which renames the tables.
I have also tried to do a =CONCAT() function, but as this is used in a MS Flow/Power Automate setup, there is a limit of 256 characters for each cell and that causes some challenges.

Is there a way for Excel to assign each new row added row with a unique ID? And not making it dynamic, so it does not change when sorting?