Auto Increment Sharepoint starting at 1

[TEmmerton]

Afternoon,

Hopefully I am asking this in the right location.

I am trying to automate a number incrementing system in sharepoint with flows and not having much luck.  It needs to be based on 2 columns.  The type Column is a dropdown.  If set to internal, it needs to give the next plan number (1, 2, 3, etc).  If set to external it needs to give a unique number from a excel table that can only be used once.  The excel table currently has 2 columns, one with the unique numbers and the other with a dropdown that says used or available.

Example

Job Number	Type	Plan Number
111	Internal	1
111	Internal	2
111	External	EX1
222	Internal	1
222	Internal	2
333	Internal	1
333	External	EX2
333	Internal	2

Hopefully someone is able to help with my issue

Cheers

[annajhaveri]

@TEmmerton when you want to set the this number, when new item is created?

[TEmmerton]

Yes it will be when creating a new item

[annajhaveri]

@TEmmerton  you can create a flow with trigger when new item is created, then using condition action check if the type is Internal, then add Get Items under yes branch of condition action, with filter query to get matching row with Type eq Internal and set order by with Plan Number desc and set Top count to 1, this will give you the highest Plan number from the list and you can add 1 to it and set the incremented value in the current item using Update item action. In the no branch of condition action, you can use List Rows action with filter query to get matching item from the excel file to get the unique number and then again use Update Item action to update the unique number in the current item.  

[TEmmerton]

Unfortunately I couldn't get that to work.  Sorry if I have missed something from your explaination.  I am very new to Sharepoint and flows.

This is a snapshot the actual sharepoint list.  The Project number needs to get a plan number starting at 1 when set to internal. So each new Project Number starts back at 1.  I figure it might need a different flow for each item in the Plan type column.

I didn't do the no side from your original guide as there are 3 items in the drop down.