cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Automatic List Numbering with Conditions

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:

Form.png

 

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:

Empty List.png

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:

Filled List.png

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)’

 

Flow.png

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Automatic List Numbering with Conditions

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:

 

IF Flow.png

 

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.

 

IF Flow List.PNG

 

 

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Automatic List Numbering with Conditions

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:

 

IF Flow.png

 

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.

 

IF Flow List.PNG

 

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,695)