Answered

Order Number ID based on current year and Sharepoint List

(0) Share

Report

Posted on by HenryPF

Hi, when a user creates a new order, there's a field that should automatically create a unique Order Number ID, with the format:

RMyy-next id number in Sharepoint List for that year

So for example by the end of 2022, new orders should have been something like:

RM22-0567

RM22-0568

Then on the 1st of january of this year 2023, they should start being:

RM23-0001

RM23-0002

etc.

Is this possible? Could someone please share the formula I need for the Text field?

Thank you so much!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 154,528 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @HenryPF ,

Something like this should do it

With( { wNo: Split( Last(ListName).'Order No ID', "-" ) }, With( { wYear: Value( Right( First(wNo).Result, 2 ) ), wOrder: Value( Last(wNo).Result ) }, "RM" & If( wYear + 2000 = Year(Today()), Text(wYear) & "-" & Text(wOrder + 1, "0000"), Text(wYear + 1) & "-" & "0001" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
HenryPF 30 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, thanks for the help.

For some reason I'm getting RM24-0001 instead of 23 (current year 2023).

Was this reply helpful? Yes No
WarrenBelz 154,528 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@HenryPF ,

Problem with not testing free-typed code - needed to add 2000 to the year - please see amended post.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
HenryPF 30 on at

Like (0)

Report
Copy link

Link copied!

Yay!! That worked!! Thank you so much Warren, you're a beast!!

Was this reply helpful? Yes No
queenc23 6 on at

Like (0)

Report
Copy link

Link copied!

Disregard

Was this reply helpful? Yes No