Unanswered

Creating a Serial Number based of +1 from the last record

(0) Share

Report

Posted on by Mike17

Hi,

Creating a form from an existing Excel Spread Sheet. I want to give each report a specific serial number. +1 to which ever the last report was.

Under Default on the DataCardValue I have put:

If(EditForm1.Mode-FormMode.New, Last(Table1). Serial+1. Serial)

But it just comes up with a red cross. Am I entering it into the wrong field or just have the wrong formula.

🙂

Mike

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Mike17

Coalesce(Parent.Default, First(Sort(Table1, Serial, Descending)).Serial+1) as the Default property of the control in the card.

Coalesce submits the first nonblank value and in the case of a New Form, the Parent.Default will be blank. Last() and Max() are not delegatable so they will become incorrect once your list exceeds 500 (default) or 2000 (maximum) items. If there is already a serial number, then Parent.Default will be nonblank and will be the value in the control. Hide or disable the card so users cannot change the result.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

If(EditForm1.Mode = FormMode.New, First(Sort(Table1, Serial, Descending)).Serial + 1)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Mike17 7 on at

Like (0)

Report

@Drrickryp
Thanks for getting back so quickly. I just did that (PSB) but the red cross is still there. Have I put it in the correct field? Should it be DataCardValue1 or Threat Serial_DataCard1?

Mike

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Mike17

You can put it in the default of the control or as the Update property of the card. The data type in SharePoint should be a number.

Was this reply helpful? Yes No
Mike17 7 on at

Like (0)

Report

@Nogueira1306
Thank you. I tried that and got this:

Any thoughts? Mike

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

If(EditForm1.Mode = FormMode.New, First(Sort(Table1, 'Threat Serial', Descending)).'Threat Serial' + 1)

Please check the names of the fields..

Was this reply helpful? Yes No