Create Unique Customer ID

(0) Share

Report

Posted on by Djack

I want to generate a unique customer id

The ID is XXXTRYYYYY

XXXX = Lookup of a counter + one

YYYY = Current year

Set(VarNextID,LookUp(TRIAMANT_TELLERS, Application="TriamantERP",CustomerID)+1);
Set(VarCurrentYear,Year(Now()));

I miss the VarNextCustomerID

This does not work

Set(VarNextCustomerID, Concatenate(VarNextID,"TR",VarCurrentYear));

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Can you show a sample of your table
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@Djack

Your formula is flawed.

LookUp(TRIAMANT_TELLERS, Application="TriamantERP",CustomerID)+1) should be First(Sort(TTRIAMANT_TELLERS,CustomerID,Descending)).CustomerID+1)

First(Sort( is used because Last() and Max() functions are not delegatable and will give incorrect results once the Items limit is exceeded. First(Sort( will work no matter how many items are in the table. Also, I am assuming that CustomerID is a number not a text value.

Was this reply helpful? Yes No
Djack 44 on at

Like (0)

Report

The table holds 3 fields
Field 1 counter CustomerID
Field 2 counter ContractID
Field 3 counter AccountingID

Nothing special
The concatenate does not work ... gives error that something is wrong.

Was this reply helpful? Yes No
Djack 44 on at

Like (0)

Report

But the concat is the issue here i get the error message that the formula is wrong.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@Djack

Concatenate requires text fields. You will need to wrap numbers and dates in the Text() function.

Concatenate(Text(First(Sort(TRIAMANT_TELLERS,customerID,Descending)).customerID+1),"TR",Text(Year(Now())))

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Djack :
Could you tell me what CustomerID's data type is?(Set(VarNextID,LookUp(TRIAMANT_TELLERS, Application="TriamantERP",CustomerID)+1);)
I assume CustomerID is a number filed.
Firstly,let me explain why you encounted this problem.
The Concatenate function can only concatenate strings but 'VarNextID' and VarCurrentYear are number.
Secondly,I suggsest you try this code:

Set(VarNextCustomerID, Concatenate(Text(VarNextID),"TR",Text(VarCurrentYear)))

Or

Set(VarNextCustomerID, VarNextID&"TR"&VarCurrentYear);

Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

Djack 44 on at

Like (0)

Report

Fixed it.
The concatete function needs have text to work with
Set(VarNextCustomerID, Concatenate(Text(VarNextID),"TR",TEXT(VarCurrentYear)));

and problem was fixed

Was this reply helpful? Yes No