I created a check in app based off a sharepoint list and I would like to assign the next available number after the user checks in. In the app the user clicks date and time and then a check in button and it updates the CheckInTime column in my sharepoint list. I have created another column called called CheckInTkt. What I want to happen is if the first user checks in at 1:00pm then I would like CheckTKT to update to 1 and then if another user checks in at 1:05pm then CheckItkt would update to 2. For the life of me, after hours of google searches and videos I can not figure out how to do this.

Currently I have a huge spreadsheet with all the employees in my company and their IT Assets, Software permission for all applications, licensing, specific PII and PHI places that employee and more. My original plan was to put it all in a SPO List and build a form for it. But now that I am learning more about PowerApps I am wondering if I should have it all in one list, break it out into multiple list, or use dataverse? How do you know know when to use what? I have a bunch of large sharepoint list and it has never occurred to me to break them out into different list and use power apps to present them until I was watching one of your videos last night.