Unanswered

Compare two SharePoint Lists with a criteria

(0) Share

Report

Posted on by JonathanJ

Hi,

I would like to know how do I compare two list in sharepoint but only with the criteria of status = done, and if in alpha list theres a item with the status value of "Done", that is not in the beta list, send a email.

for example in this case alpha table has ID 2,3,and 6 with "done" status value, but beta table has ID 2, and 3. This menas that i should receive a email that tells me that beta list do not have ID 6 with status value of done.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

Chriddle

8,729 Super User 2026 Season 2 on at

Like (0)

Report

Copy link

Link copied!

Select:

From: @{outputs('Alpha')}

Map:

ID	item()['ID']
StatusAlpha	item()['Status']
StatusBeta	coalesce( first( xpath( xml(json(concat('{"root":{"item":', outputs('Beta'),'}}'))), concat( '//item[ID="', item()['ID'], '"]/Status/text()' ) ) ), '' )

Filter array:

From: @body('Select')

Filter:

@And(
	equals(item()['StatusAlpha'], 'Done'),
	not(equals(item()['StatusBeta'], 'Done'))
)

Output:

[
 {
 "ID": "6",
 "StatusAlpha": "Done",
 "StatusBeta": ""
 }
]

JonathanJ 6 on at

Like
a
(0)

Report
Copy link

Link copied!

how do i do this with two sharepoint list?
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You perform a Get items on each, replacing outputs('Alpha') and outputs('Beta') with outputs('Get_items')?['body/value'] and outputs('Get_items_2')?['body / value'] in the expressions (or whatever you called your Get items actions)