Unique Serial Number

[knsrinath]

Hi

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.

[CNT]

@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.

[knsrinath]

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.

[CNT]

@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!

[knsrinath]

Thanks for your Mail

I have few errors. Please find attachments...

[zmorek]

Use myID: instead of myID=

[CNT]

@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!

[knsrinath]

@CNT

Thanks for your reply

Error found

Invalid argument type. Expecting one of the following: Number, Text, Boolean.

Thanks & Regards