
Announcements
Hi all,
I have a table that uses autonumber column as primary name column. It was working fine until importing data from excel for data migration. As you can see in the screenshot, 1 duplicate record is from data import from excel and another one from user submission. Are there any solution to have unique data when new record was created and how to fix existing data?
Thank you.
When you create as a user, you could do sometihn like this:
Patch(List, Defaults(List), {
Id: Last(List).Id+ 1,
Item1: Item1})