Update List A with a distinct count of a specific column in List B, based on matching columns in List A & List B

(0) Share

Report

Posted on by KWhite

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.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @KWhite,

You could use the filter query to find out these items in List B that B1 ID equals to A1, for example:

B1 eq 'dynamic content A1'

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No