Power Platform Community Forum Thread Details

Hi everyone,

I have 2 lists in SharePoint Online and a PowerApps app.

List 1: collects the data that's submitted by end users from PowerApps form. It has many columns, 3 of them are:

>> (Department name >> choice column with around 30 departments) and

>> (Status >> choice column as well with values like approved, rejected, canceled) and

>> (No Show >> single line of text and by using patch function from PowerApps it will contain whether true or false)

List 2: Is a secondary list that has a column called department which contains the same values as the one in List 1. It also has many Number columns like Total requests, total approved requests, total rejected requests, total no show, etc..

I am trying to build a flow that collects the total requests, total approved requests, total rejected requests, total no show for each department in List 1 and save them in List 2 under the same department name.

I was able to do it from PowerApps by using Sum(ForAll(Filter(.... and then patch the values in List 2 but, due to high volume of requests which reaches to +3000 per month that didn't work efficiently. I tried below solution, but I couldn't get it work for my scenario.

SharePoint list and calculating sums with flow - Forward Forever https://community.powerplatform.com/forums/thread/details/?threadid=a3e5e6c6-b994-4448-9185-bef896f7ce1f

Can anyone me help out?