Answered

Autogenerate next PO number

(0) Share

Report

Posted on by astrontelstar

287

I have a PO field in my dataverse database simply called PO. I chose it as a text field so that I could theoretically modify it to fit my company's needs. Currently my format is "YEARNumber"; Ex.. "2021403" for the year 2021 and the 403rd PO.

The next would logically be "2021404".

When I add a record, I'd like to have a function or way to Autopopulate "2021405".

I want the system to look through my database, figure out that the last PO was 2021404 and give me "2021405" as a text field.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @astrontelstar you can lookup the max valuie and add to it.

consider the collection from the table being colSomething and the PO column called val. the wfirst part in the With statement get the maximum number an dthen adds one to it while the collect add it to your table.

With( { _max: Max( colSomething, val ) + 1 }, Collect( colSomething, {val: Text(_max)} ) )

hope this helps

R

Was this reply helpful? Yes No
astrontelstar 287 on at

Like
a
(0)

Report
Copy link

Link copied!

When I run this - Max('Mprinted Business Operations',Value(PO)) I get "20200358" which is a PO from last year and not the most current which is 2020408. My guess is it has something to do with delegation maybe? Any more ideas?

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@astrontelstar

Max() is not delegatable. Instead, use First(Sort(... , Descending) +1 to get the next number in the series. First() isn't delegatable either but it doesn't matter because Sort() is.

Was this reply helpful? Yes No