calculate sum totals from multiple lists in the same site

Copper Contributor

I have a SharePoint site with multiple lists (One for each month of the year)

In each list there are 5 columns

 

Petty Cash

Vouchers

Invoices

BACS

Bus Passes

 

All these have a SUM total

 

Is there a way of having another page in the same site that calculates the sum totals for each column?

4 Replies

@LukeSykes the simplest way to do this is to have a flow in Power Automate that, on a set recurrence schedule (for example twice a day at 10am and 4pm), get the items from your first list, Petty Cash for example. For each item in the list it adds up the number/currency amount and adds it to a variable.  You'd need to have parallel branches for each of the other lists and and a variable for each of vouchers, invoices etc. You would then have an action that creates a new item in your "overall sum" list using the values from each of the variables.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thank you - but i have no idea how i would achieve this.

I do use power automate but i don't know where i would start with this

@LukeSykes OK I'll post up some screenshots as soon as possible that you can hopefully follow.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Wonderful - thank you