Project number assigned automatically

(0) Share

Report

Posted on by LucaNeedsHelp

207

Hey Guys, I need you help...

I want to set up an automation where a form survey is conducted. This survey should be sent directly via email as a PDF. In the subject line, I would like to automatically assign a project number. Starting with the year (24), followed by the letters AU as an abbreviation, and ending with a numbered sequence. Starting with 0001, 0002,... 24AU0001

I have completed a form survey. I also receive this survey as a PDF via email. But how do I automate the numbering and keep it updated? So that each time a survey is submitted, a new order number is assigned.

Thank you!

Screenshot 2024-03-20 154527.png

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You need to save the Newly generated ID somewhere, for instance a SharePoint list.

Get the Current value in a Variable, then generate the Project Number using string manipulation

Get Year

formatDateTime(utcNow(),'yy')

Get padded number

formatNumber(variables('Incremented Number'), '0000')

Was this reply helpful? Yes No
LucaNeedsHelp 207 on at

Like (0)

Report
Copy link

Link copied!

Hi SudeepGhatakNZ,
first thank you for your help!
I am really new to Power Automate, and I do not really understand what you mean. Could you describe it in more detail, maybe with some photos?
That would be awesome!

I tried it with Excel. Power Automate simply gets the number from an Excel table where the number is generated. I would just have to make sure that a column is always filled by a trigger, as the number is made up of all the characters in a column. The number in column F is then "0000". If there is a character in four cells in column F, it automatically becomes "0004". The question would then also be if I do it this way how to always get a new cell described.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@LucaNeedHelp

Hope that helps!

I have stored the initial ID in a excel file and I keep updating it after every flow run.

Was this reply helpful? Yes No
LucaNeedsHelp 207 on at

Like (0)

Report
Copy link

Link copied!

Okay, but is it still working, if the Temas Excel list is closed? How is the list updatet? I have filled out the forms several times in a row and then the list does not update if it is not open.

Was this reply helpful? Yes No