Hi
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