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.
Solved! Go to 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
}
)
@knsrinath Glad to help!
Please remember to give a 👍 and accept the solution as it will help others in the future.
@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.
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.
Patch(mySPList, Defaults(mySPList),
{myID=LastN(SortByColumns(mySPList, "myID", Ascending)).myID + 1
// add all the other fields you want to patch
}
)
Hope this helps!
Thanks for your Mail
I have few errors. Please find attachments...
Use myID: instead of myID=
@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!
Thanks for your reply
Error found
Invalid argument type. Expecting one of the following: Number, Text, Boolean.
Thanks & Regards
User | Count |
---|---|
253 | |
113 | |
92 | |
48 | |
38 |