Answered

auto increment number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hi Expert

i have a list which contains

if you see above i want the event number to start from 1 whenever new fiscal year starts and for any new event created the number gets added by 1 (it will check the list validate and add 1 to the last number). lets say if there are 100 event number for fiscal year 2020 than the series would be from 1-100 and for next year it will again start from 1

thank you in advance

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Sunil-Narnaware 681 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
lets say if there are 100 event number for fiscal year 2020 than the series would be from 1-12 and for next year it will again start from 1
Can you elaborate more on this? because you say 100 events but they have 1-12 # only.. so does it repeat after 12.. till 100 are not done..
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

my bad its 1-100
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please tell me where your data is stored? What are the data types of the two columns?

I have made a simple test for your reference.

1.Here is my SharePoint list.

2. Here is my App.

If(IsEmpty(Filter(FiscalList,'Fiscal year'=DataCardValue5.Text)),1, Sum(First(Sort(Filter(FiscalList,'Fiscal year'=DataCardValue5.Text),Event,Descending)).Event,1))
Text(Now(),"yyyy")

Result Screenshots:

Best Regards,
Charlie Choi