Auto Numbering

Hi all,

I'm creating a list for RCCA items and NCRs and need to have a column titled "NCR Number" to auto populate with a unique number based on the manufacturing plant selected. I've created a simple flow that does this using the ID that's already being created in the background, but it's not exactly what I need.

We already have an NCR library for both of our manufacturing plants in the form of excel lists and word documents, and the numbering system is unique for each plant (i.e. MN859 and MA732, where 'MN' and 'MA' are the prefixes for our plants). Is there a way to do this in one list on a Sharepoint site and continue the current numerical values?