Answered

Generate ID depending on a year

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I don't have an idea where or how should I start doing this ID generating. Idea is to have unique ID's depending on the Start Date which is stored in SP List. ID looks like this YYXX-001-999 if current start date is 2022 then ID should be 22XX-041 and going up. If we have project start 2023 and for example this is our first project that starts in 2023 then ID should skip the 22XX-041 and start new iteration for 2023 which is 23XX-001 and going up.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous ,
You can use the below function in Screen's on Visible property - Set(varYear2,Right(Year(Today()),2));If(IsEmpty(Filter(Holidays,StartsWith(UniqueID,varYear2))),Set(varUniqueID,varYear2 & "XX-" & "000"), Set(varUniqueID, varYear2 & "XX-" & Text(Value(First(Sort(Holidays,Created,Descending)).UniqueID)+1,"000")))
And in your ID datacard set the default value to - If(Form1.Mode=FormMode.New, varUniqueID, Parent.Default)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey thank you for quick response. I tried it and it works with new year but I believe this Set(varUniqueID, varYear2 & "XX-" & Text(Value(First(Sort(Holidays,Created,Descending)).UniqueID)+1,"000"))) gives me 001 for some reason instead of adding to last value

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous ,
Please find below updated formula -
Set(varYear2,Right(Year(Today()),2));If(IsEmpty(Filter(Holidays,StartsWith(UniqueID,varYear2))),Set(varUniqueID,varYear2 & "XX-" & "000"), Set(varUniqueID, varYear2 & "XX-" & Text(Value(Right(First(Sort(Holidays,Created,Descending)).UniqueID,3)+1),"000")))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It increments the ID but the wrong one.
You can see in the image we have ID 2260-331 so if start date is 2022 then we should make next ID 2260-332 and doesn't mind that there is IDs before

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Can you try using below formula -
Set(varYear2,Right(Year(Today()),2));If(IsEmpty(Filter(Holidays,StartsWith(UniqueID,varYear2))),Set(varUniqueID,varYear2 & "XX-" & "000"), Set(varUniqueID, varYear2 & "XX-" & Text(Value(Right(First(Sort(Filter(Holidays,StartsWith(UniqueID,varYear2)),Right(UniqueID,3),Descending)).UniqueID,3)+1),"000")))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Looks good so far. I will do some testing

Was this reply helpful? Yes No