Forum Discussion
Creating unique ID's in bulk
Raydris the way you describe it doesn't seem to me to be efficient and is prone to error. And surely it means that in your flow you are going to need 99 "create item" actions! Not a good idea although you could set the flow concurrency to 1 to reduce that risk of error.
If I was doing this I would have a separate list for each user so that when a new item is added for that user it is automatically sequential (for that user) because of the ID.
Then I'd build a Power Apps front end that gets the items assigned to that user (based on their M365 login) in a gallery, they can add new items etc. You could then have a screen or a flow that grabs all the assigned items from each list and puts it into an email or a separate "master" list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Thank you RobElliott , for taking the time to review my question.
We are a small team of 6 people creating unique ID's for the products we produce - today we are using an excel sheet for this exact purpose I described above. There's a separate list (master list for products) where team members have to add each new product (or edit) and fill in columns (either single row, or an automated bulk dump) - which only accepts unique numbers in a set format (same format as the 99 bulk unique ID's). Thus, each user doesn't have its own unique ID, you could say the whole team has the same ID format.
The convenience quickly outweighs the risk (for us at least). I will probably be adding new sequential numbers in bulk manually, as it usually takes a team member months to "spend" his bulk of 99 unique numbers, and request a new bulk. I want my engineers to spend minimal time
I just wanted a way out of using this excel sheet, as I have plans to integrate and automate the sharepoint list further into PowerApps (so they dont have to deal with lists (back-end) but a PowerApp interface (Fron-end). But alas, if it is simpler to manually add bulk, i can take an hour or two to manually add in this format which will probably clear the need for the next couple of years 😉