I have 2 SharePoint Lists, Event Log (List A) and Event Participants (List B).
List A has an Event ID column (A1) and a column for the distinct count of Organizations which participated (A2).
List B is a list of participants with a Lookup Column (B1) that matches the Event ID (A1) in List A. The organization is denoted in column B2.
I want a distinct count of B2 from List B for each Event ID (B1). I then want a flow to automatically update List A, column A2 with that number, based on the Event ID (A1). In other words:
If A1=B1, then update A2 with the distinct count of column B2. Does that make sense?
So far, I have a flow built for a distinct count of B2 in list B based on instructions in this post, but the output is a distinct count of the entire list, and not by the Event IDs.

Report
All responses (
Answers (