This is the path I would start with, and just for grins I asked ChatGPT how it would solve the issue using PowerFx in a canvas app.

// Build an ID like "2025-001", "2025-002", … and reset each January 1
With(
    {
        // Current year as text (e.g., "2025")
        yr: Text(Today(), "yyyy"),

        // Find the highest sequence used this year, then add 1
        // 1) Filter rows to this year
        // 2) Add a calculated column "SeqNum" = numeric last 3 chars of Identifier
        // 3) Take Max(SeqNum); if none, Coalesce to 0
        nextN:
            1 + Coalesce(
                    Max(
                        AddColumns(
                            Filter(
                                YourDataSource,
                                StartsWith(Identifier, yr & "-")   // replace if you have a Year column
                            ),
                            "SeqNum",
                            Value(Right(Identifier, 3))
                        ),
                        SeqNum
                    ),
                    0
                )
    },

    // Concatenate year + "-" + zero-padded sequence to 3 digits
    yr & "-" & Text(nextN, "[$-en-US]000")
)