I am trying to make a Purchase Order tracker and I need each additional entry to increment like AutoNumber does, but only incremented from the last one for that job.
So entries could progress as follows:
JOB01-0001
JOB01-0002
JOB02-0001
JOB01-0003
JOB02-0002
etc.
Is this possible or will I have to go through and create an entirely new entity for each job code?
Hi jwparen2,
Thanks for reaching out with the issue. I believe you may be able to use something like this to achieve the auto increment functionality -
OnStart on the screen, you may use - Set( MyVar, <someValue> )
And on each addition of the row, you may - Set( MyVar, MyVar + 1 ); Set( JobId, “Job01-”+ MyVar )
Here is a link for some more reference -
https://docs.microsoft.com/en-us/powerapps/working-with-variables
Let me know if that does not help.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
187 | |
77 | |
49 | |
37 |
User | Count |
---|---|
318 | |
262 | |
122 | |
73 | |
60 |