Answered

Sequence Number in Power Apps

(0) Share

Report

Posted on by Community Power Pla...

Hello Experts ,

I have one field in my power App call ActivityID , i want this activity ID to be auto generated and increment by 1 whenever new record created, so i am writing this on datacard value.

If(Frm_02.Mode= FormMode.New,Concatenate("BG-",Text(Right((Last('BG Activity Recorder').'Activity ID'),Len((Last('BG Activity Recorder').'Activity ID'))-3)+1)),Parent.Default)

But this only works when i am continuously working on the app , when i close app and open again its start with some random value which already exist in my SP list.

ideally this code should check last number inserted in the SP list and increment it by one as per the format. regardless from where i am inserting record (Phone or System). when i am generating record from phone it does not take the last inserted activity number. it takes some already exist number. please advise my requirements are below.

: field should generate automatic sequence number when we create new record

: it should check the last inserted number in SP list and then increment by 1

: if one person entered record and it saved in SP list , it should take another sequence number.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

eka24 20,923 on at

Like (1)

Report

Can you show a sample of how the serial number looks like in the SharePoint list.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like (0)

Report

Hello @eka24 , Thanks for looking into this. below is the screen shot.
This is not sort as per activity ID , if it will sort the largest number would be. BG-9 , i am not sure if the function "last" takes the largest number , because in app every time i am getting BG-10.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (2)

Report

Last takes the last on the row not the largest.

I suggest you enable the Autonumber columns in your SharePoint and concatenate BG- with it into another column that is another way.

On your formula, because last or for first is not delegable, you Will have issues unless you include Sort function in your formula.

I will get back to you later in the day.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (2)

Report
Apart from the Autonumber I suggested, you can change your formula to:

If(Frm_02.Mode=FormMode.New, "BG-"&First(Sort(AddColumns('BG Activity Recorder',"NewCol", Trim(Substitute('Activity ID',"BG-",""))*1),NewCol, Descending)).NewCol+1,Parent.Default)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like (0)

Report

Hello @eka24 , Thank you so much for your help it is working fine now after the correction you made in formula.

Have a great day 😀

Was this reply helpful? Yes No
AndreaBrunello1 11 on at

Like (0)

Report

Hi @eka24

I would also be interested in your solution, could you please explain how to create a autonumber column on the sharepoint list?

many thanks for the support

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

If it about autonumbering with usual numbers as 1,2 3,4 then enable the ID column in sharepoint.

Otherwise if you meant the solution on this post; check my youtube channel:

https://youtu.be/wsaMirkf3Pc

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
lascough20 112 on at

Like (0)

Report

Sorry, I know this is an old post but could be very useful. Maybe a silly question (as I am a novice), where is this formula entered?

Was this reply helpful? Yes No
peterdebue 2 on at

Like (0)

Report

Thanks, looks great. Where in the DatacardValue, when you create a new record, do you add the formula? Under 'Action', 'Data' or 'Design'?
Thanks for your support.

Was this reply helpful? Yes No