Unanswered

Autogenerate Case Number

(0) Share

Report

Posted on by Sohaibmohammad

I have chosen a work progess tracker template & I have added a new column as Case number and I need to autogenerate the case number in SharePoint list the number for example starting is20540 next when a new item is created the number should be 20541 and so on. It should work in SharePoint list and also power apps .can you please suggest me a solution

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Sohaibmohammad ,

I can't figure it out how you create a new record in your Sharepoint list. So let me guess..

1. Using a form:

Set the Update property of the Case_DataCard to (I suppose that case column is a number type):

Value(Last(yourSharepointList).Case)+1

2. Using Patch() function:

Patch(yourSharepointList, Defaults(yourSharepointList), { ..... Case: Value(Last(yourSharepointList).Case)+1 ..... } )

where .... means the other values to patch.

Was this reply helpful? Yes No
Sohaibmohammad 32 on at

Like
a
(0)

Report
Copy link

Link copied!

I need this to add in power apps

Was this reply helpful? Yes No
Sohaibmohammad 32 on at

Like
a
(0)

Report
Copy link

Link copied!

I ahve attached sharepoint list and formula to generate the autonumber but when I clik the button the number is not showing can you pleasse help me

Was this reply helpful? Yes No