web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Formula as Calcu...
Power Automate
Unanswered

Excel Formula as Calculated Value in Lists using Flow

(0) ShareShare
ReportReport
Posted on by

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

asdasd.PNG
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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 375 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 269 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 127 Most Valuable Professional

Last 30 days Overall leaderboard