cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
riteshbti
Frequent Visitor

GroupBy in Excel using Power Automate

Hi All,

I have an excel with 2 columns.

Candidate (values repetitive)

Count (values repetitive)

Need to uniquely identify Candidates and add their respective count values in next column.

For ex. Candidate 1 is having 1,2,3 as count vales and Candidate 2 is having 5,6,7 values then output I need a table having First Candidate and total his count should be 6 (1+2+3) as well as second candidate data should be 18 (5+6+7).

I have explained below as well:

 

Input table in excel

 

CandidateCount
13
222
234
12
34
17

 

Output

 

CandidateCount
112
256
34

Please help in Power Automate flow.

Thanks in advance.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
edgonzales
Super User
Super User

Hi there.  Check out this article, Group By and Sum in Power Automate / Flow.  It might be enough to get you started.

Keep us posted.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

1 REPLY 1
edgonzales
Super User
Super User

Hi there.  Check out this article, Group By and Sum in Power Automate / Flow.  It might be enough to get you started.

Keep us posted.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,421)