Find missing report name

Learning Initatives Automation Starter
1

i have two excel one excel contains 4 report names and other excel contains 6 report compare both and find any one is missing from 4 report names and send mail report is missing

2

Hello

Can you provide an excel sample of each?

That way a solution can be developed based upon your column names.

3

copy.xlsx (9.6 KB)
this is my excel here sheet 2 column name is Transaction_Reference have 4 report and sheet1 column Transaction_Reference have 5 report if any report missing from shee2 then send mail report is missing

4

Hey @Yogita_Gaikwad

Take a look here.

Orange = Match
Red = No Match.
image

Result File:
Input.xlsx (11.2 KB)

Workflow:
Main.xaml (13.4 KB)

The results are saved in a new tab called “RESULT”.

Hopefully this helps you :blush:

Cheers

Steve