Unanswered

Make project id which is a combination of other fields

(0) Share

Report

Posted on by upadharp

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.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Federico Pelliccia 143 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
upadharp 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hussein Wahba 55 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No