Power Platform Community Forum Thread Details

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:
C2=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))

C3=CONCATENATE(LEFT(B3,1),IF(COUNTIF($B$2:B3,B3)<10,"000",IF(COUNTIF($B$2:B3,B3)<100,"00","0"));COUNTIF($B$2:B3,B3)) and so on across the column C.

If I want to use it on my Sharepoint lists, I realize that Lists cannot use COUNTIF and the fields are operated on their own row. Any idea using Flow that will result exactly same as the Excel formula?

Thanks.

Categories:

General topics