web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Create Unique Customer ID

Power Apps

Answered

Create Unique Customer ID

(0) Share

Report

Report

Posted on by Djack

44

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

All responses Img

All responses (7)

Answers Img

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.
Djack 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Djack 44 on at

Like
a
(0)

Report
Copy link

Link copied!

But the concat is the issue here i get the error message that the formula is wrong.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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())))
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
Verified answer

Djack 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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

and problem was fixed

Join the conversation