Count occurrence of items in a SharePoint list

[englcc]

I have a SharePoint list with more than 1500 rows and I would like to count the occurrence of the same item. May I know how to do it? 

There are some additional requirements for this case,

I would like to count the number of events responsible for each person, however, when event no. is started with BA, we look at the "Person A" column, when event no. started with OL, we look at "Person B".

This means for the following table:

Event No.	Person A	Person B
BA202	Alex	Boris
BA203	Boris	Catherine
OL503	Catherine	Alex

The result will be

Alex: 2

Boris: 1

Catherine: 0

I have considered using Get Items, but because I have too many rows and distinct values (Person name), I would like to avoid using that.

Anyone with a solution will be really appreciated!! Thank you everyone!!

@v-litu-msft

@Paulie78 

[AbdulWahab]

Hi englcc,

The easiest way to fulfil your requirement.

1. Approach #1
   1. Use something similar to the list row component. Add something similar to Fetch XML to retrieve distinct records. (Appy to distinct to that column on the basis you can detect duplication)
   2. List row again and add a filter of items. This list row gives you the count
   3. Use it in your logic to process further.
2. Approach # 2:
   1. In first use components similar to list row
   2. Use something similar to Fetch XML
   3. Use group by in your fetch XML.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a

[englcc]

Hi AbdulWahab,

Thank you for your reply! Could you provide me with more detail on approach 2? I am exploring the possibility of using XML as well, but I couldn't use list row because I do not have a premium account.