Generating a random invoice number

(0) Share

Report

Posted on by T_A_M

332

Hello all -

I need to generate a completely random invoice number in an app, and I've found a formula that works:

Right(Text(Rand()*10),3)&"-"&Right(Text(Rand()*10),3)

However, I'm not sure how to keep the number from recalculating every time my form is submitted. Once this number is generated it needs to remain associated with its item, and never change.

Any ideas would be greatly appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Silvester. Akakpo 783 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @T_A_M ,
Kindly try setting it up the value in a variable
Set(VarInvoiCceNum, Right(Text(Rand()*10),3)&"-"&Right(Text(Rand()*10),3))
You can attach the variable to the record while submitting the form.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@T_A_M

No need to use a variable. Set the Text property of the InvoiceNumber control to

Coalesce(Parent.Default,Right(Text(Rand()*10),3)&"-"&Right(Text(Rand()*10),3)), When the form is in new mode, the Parent.Default will be blank and then your formula will generate a random invoice number. When the form is in edit mode, the already assigned random invoice number will be the Parent.Default and a new number will not be generated. I would set the Display property of the card containing the invoice number to disabled to prevent users from changing it or trying to assign one.

Was this reply helpful? Yes No
T_A_M 332 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! That worked perfectly.

Was this reply helpful? Yes No