cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Neil001
Regular Visitor

Using Power Automate to add together columns in a Sharepoint list

Hi all,

          I am trying to get a flow to add together the sum of multiple calculated column in sharepoint.  As I understand it I can use the ADD function to add together 2 columns only.  What is the best way to add together the numbers in multiple sharepoint calculated columns.

 

Any help appreciated

Neil

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Neil001 ,

 

Have a good day. As you said, we cannot use this expression: add(1,2,3). This function expects 2 parameters.

So please try the increment action.

vxiaochenmsft_0-1663643779086.png

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @Neil001 ,

 

Have a good day. As you said, we cannot use this expression: add(1,2,3). This function expects 2 parameters.

So please try the increment action.

vxiaochenmsft_0-1663643779086.png

 

Best Regards,

Wearsky

Neil001
Regular Visitor

Hi,

     Many thanks for coming back to me (apologise for delay in replying!).  So I can use that expression by initialising each variable and then using increment variable to add the initialise variable together?

 

Many Thanks

Neil

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,395)