cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Auto-generate number not beginning at 1

I need to convert a Nintex form to PowerApps intake form that has auto-generated job numbers. This is already in production. I just need to convert all over to PowerApps. I don't know where to start.

The auto generate part of the Nintex form includes a separate list and Nintex workflow but I was hoping to be able to keep most of the functions on the PowerApps form.

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Auto-generate number not beginning at 1

Hi @Anonymous 

 

In PowerApps, you could use the inbuilt ID property in SP list/library or have another list that maintains the latest job number

 

For the formcontrol - once the form is posted

on OnSuccess property use

Patch(DataSource, FormName.LastSubmit,{JobNumber:FormName.LastSubmit.ID })

This will update the job number field once the form is submitted 

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

You can 

 

View solution in original post

1 REPLY 1
Highlighted
Dual Super User
Dual Super User

Re: Auto-generate number not beginning at 1

Hi @Anonymous 

 

In PowerApps, you could use the inbuilt ID property in SP list/library or have another list that maintains the latest job number

 

For the formcontrol - once the form is posted

on OnSuccess property use

Patch(DataSource, FormName.LastSubmit,{JobNumber:FormName.LastSubmit.ID })

This will update the job number field once the form is submitted 

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

You can 

 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,162)