SharePoint aggregate Sum to Another List.

(0) Share

Report

Posted on by TarunaM

Hello All,

I have created a flow it is doing one part of the job I am stuck in the second part for the flow.

I have a SP list (A) WP Table with work packages (WP) for projects and every project can have 4-10 WP's.

I have a SP List (B) Project Summary Table which Has Project Number and Project Cost & Project Spent columns.

The flow sums the project cost for the Project Number in List A but when in the flow I update the List B the Total Sum of the Project Cost is applied to all project numbers.

It should look like the description in the example below.

List A List A

Project ID WP Number WP Title Budget Project ID Total Cost Total Spent

1111 80000 Admin $5,000 1111 $100,000

1111 90000 Mgmt. $15,000 2222 $96,000

1111 70000 Supplier $50.000

1111 60000 Cont. $25,000

2222 80000 Admin $1000

2222 90000 Mgmt. $25,000

2222 70000 Supplier $75.000

Please let me know what step I am doing incorrect.

Thanks

Taruna

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TarunaM

The last "Apply to each" action is not appropriate that contains "Get items 2" and "Update item" actions. Instead, first use the "Get items" action for List B and use filter query to get the record based on project ID (same way as you did in Get items for List A). After that add a new "Apply to each" action, get the result value obtained from List B and add update item action inside it to save the total value in the record present in List B.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
TarunaM 51 on at

Like (0)

Report
Copy link

Link copied!

Hello Manish,
I did update as mentioned, but still the same.
Instead, first use the "Get items" action for List B and use filter query to get the record based on project ID
After that add a new "Apply to each" action, get the result value obtained from List B and add update item action inside it to save the total value in the record present in List B.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TarunaM

I would request you to double check if ID in Update item action comes from 'Get items 2' action.

If this solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Verified answer

TarunaM 51 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,
Yes, ID in Update item action comes from 'Get items 2' action. The image below shows that, I left that on purpose.

Thanks
Taruna

Was this reply helpful? Yes No
TarunaM 51 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,
Apologies for late response, it worked I was caught up with other stuff could not respond earlier.

Thanks
Taruna

Was this reply helpful? Yes No