You’re offline. This is a read only version of the page.
30
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!!!
@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
Hi @HenryPF ,
Something like this should do it
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
