cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Field update on screen load with incremental number "Transaction ID"

I have a PA form there is a field "Transaction ID". Currently this field is manual input once the user clicks the submit button it populates an SP list  Inventory,"Transaction_ID" along with a number of other fields. This transaction_id will be the same for around 30 rows as the user inputs the inventory using the APP. 

 

What I have been failing to figure out Is how to have power apps populate the "Transaction_id" Field on the form with a +1 increment of the last transaction ID entered in the list increment starting at 100 . I would prefer the to happen on screen initialization. The ID will only exist in the field until the user clicks submit then is updated to the SP list.  The user may need to change the auto generated "Transaction_id" to a previous ID at some time.

 

Any foot hold to jump from or advice would be appreciate I have found forums and content that appears similar but did not really apply well.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Follow this video from Shane Young:
https://youtu.be/plKw_xfVfwY

Auto increment ID

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

2 REPLIES 2
Super User III
Super User III

Follow this video from Shane Young:
https://youtu.be/plKw_xfVfwY

Auto increment ID

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Thank,

I'm not sure how i missed that one i have watch quite a few of his videos. This works up to the point of populating the field. I can see in the expression that it is pulling the correct info but it will not fill it into the field. 

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (63,907)