We then want to update the Increment list with the new NextValue. The Id is selected from the dynamic content and make sure you select the ID in the When an item is created section: So the outputs of that Compose are added to the Increment column. We now want to update our main list with the value in the Compose control we created above. Click on Add Trigger and set the following values to the corresponding fields. We then add a Compose control and the input for this is the NextValue from Get items from the Increment list: To implement triggers for auto-increment, log into your MongoDB Atlas account, open the cluster you want to work on.

We add an apply to each control and select value from the dynamic content box. The first action is to get the items (there's only 1) from the Increment list: The trigger in our flow is a SharePoint 'When a new item is created'. We also have a list called Increment which holds the next value 972: In this example we have our main list,CropHarvest, where the current highest incremental value is 971 which means that when we create a new item we want the next one to be 972: Assuming you are not using the ID column in your SharePoint list for this then it can be achieved quite easily but needs a separate list to hold the next incremental value.

Pug template increment counter