Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Project number assigned automatically

(0) ShareShare
ReportReport
Posted on by 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

  • LucaNeedsHelp Profile Picture
    LucaNeedsHelp 207 on at
    Re: Project number assigned automatically

    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.

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Project number assigned automatically

    @LucaNeedHelp 

    Hope that helps!

     

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

     

     

    SudeepGhatakNZ_1-1711096439028.png

     

    SudeepGhatakNZ_0-1711096415544.png

    SudeepGhatakNZ_2-1711096599304.png

     

    SudeepGhatakNZ_3-1711096650744.png

     

  • LucaNeedsHelp Profile Picture
    LucaNeedsHelp 207 on at
    Re: Project number assigned automatically

    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.

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Project number assigned automatically

    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')

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard