Unanswered

Power automate sequential numbering

(0) Share

Report

Posted on by 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.

Categories:

Power Automate Desktop

All responses (4)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Wizby01

the flow seems to be look as working, but hve you checked whether the record is created in dataverse table ?
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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 20 on at

Like
a
(1)

Report
Copy link

Link copied!

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
Linn Zaw Win 2,996 on at

Like
a
(0)

Report
Copy link

Link copied!

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