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:
-
List Rows from Dataverse Table:
-
This step retrieves a list of rows containing email addresses.
-
-
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:
- Invalid Email Response:
Requirement:
I need to separate the emails into two lists:
- Valid Emails
- 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!

Report
All responses (
Answers (