Forum Discussion

Brass Contributor

Jun 02, 2020

Solved

Unique ID issues calculation looses [] every time page is refreshed

Morning, Hope someone can help. I created a UID field using the concatenate function with a prefix and then the ID field. =CONCATENATE("HUB",[ID]) The issue is the [] round ID disappear e...

Lists

microsoft lists

SharePoint Online

Ashish_Kohale
Jun 03, 2020
John Dorrian : Thanks John !... You need to create a separate number column, e.g. called [UID]. Then you need to create a flow that will fill in this column with the actual ID value like HUB123.

Creating flow will be easy and fast solution in this case.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Regards,
Ashish

John Dorrian

Brass Contributor

Jun 03, 2020

Ashish_Kohale

Thanks for the info, and at least I know not to use [ID] for calculated fields.

I think as a workaround I could do just use the ID field as is (sequential number) within the list but for the Flows and automatic emails add the list prefix (in this case HUB) before the ID field so when queries come in to the service desk they know which list and record to look up.

I'll look into java and jquery when I have a bit of free time. Thanks again for the info, every day is a school day 🙂

Kind Regards

John

Ashish_Kohale

Iron Contributor

Jun 03, 2020

John Dorrian : Thanks John !... You need to create a separate number column, e.g. called [UID]. Then you need to create a flow that will fill in this column with the actual ID value like HUB123.

Creating flow will be easy and fast solution in this case.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Regards,

Ashish