List collector and update records - multiple variables

[BrianS344076034]

Not sure where to put this, but figured I'd start here.

Here is the scenario

We are doing a project where the Help Desk will need to select a number of devices from a list and assign them to a site as they are refreshed.

Once they are selected, they can no longer be used for the project

One of the requirements is to update the name of the device from our current name to a value

We currently use the Serial number for the name of these particular devices

example - MXL603471J

In the flow I am able to rename part of it to the convention we want.

In this case there are 3 scenarios where this can be deployed and those 3 have a different naming, but close to the same

Example - Concession POS are named

LocationIDC5XX - XX is a number 1-?

I can auto set a flow to get the LocationID add the C5, but need to figure out how to add the next numerical value or a way to present it to the guys doing the work.

Ideally what I want to try and do is have a list collector, so they can select 5 devices at once, and then those automatically get named LocationIDC501 - C505, is this something anyone else has tried to do?

[Brad Bowman]

It seems like whether you always start at 01 in this flow, or need to use the next number after any existing similarly named records, what you would do first is lookup the records based on the partial name, sorted by name descending if that works for names ending in two digit numbers where one might be 0, and only return one record.  Now you have a record with the highest number so you can get the last two characters, convert it to a number, and increment.  If you're always starting at 01 in this flow that loops through the list collector values, then it should be easy enough to add a flow variable, use it in the loop, then increment it in the loop.