Unique Serial Number

(0) Share

Report

Posted on by knsrinath

527

I have 4 Screens in PowerApps Canvas.

Each screen is using for different Data Entry and all 4 Screens data is Patching to one SharePoint List.

Screen 1 – Single Row entry in SharePoint – Screen Name - "ABCD"

Screen 2 – Gallery Multiple row entry in SharePoint - Screen Name - "EFGH"

Screen 3 – Single Row entry in SharePoint Screen Name - "KLMN"

Screen 4 – Gallery Multiple row entry in SharePoint Screen Name - "QRST"

After entering the data in PowerApps I want Generate unique ID in SharePoint List as follows

ABCD00001

ABCD00002

EFGH00003

EFGH00004

KLMN00005

QRST00006

ABCD00007

EFGH00008

I have tried with default ID Column and Flow. It is working. By default I can not reset ID to 1.

Request you suggest any alternate method.

Your quick response will be highly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (3)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@knsrinath Meddling with the default ID column in not ideal. It is good to have your own column for this custom ID so that you can have full control over the Start number, the Prefix etc., This will keep thing simple and fully under your control.

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please help me to create Serial number in one column 1,2,3,4,5....... once data created in SharePoint from power apps.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@knsrinath
First you have to create a column say, myID of type Number.
Then use this formula to create a new record with the myID and other fields as per your requirement.
Patch(mySPList, Defaults(mySPList), {myID=LastN(SortByColumns(mySPList, "myID", Ascending)).myID + 1 // add all the other fields you want to patch } )

Hope this helps!

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your Mail
I have few errors. Please find attachments...

Was this reply helpful? Yes No
zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Use myID: instead of myID=

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@knsrinath Replace = with : in the formula
Patch(mySPList, Defaults(mySPList), {myID:LastN(SortByColumns(mySPList, "myID", Ascending)).myID + 1 // add all the other fields you want to patch } )

Please @mention me to gab my attention. Hope this fixes your issue!

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT
Thanks for your reply
Error found
Invalid argument type. Expecting one of the following: Number, Text, Boolean.

Thanks & Regards

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@knsrinath Sorry, It's not LastN but Last
Patch(mySPList, Defaults(mySPList), {myID:Last(SortByColumns(mySPList, "myID", Ascending)).myID + 1 // add all the other fields you want to patch } )

Was this reply helpful? Yes No