Comapre two sharepoint lists

(0) Share

Report

Posted on by Sifu

834

Hi all,

i have two SharePoint lists

A - where users submit data (contains also month, approval status etc...)

B - list of all users (contains also a column if user is required to submit to list A)

Now i want a flow that will look at list B, get all users that should submit to A and send them an email... I know how to query a list do a filter, but i have no idea how compare them... i always get only those that already submitted (but i need those that have not).

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

leyburn19 2,157 on at

Like (0)

Report

Get items - List A

Apply to Each

Get Items List Person in list B equals person in List A

Compose - Count of Result

Condition if result = 0

Yes = Send email to person found in List B

Was this reply helpful? Yes No
Sifu 834 on at

Like (0)

Report

@leyburn19 thanks for the info, but i guess am missing something...

Get items - List A - ok
Apply to Each - ok
Get Items List Person in list B equals person in List A - do you mean to use filter query and compare the two lists between each other? if so it should return me only those results from list B, that match list A, which is not what i need, i need those who are in B, but not in A
Compose - Count of Result
Condition if result = 0
Yes = Send email to person found in List B

what i did so far:

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report

That's exactly what this does. I assume that your list B has exact match in LIst A. So the process takes your List BO and goes through List A. If the List B does not match List A it will return 0 result.

The moment you do your filter in the Get Items of List B, it will put it in an apply to each.

the output would condition would be equal 0 not null. Also I cannot see the apply to each is based on. can you show an image of your filter please

Was this reply helpful? Yes No
Sifu 834 on at

Like (0)

Report

@leyburn19 thanks for reply, still no clear how to achieve this, see screenshots below

Was this reply helpful? Yes No