web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate: Extra...
Power Automate
Suggested Answer

Power Automate: Extracting Valid and Invalid Emails from Dataverse Table Using Custom Connector

(0) ShareShare
ReportReport
Posted on by
 

I have a Manually Triggered Flow in Power Automate, where I’m working with a Dataverse table to validate email formats through a custom connector. Below is the process I’ve followed:

  1. List Rows from Dataverse Table:

    • This step retrieves a list of rows containing email addresses.

  2. Custom Connector to Validate Email Format:

    • Inside the custom connector, I’ve added logic to validate the email addresses.

    • Since the data is coming from List Rows, an Apply to Each loop is created to validate each email.

The custom connector returns the following responses for each email:

  • Valid Email Response:

     
    json
    {
    "emailToValidate": "richard.janes@wpp.com",
    "isValidEmail": true
    }
  • Invalid Email Response:
     
    json
    {
    "emailToValidate": "rich.cree7com",
    "isValidEmail": false
    }

Requirement:
I need to separate the emails into two lists:

  1. Valid Emails
  2. Invalid Emails

How can I efficiently achieve this separation within the flow? Any suggestions for how to collect the valid and invalid emails as two distinct outputs would be greatly appreciated!

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Could anyone please help me to fix the issue 
Categories:
I have the same question (0)
  • Suggested answer
    Lucas001 Profile Picture
    2,538 Super User 2026 Season 1 on at
     
    one way which should work, not really efficient but should be working, add all your objects to an array variable and use a select afterwards filtering for true and one for false.
    If possible and for performance reasons, can you redefine your custom connector to accept an array as input as you already have the list rows? return and array containing two arrays with first being all mails valid, second all mails invalid [[valid],[invalid]]

    And moved it to the correct forum.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard