Sum numbers stored as text in a sharepoint List

(0) Share

Report

Posted on by garzamalanUS

People, I'm not new, but still consider myself as beginner here.

I have a SharePoint List, which its storing $ totals but in a text column.

I need to sum that column to be able to send the total in an email.

I know how to get Items and filter the SP list, I know how to send the email, but I don't know and can't seem to figure out how to first convert the column into numbers and then sum it (the filtered array of course).

any ideas?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Manish Solanki 15,097 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @garzamalanUS

To improve execution time of 'apply to each' action, pls use the concurrency property of it. To enable & configure it, please perform the following steps:
1. Firstly, click on ellipses (...) and select 'settings' from the menu:

2. Next, click on toggle button to enable currency control setting:

3. The default value for Degree of Parallelism is set as 20. Here I have set its value to 40 but you may modify as per your need:

click 'Done' to save the setting.

You will see some improvement in the execution time.

Please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
garzamalanUS 30 on at

Like (0)

Report
Copy link

Link copied!

I figure it out. Since it has a "." (dot), it doesn't recognize it as integer (duh!), I needed to use Float, and change the initialize variable type to Float also. So basically, your solution worked but I wasn't specific enough.

Question, it takes about 30 seconds tu sum 60 records, any other solution that might take less time?

Was this reply helpful? Yes No
garzamalanUS 30 on at

Like (0)

Report
Copy link

Link copied!

It gives the following error
Unable to process template language expressions in action 'Increment_variable' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

My formula is
int(items('Apply_to_each')?['Amount'])

This is a screenshot of my SPList column

And even the column shows the name Charge, in the backend is Amount

Was this reply helpful? Yes No
Manish Solanki 15,097 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @garzamalanUS

You can refer the below screenshot of actions to sum the SharePoint column, here Column2 is the field whose total is to be calculated:

Pls let me know if you face any problem & remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No