For this scenario, you don't need the extra calc column. You can just get the previous Title value and add 1 to it.
For this example, I'm using the following list.
You don't need to do the next step, but it will allow you to not have to enter a value for the Title (required field) of the new item each time. I've set the default value for Title to "Pending". To do this, go into the List settings, click on the Title field, and set the default value.
See full flow below. I'll go into each of the actions.
When an item is created is your trigger that you already have.
Get items retrieves items from the list. It has a filter to exclude the current item, sorts by Title in descending order, and is set to only return a single item. The item returned will contain the Title that we want to add 1 to for our new item.
Update item updates the item's Title using the ID from the Trigger and uses the following expression to add 1 to the previous Title.
//Convert the Title to an integer and add 1 to it.
add(int(first(outputs('Get_items')?['body/value'])?['Title']), 1)
If you wanted to add some styling to your list while it's still generating the new Title, you can add some Column formatting as shown below. Note that this assumes you set the default value for Title to "Pending".
While the new Title is being generated.
After the new Title has been generated.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
