Unanswered

Verify Multiple Emails Addresses from Excel

(1) Share

Report

Posted on by TremainSr

Hello,

Does anyone know if Power Automate has the capability to verify multiple email addresses from an Excel spreadsheet? The data is exported into Excel spreadsheet with Full names and Email addresses. I need to verify all emails are (valid) through Microsoft Outlook gal in which it can be hundreds of emails at a time. It takes a lot of (Man Hours) to type each individual email or name into Microsoft Outlook to cross reference. Is their any flows out there that can leverage this?

Categories:

Building flows

I have the same question (2)

All responses (3)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @TremainSr

Here are the steps for verifying emails in excel sheet.

1. Firstly, use "List rows present in a table" to get the records from excel.

2. Next, use "Apply to each" action to iterate the records

2.1. To verify email address use "Get user profile" action and pass the email address as input.

2.2 Set "Configure run after" settings to catch the error if email verification fails.

2.3 Collect valid and invalid email address in parallel branches in variable or separate excel sheet as per the requirement.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
TremainSr 13 on at

Like (0)

Report

Hello @ManishSolanki

Thank you for you reply! When I get into work tomorrow I will test your Power Automate setup. I will definitely let you know how it goes. Thanks again!!!

Was this reply helpful? Yes No
TremainSr 13 on at

Like (0)

Report

@ManishSolanki

It worked for what I needed it to do and thank you. However, I have a question or you.... I have end users that does't have admin rights to use Power Automate. Is it possible that Power Automate can update a column next to the email for the status? Meaning (user found / user not found) next to the email addresses?

Was this reply helpful? Yes No