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!
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.
Hope that helps!
I have stored the initial ID in a excel file and I keep updating it after every flow run.
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.
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')