How to sum all values from List A based on a Unique Id and Email

[Anonymous]

Hi everyone,

I am trying to sum values based on Id and email. below is my share point view:

List name: customer

Rec ID	Email	Waves
LC-098	test1@outlook.com	2
LC-098	test1@outlook.com	0.152
LC-854	test2@outlook.com	1
LC-098	test2@outlook.com	1.25

Steps I am performing:

When button flow triggers, email and id are required as input

 When flow triggers it needs to filter email and id  in customer list and sum Waves column records.

For example:

LC-098  and test1@outlook.com triggers the output should be:

LC-098 = 2.152

Any help would be appreciated.

Regards

Ahmad

[happyume]

You can do it as below:

1 - Get Items with ODATA query with your user input

2 - Initialize variable with no value

3 - Loop through output array from Step 1 and increment variable from Step 2

4 - View your output

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[Paulie78]

Check out these two videos that I did:

https://youtu.be/3Y7looVeJxI

https://youtu.be/UcoaqmvTvCo

[ScottShearer]

@Anonymous 

I agree with the solution provided by @happyume but would like to add that the Get Items will return just 100 items by default.  If that is an issue for you, go to settings for the Get items action and turn on pagination.  Then set the threshold to no more than 5000 (higher if you have a premium license).

[Anonymous]

Thanks for your response. 

I have already tried this but Issue is, when trying this with multiple id with same email it all gets mixed up in increment variable.

Because if i connect this with share point trigger and if there are multiple ids and unique email

Thanks again.

[ScottShearer]

@Anonymous 

The solution proposed by @happyume should work for you.  Please post a screen shot of your Flow and be sure to include your filter query.

[Anonymous]

Here is the flow screen shot below:

I have use select action to fetch both ids with their waves.

next what i did is merge both ids and their data using Append to array variable > and use items(). Here is the output

here you can see i have merged both id with their data.

Output i am getting now:

[

  {

    "ID": 7,

    "Waves": 2

  },

  {

    "ID": 7,

    "Waves": 0.125

  },

  {

    "ID": 7,

    "Waves": 1

  },

  {

    "ID": 7,

    "Waves": null

  },

  {

    "ID": 7,

    "Waves": null

  },

  {

    "ID": 3,

    "Waves": null

  },

  {

    "ID": 3,

    "Waves": null

  },

  {

    "ID": 3,

    "Waves": null

  },

  {

    "ID": 3,

    "Waves": null

  }

]

Output I want:

{

     "ID": 7,

    "Waves": 2.152

},

{

    "ID": 3,

    "Waves": null

}

Thanks

[Paulie78]

This example should do it for you:

https://ibb.co/5F6c3Dt

Output is:

[
    {
        "ID": 7,
        "Waves": 3.125
    },
    {
        "ID": 3,
        "Waves": 0
    }
]

Your Output I want above didn't quite make sense to me, how did you end up with 2.152?

[pvlvsk123]

Hello. I have a table with several columns of values, and I need to sum up only one by the first column, the last name.
List A

Surmane	Data1	Data2	Data3
Surname1	1	2	3
Surname2	1	2	3
Surname1	1	2	3

I want to get the sum of the data and add it to another table.

Surname	Data1
Surname1	2
Surname2	1

List B

How can I do this? I will be grateful for your recommendations. I tried your method, but something doesn't work, tell me what to add in "Increment variable"? I know how to add to the new List B, but I don't understand how to write a request so that he misses the last name.