question

ALBANAMuhammadIrfan-8392 avatar image
0 Votes"
ALBANAMuhammadIrfan-8392 asked ALBANAMuhammadIrfan-8392 commented

Calculated Value Sharepoint Lists from Excel Formula

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

101576-asdasd.png

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.



office-sharepoint-onlinesharepoint-devsharepoint-workflow
asdasd.png (5.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered ALBANAMuhammadIrfan-8392 commented

@ALBANAMuhammadIrfan-8392

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the answer, I am looking forward to ask power automate expert.

0 Votes 0 ·