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|
The result will be
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!!
The easiest way to fulfil your requirement.
Let me know if I can provide you with more details.
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
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.