Answered

Power Automate Dupe Checking

(0) Share

Report

Posted on by chrissmf2023

I have x2 SharePoint lists - one for in-flight requests and one for historical (archived) requests.

I'm trying to work out how to create a flow to essentially compare the two lists when an item is created on the in-flight list, and flag it as a duplicate.

Essentially, when a request is created and the item is loaded into the in-flight request list, a dupe check is triggered against the archive list to highlight if that record (e.g agreement number/unique reference etc) appears on the historical list too.

Apologies if this is already covered on another thread.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

TSte 240 on at

Like (0)

Report

Create a automated flow that is triggered when a sharepoint item is created,

add the "Get Items" SharePoint Action, link the "historical list"

in the add a filter Query, for this take what ever value(column) you want to search from the sharepoint item (agreement number/unique reference)..

Query could look like that

'agreement number Column Name' eq 'Get Items agreement number' and 'unique reference Column Name' eq 'Get Items unique reference'

then add a If condition: (if a item was found the body contains values, so there is a existing item)

on the left side Length(body of Get Items) | greater then | 0

on the yes side

Update Item action, linked to the created column ID and write duplicate in a column, or something like that..

that should sketch the whole process, you should be able to finde guidance in web for all steps

Was this reply helpful? Yes No
Verified answer

chrissmf2023 24 on at

Like (0)

Report

Hi - Thanks this sorts the issue perfectly.

Is there a way to have the flow loop through to display all the duplicates?

e.g I can currently get the flow to update a column to display the duplicate its found, but if there a multiple duplicates in theory i'd want it to list them all.

Thanks

Was this reply helpful? Yes No