web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Make project id which ...
Power Apps
Unanswered

Make project id which is a combination of other fields

(0) ShareShare
ReportReport
Posted on by 8

I want my project id to be a combination of first 3 words of project name+first 3 words of business unit+current month and year+"_"+001( number series which go on increasing).

how can i do this, Please help.

I have the same question (0)
  • Federico Pelliccia Profile Picture
    143 on at

    First of all, are we talking about Canvas or Model Driven App? If we are talking about Model Driven app, you can do this in two ways. First, using a javascript that on the OnSave event read all the element you need and set the project id field.
    Second way, write a pre-create plugin and to the same operation server side.

    Both problem has the problem of concurrency. If two people read in the same time the last "001" number, you could have two "002" value.
    A possible solution is to create an autonumber value hidden on the form. When you save you record, the autonumber is being populated with the next correct number and you car read it, adding it to your combinated string

  • upadharp Profile Picture
    8 on at

    I am talking about Canvas App, Please suggest me ways on how to achieve this in the canvas app.

  • Hussein Wahba Profile Picture
    55 on at

    As you are talking about the Canvas App, then the incremental part much better be in the database.

    Where will you save the data?

    If you save it in Dataverse, so you can try creating a plugin as FPelliccia said.

    The other parts of the project id also better be in the backend if you have because it will be long code in the Canvas App.

    - Concatenating multiple texts will be by using the "Concatenate" function that have multiple text parameters.

    - First three words of input text will be by using the function split that create array of fields then using for loop you will take the first three words only.

    - Current month:  Text(Today(), "mmmm")

    - Current year Text(Today(), "yyyy")

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 88

#2
WarrenBelz Profile Picture

WarrenBelz 85 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 45

Last 30 days Overall leaderboard