Hello Team,

I am new to Nintex workflow. My requirement is to add a column in the sharepoint list which will have a constant and ID value together as  a string everytime a new item is created. 

Example: for first item ID will be 1 and new column will have value A1 and will be A2 , A3 etc for 2nd and 3rd item respectively. 

I tried creating a workflow by 

1. Quering the list and do descending sort based on ID column and assigning ID values to a variable as output

2. use get Item from Collection method and get the first value using index = 0 and assign to a variable

3. create a workflow variable and assign it a constant , in our example "A"

4. Use build string to concatenate variables from step 2 and step 3 using {var1}{var2} and assigning it  to output

5. use Set Field in current item to add the value from step 4 to the new column 

It is not working. I am using Nintex workflow for O365. Can you please guide me ?

Regards,
Sandeep