use record in Excel file A to find record that match in Excel file B that contain Email

Like (0) Share

Report

Posted on 8 May 2024 04:55:45 by nitisak

162

Hi,

I would like to build Automate to use record in Excel file A that have Account Number to find record that match in Excel file B that contain Account Number, Email and use the email in Excel file B to send email with outlook.

Anyone please guide me.

All responses (9)

Answers (1)

nitisak 162 on 23 May 2024 at 04:16:50

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @v-yetonggu-msft

In case of not found account number if I would like to chow account number that not found in Master file what should I do
nitisak 162 on 13 May 2024 at 07:26:01

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @v-yetonggu-msft

Got it thanks!
Verified answer

v-yetonggu-msft on 13 May 2024 at 04:42:43

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @nitisak ，

Do you mean you'll manually enter the email address of a specific recipient?

If it is not greater than 0, it proves that no matching Account Number was found.

If so, please add send an email(V2) to No branch and manually input email address.

Best Regards,

Sunshine Gu
nitisak 162 on 13 May 2024 at 04:25:13

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @v-yetonggu-msft

I mean I will put email in to action of outlook instance of push from excel file
v-yetonggu-msft on 13 May 2024 at 02:57:41

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @nitisak ,

This is a strange question, where is your specific email address stored?

Best Regards,

Sunshine Gu
nitisak 162 on 13 May 2024 at 02:34:53

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @v-yetonggu-msft

Thank you! another question if Account number in file A can't not found in File B and I want to send email to specific in case of this, how can I write the logic ?
v-yetonggu-msft on 08 May 2024 at 06:53:45

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @nitisak ,

Of course, if you look closely, you can see that my two tables are also in different files, Book1 and Book2.

Best Regards,

Sunshine Gu
nitisak 162 on 08 May 2024 at 06:51:03

Like (0)

Report

Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @v-yetonggu-msft

If is not in the same file it will work as well ?.
v-yetonggu-msft on 08 May 2024 at 06:04:45

Like (0)

Report
Re: use record in Excel file A to find record that match in Excel file B that contain Email

Hi @nitisak ,

If you want to find the corresponding email address by the Account Number column between the two tables, please see this test:

My excel table1:

My excel table2:

My Flow:

item()?['Account Number'] items('Apply_to_each')?['Account Number']

length(body('Filter_array')) items('Apply_to_each_2')?['Email']

Best Regards,

Sunshine Gu