Answered

I want to make this number start over with 1 when the year changes

(0) Share

Report

Posted on by Bingqiling

321

There is a field where DB is sharepoint and data type is text.
I'm automatically creating a field where 1 is increasing. But I want to make this number start over with 1 when the year changes.

if this year is 2023, 2023_1~
if this year is 2024, 2024_1~

if this year is 2025, 2025_1~...

What can I do??

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Bingqiling ,

Please try this

If(CountRows(Filter(LIST45,Year(Today()) in Text(Created)))=0,Year(Today())&"_1",Year(Today())&"_"&(CountRows(Filter(LIST45,Year(Today()) in Text(Created)))+1))

Best Regards,

Wearsky
Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!

If I use it like this, will the third number be 2024_3 in 2024??
I am currently setting up the document number of the application.
The documents you applied for in 2023 will start with 2023_1
Documents filed in 2024 start with 2024_1.
Then, I wonder if the 5th document I applied for in 2024 will be 2024_5.
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Bingqiling ,

Yeah, if no file was created in that year, then it will be <year>-1.

If some files were created in that year, then it will automatically increase the latest file ID by 1.

Best Regards,

Wearsky