Power automate sequential numbering

[Wizby01]

Hi all

I have a flow that creates a new record. These records have a sequential four digit numbering system. I need to find the last number and then add one. 

I have set a flow that does this well once but after that it does not add to any of the new records, and when I look in the list rows the new number is not there. 

The column I am trying to add the sequential number to is called softsys_name display name is "Call Number"

I was wondering if it was a test number issue but I am stumped. 

Map = int(item()?['softsys_name'])

(Get Max ID) Inputs = max(body('Select'))

(New ID) Inputs = add(outputs('Get_Max_ID'),1)

Any advice would be appreciated.

[Nived_Nambiar]

Hi @Wizby01 

the flow seems to be look as working, but hve you checked whether the record is created in dataverse table ?

[Agnius]

Please note this forum is for desktop flows and your question is related to a cloud flow. The correct forum to post questions like that is here: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows

For what it's worth, it seems like your flow is triggered by an email and then creates a single entry. Are you sure your flow actually runs more than once? Can you open a flow run that has actually ran and did create an entry, but did not add the number?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[Wizby01]

Sorry for not putting in the correct spot. Your answers pointed me in the right directions. The list rows was not working as i needed to set the Pagination to 100,000 rows and then it listed all entries. Thanks

[LinnZawWin]

@Wizby01 

Retrieving all the rows in your table would impact the performance of your flow. Over time, your table grows and your solution would stop working when the number of rows exceeds 100,000.

I recommend sorting the List Rows action and adding "Row Count = 1" to get the latest one (something similar to this)