Power Platform Community Forum Thread Details

I have a sequential value field (named Inventory Code) in SharePoint list and a Category Field(named Line of Business) which is a choice column. I have used the formula in Inventory Value field in such a way that when I select a category from drop down, the inventory Code will increment accordingly.

Concatenate("0000",Coalesce(ThisItem.Inventory Code,Value(LookUp(Sort('Inventory List',ID,SortOrder.Descending),'Line of Business'.Value=DataCardValue8.Selected.Value).Inventory Code+1)))

Now the issue is when user XYZ select one Category from drop down it generates Inventory Code before submitting the form. At the same time if user ABC has selected same category in his browser he is also getting same Inventory Code.

Now when they both submit the data, the Inventory Code is getting duplicated which should not happen as the code should be unique

Note: I have unselected "Enforce unique values" in SharePoint from Inventory Code field as I have to generate values based on Category Field(Line of Business)