Calculated Value Sharepoint Lists from Excel Formula

Question

I have a formula in Excel that I want to use as calculated value in sharepoint lists.
The cell in Excel is shown below

It is simply adding 5 characters ID (use first letter of category, zeros, and not repeated count) with formula:
=CONCATENATE(LEFT(B2;1);IF(COUNTIF($B$2:B2;B2)<10;"000";IF(COUNTIF($B$2:B2;B2)<100;"00";"0"));COUNTIF($B$2:B2;B2))

If I want to use it on my Sharepoint lists, is it possible to use range in COUNTIF formula? Or any idea using Flow that will result exactly same as the Excel formula?

Thanks.

Answer 1

@AL BANA, Muhammad Irfan ，

In SharePoint calculated column, there is no COUNTIF function, and calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.

For formula conversion using flow, you can post your question in the Microsoft Power Automate Community. The experts there are willing to provide decent help for your issues.

---

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.