Answered

Auto generate ID up to a maximum number

(0) Share

Report

Posted on by DCW1992

Hello,

I am attempting to build a form/list in which when a new response is submitted the list generates a reference number. However I am wondering if there is a way to keep this number to a maximum of 2 digits, so that when it gets to 99 it the next row will become 1 again.

TIA

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you use the ID number of the list item? This will obviously get larger than two digits if you have more than 99 items. However, it will always be unique and not repeated.

I guess if you absolutely must have only two digits, you could still use the List Item Id number but only take the last two digits.

Do you think that would work for you?

Was this reply helpful? Yes No
DCW1992 4 on at

Like (0)

Report
Copy link

Link copied!

@wskinnermctc Thank you for your very quick reply. The second option would be best, repetition of ID’s is not an issue and 2 digits is a must due to another systems limitation.

How would I ensure only the last two digits of the list ID showed - a calculated column?

Was this reply helpful? Yes No
ScottShearer 25,278 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DCW1992

You could approach this in a number of different ways. Probably the easiest way is to have a separate list with a single row of data - let's call this the Reference list. Any time a new item is created in the primary list, grab the single row of data from the Reference list. The value of the number and use it. Then, update the number stored in the reference list. If the current number is 99, update it to 1. Otherwise add 1 and save to the Reference list. This is not a great solution if the list will be updated frequently.

Let me know if you need help implementing this solution and let me know where your data is stored.

Another way is to retrieve the last item saved to your list. Add 1 to the number value or use 1 if the value last used was 99.

Once again, let me know if you need help.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!
Add a List column of single line text type.

After you initially Create Item in the list, add an Update Item action afterwards. Then put the Id in an expression function that will get the last two digits out of the ID.

This expression below will result in the last two digits as in '00', '01', '02',...'54','55','56',.....'98', '99', '00', '01, etc,

substring(string(formatNumber(outputs('Create_item')?['body/ID'],'000')),sub(length(string(formatNumber(outputs('Create_item')?['body/ID'],'000'))),int(2)))

Here is a quick example in a flow:

Create the Items - Format the ID of new item - Then Update the item

Was this reply helpful? Yes No