Power Platform Community Forum Thread Details

Hi Users,

I am trying to build a flow where it should calculate the sum of each individual of each leave type.

Enterprise ID	Leave Type	No. of Days
ABC@XYZ.com	Half Day	1
GYT@XYZ.com	Casual Leave	1
ABC@XYZ.com	Sick Leave	1
ABC@XYZ.com	Compensatory Off	1
ABC@XYZ.com	Casual Leave	2
ABC@XYZ.com	Casual Leave	1
ABC@XYZ.com	Planned Leave	1
ABC@XYZ.com	Sick Leave	1
ABC@XYZ.com	Half Day	1
GYT@XYZ.com	Casual Leave	1
ABC@XYZ.com	Sick Leave	1
ABC@XYZ.com	Compensatory Off	1
GYT@XYZ.com	Casual Leave	2
ABC@XYZ.com	Casual Leave	1
ABC@XYZ.com	Planned Leave	1
GYT@XYZ.com	Sick Leave	1

I would like to get ABC@XYZ.com 1. casual Leave Sum 2. Sick leave Sum
Similarly, GYT@XYZ.com 1. casual Leave Sum 2. Sick leave Sum

Please help.

Thank you.

Categories:

Building flows