Good day Jan,

Is this list in a collection?  Are you saying that you are currently getting your unique list from List A? 

For you count operation you could use the Collection operation with the count option to get a count value on list A.

For list B, I will use a For each action looping through List B 1 by 1 with a For each inside  looping through list A 1 by 1 and inside the second For each I will put a run-if to check whether or not the value is in there.  You will have to set a flag = False and step through all the records at the end outside of the inside for each loop have a another test.  If the flag is still false then add the record. Here is an example. Sorry for the colors, its purely for readability.

Kind Regards,

Thank you for the reponse!

I can't seem to select a (sharepoint) list as the base for a "for each" action - I can only do that on collections.

My lists are both sharepoint lists, list A is an application registry mapping an application to an individual and containing flags for filtering the list into certain "application groups".

The second list(a sharepoint list) are the "distinct" set of users (i.e. no duplicates), and a count of how many apps they have each.

Hi Jan,

Is list B (the set of unique users and application counts) being used for anything else, or is it just used to track the number of applications for each unique user?  There might be a simpler approach to this, but I wanted to make sure I understood the intended use case first.

Thanks!

Brian

Morning Jan,

You can not work in a for each with the list.  You first have to use the Query list action and save the values to a collection.  After that you can use the collection in a for each loop.  I usually just read the list ID into the collection

So that will be a step before the For each. Create a collection, i.e. colListA and colListB.  Then the first step inside the for each loop I use a query list again but this time I create the variables for the list columns that I want, i.e. currentName, currentUSerID, currentAppcount, etc. and these with be specific to the current current List ID in the For each action.

To perform the count you can add a math operation inside the inner For Each loop that counts the instances and then add it to the existing user current app count. 

That is just some information on the collection vs list for a for each.  Let  me know if I need to explain this further.  And also please answer Brian for some further clarification.

Thanks

Thank you for these clarifications.

My second list is used to drive task creation on person by person level, so that each person don't receive one notification for each application they are responsible for.

I.e. I have a new set of workflows for that list, the key is that out of a set of people (with many duplicates) I get a distinct list where each name only appears once...

// Jan