How to generate auto increment reference number format BER/ANG/001/2023 in power Automate?

Like (0) Share

Report

Posted on 20 Dec 2023 12:42:19 by berihunaddis

When Item is created in share point list,I want to generate reference Number i.e BER/ANG/001/2023. How to do that? the incremental Numbers will be 001,002,003... the others BER/ANG and Current year 2023 remains constant

All responses (1)

Answers (1)

Verified answer

cmht 82 on 20 Dec 2023 at 14:15:55

Like (0)

Report
Re: How to generate auto increment reference number format BER/ANG/001/2023 in power Automate?

Hi @berihunaddis
Use a variable which you will increment.
You can add additional SharePoint list which will store your number.

For the year I would use Compose:
utcNow('yyyy')
so this will always give you the current year.

Auto increment value - initializing variable which will keep it:

Now we read the current value stored on a helper SharePoint list:
and we are setting varInc to the value we have on the SharePoint list.

Now it would be ok to convert it to integer (to be able to increment it):

int(variables('varInc'))

Now incrementing this value:
add(outputs('Convert_varInc_to_integer'),1)

and save (update) on SharePoint, so next runs will read the current number and add +1 with the flow run:

so now you may configure your invoices numbering as:
BER/ANG/outputs('Increment_varInc_value')/outputs('ComposeYear')

This will give you number as 1, 2, 3 and not 001, 002, 003.
Explanation and solution is here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-leading-zeros-to-digits-using-Text/m-p/269603#M78771