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 · Accepted solution]

@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
	}
)

[CNT · Accepted solution]

@knsrinath Did it work?

[knsrinath]

Yes, Its Working

Thanks Lot....

[CNT · Accepted solution]

@knsrinath Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.