web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sharepoint List Form t...

Power Apps

Answered

Sharepoint List Form to create sequence number

(0) Share

Report

Report

Posted on by momax

49

Hi All Expert User,
I want to create a sequence number for Form ID. And after the user submit the form ID lock.

List 1 is Form ID: Example TPFD0001 stating for list ID.1

List 2 is Another Form ID: Example EXFD0001 stating for list ID.1

Main List: The user select the dropdown value company is "Exval" in main list reference number ID: EXFD0002 after user submits the form.

May i know the idea or code to create this Form ID.

Best Regards,
Momax

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @momax ,

Using your list, field and control names below, it would be something like this

With( { wPre: Switch( YourDDName.Selected.Value, "Exval", "EXFD", "Tpfval", "TPFD", "OtherValuesFromHere . . . ." ) }, With( { wLast: LookUp( Sort( ListName, ID, Descending ), StartsWith( YourRefFieldName, wPre ) ).YourRefFieldName }, wPre & Text( Value( Substitute( wLast, wPre, "" ) ) + 1 ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation