How to check which records are missing in SQL

(0) Share

Report

Posted on by CU30091316-0

Hello,

I have such a flow and I would like to check what records are missing in SQL in relation to SharePoint. Two databases have the same ID. I am a bit confused and I am asking for help:

Categories:

Business Process Flows

All responses (3)

Answers (0)

CU30091316-0 2 on at

Like (0)

Report

How to check which records are missing in SQL

I tried to use Filter Array but I get the wrong result. This is my code.

What I mean is that when I have 25 in SQL I would like to find those 4 more that are in Sharepoint

@not(contains(outputs('Get_rows_(V2)')?['body/value'], item()))
Suggested answer

SaiRT14 1,988 Super User 2025 Season 1 on at

Like (0)

Report
How to check which records are missing in SQL

Loop through SharePoint IDs:

Use an Apply to Each loop on the SharePoint IDs array.

Inside the loop, use a Condition action to check if the current SharePoint ID exists in the SQL array.

Check for Missing Records:

If the ID does not exist in the SQL array, you can mark it as missing by appending it to a separate array (e.g., a "Missing IDs" array).

Create Output:

Once the loop completes, output the "Missing IDs" array to either a SharePoint list, SQL table, or send it via email using the Send an email action.
David_MA 11,500 Super User 2025 Season 1 on at

Like (1)

Report

How to check which records are missing in SQL

It has been quite a while since I have done something like that, but I think what you need is in this blog post: Efficient Union, Except And Intersect – Great Method - DamoBird365. I don't know if this is the same resource I used, so I cannot guarantee it will meet your needs. But I am pretty sure you can do it with something like this.