Test for valid organization email address before Form Submit

[Anonymous]

I am a novice Power Apps and Power Automate developer.  I have an issue I hope you can help me with.

I would like to prevent my Power App Form from being Submitted if any of the Approver (People) fields in my SharePoint list are blank or contain an invalid email address.  I am not looking to validate the format of the email address; I want to test to see if it is a valid organizational email address. 

In short, I have a SharePoint List, Power App and Power Automate Approval Flow.  I get the Approvers from a Dataverse table and write them to People fields in my SharePoint List using Patch statements on Form Submit.   When the Flow is triggered, it reads the Approvers from the SPList.  The Flow has many approval stages and many approvers.  Sometimes it fails to create an Approval because the approvers email is invalid (blank, or no longer a valid organization user).

I would like to validate that the Approver email address is valid before allowing the form to be submitted.  Note:  I am Patching on Submit.   If that is not possible, I would like to verify it in the Flow and gracefully exit the flow if it is not valid (instead of the flow just Failing at the Create Approval steps).

I have attached a document that contains the details of what I am currently doing (including code snippets), my issue, and what I am trying to accomplish.  Please review the attached document.

Thank you in advance for your assistance.

Kind regards,

Tom P.

[FLMike · Accepted solution]

Hello,

First, add the Office365Users connector

2. Next, do a search like so, using the email address they gave you and see if you get back a record with data. Now myself I would literally search using the email and either get back the Display Name and see if your name also matches, or get the Mail back (its the email).

Like so

Set(userSearchResultValue, First(Office365Users.SearchUser({searchTerm:EnterEmailOrNameHere})).Mail);

Now you will know.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[FLMike]

By the way I meant to add this

Office 365 Users - Connectors | Microsoft Learn

and better (for you)

Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn

As you can also do Office365Users.UserProfile(InfoAbout.Text).AccountEnabled to see if the account is enabled also.

[Anonymous]

Thanks FLMike for your reply and follow up reply.  Good info.  I appreciate the help.