Sharepoint List numbering occurence

Question

Hello,

I'm looking for a way to create a calculated column in Sharepoint List as below. I already have the "ID" column and I'm looking to create the "Occurence" numbering when the ID happens (not counting them, but numbering as they happen). Any thought on how would the formula be?

Answer 1

This requirement is not achievable using calculated column since the formula does not go through list items vertically, it only uses the column values on the current item.

As a workaround, you can build a flow and use REST to get the number of existing items with the same column value ( ID in this scenario), and then update the current item.
Please see the sample flow:

Test result:

Reference: Get to know the SharePoint REST service. / Send An HTTP Request To SharePoint In Power Automate (MS FLOW).

*Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. *

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **