Oct 05 2022 06:39 AM
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?
Oct 05 2022 07:54 AM
@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
Oct 05 2022 08:45 AM
Oct 05 2022 08:47 AM
@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
Oct 05 2022 08:52 AM