Duplicate Cell entry and using try catch to skip and report

Help Activities
, ,
1

Hi Team,

I am needing some ideas.

  • I am reading in a excel with 3 columns “policy number” “claim number” and "Image Code’
  • what I am wanting to do is if there is a duplicate “Policy Number” and “Claim Number”, I’m wanting to skip that entry from been sent to the queue but I want to in a report, to send to the dept to check manually and action accordingly.

image

image
image507×795 11.3 KB

I’ve tried researching a few ideas but nothing comes of what im needing, Im 2 months into my journey so please explain in as basic as possible lol. thank you

2

use remove duplicate activity

for reference follow this video

1 Like
3

Thank you, this was helpful for the first part, the last part is I want to dump the duplicate rows into a report to send in email to the dept to check manually and action if required.

4

you want to send all dublicate or in how you want to send ?

5

I’m wanting to send all duplicates .

6

send me your project folder i will send to you

8

project xaml

9

Main.xaml (41.1 KB)