How to generate auto generate PO number based on last item ID .

C# Corner

Rajkiran Swain

3y1.1kPower Apps

How to generate auto generate PO number based on last item ID in PowerApps.

Example : PO 001 , PO002 etc.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Hussain3y ago

Accepted answer

Set(
    LastPONumber,
    Last(
        Sort(
            'PO Details',
            ID,
            SortOrder.Ascending
        )
    )
);
Set(
    NewPONumber,
    "PO" & Text(
        Value(LastPONumber.ID) + 1,
        "[$-en-US]00"
    )
);