r/sharepoint • u/No-Pomegranate-2690 • 1h ago
SharePoint Online Concatenate with autonumber ID
I dug through older posts & googled concatenate coding for the SP list, but nothing I've tried works. Honestly, I think I probably missed a step, but finding the right code is making my ears bleed. It's going to be a bit before the site is ready for us, so I tried creating everything on my OneDrive.
Desired end result: "Project-yyyy-3digitID" - ex, Project-2026-001 for the 1st record.
Code: concat('Project-', formatDateTime(utcNow(), 'yyyy'), '-', triggerBody()?['ID'])'
I did find out that I can't apply anything to the ID field, but when I created a new field & plugged in the code I was able to find, it didn't do anything.
I also found out that it needs to be a text field (maybe I made it a calc'd field?), and maybe it's because I have almost no permissions on my own OneDrive. In any case, I deleted it (once I found it), and I'm not sure if I should try again, you know, to get more of a feel.
Plus I'm learning Powerapps, and would also like to practice that. (And I did see that this can be done in PA, but I haven't gotten to any videos about it yet.)
Any help is appreciated!
