Automatic List Numbering with Conditions

[AlexanderWilson]

Hi all,

My query is regarding generating a list entry from a Form response, with a few conditions for what is filled within the fields.

To put it into words a form is to be filled with mandatory information, as shown below:

When this form is completed, flow automatically fills in a list with the responses; however there are some conditions that are involved in this process.

The list has an additional column, named ‘ID Number’, as seen below:

This identification number is used internally to identify incoming responses.

The conditioning is as follows:

When a new response is completed, the previous ID Number in the list is checked, and the new form item added is with an ID Number that is one value higher than the previous, I am unable to use the form response ID as this value due to the condition that will be detailed further on, in addition due the value will be starting at around 400, as there are already 400 paper copies of this response form, and the process needs to sequentially continue from this already existing value. In addition this ID Number will form part of the title.

The condition is that the column ‘Part Code’ is also to be checked, and if an existing value has already been entered into the list, then the given ID Number should match that of the existing entry.

If the following responses already exist:

And a new response is completed with the following information:

Full Name: Jane Brown

Part Code: PRT006

Details: 2mm Long

Then an entry to the list will be added with the ID Number ‘406’, and this number will also be in the title.

However, if a new response is completed with the following information:

Full Name: Jane Brown

Part Code: PRT085

Details: 5mm Screw.

Then as the Part Code matches that of ID Number ‘402’, then this entry to the list should also be given the ID Number ‘402’, and the title would be something along the lines of ‘Response – 402 (2)’

Above shows how far I have gotten with the process, I can’t figure out how to get further than this though.

Any help is much appreciated.

[AlexanderWilson · Accepted solution]

After some playing around I have managed to figure out part of the conditioning side if the Part Code matches, I've attached my flow below:

However, additional files are being created in the list now, I think this is because it repeats the condition 3 more times, for the remaining existing items in the list.