Good Day Team,
Could someone give me a hand on helping me to find a way to validate if an email address exist and if it is valid? I have been looking for some solutions but I faild. Any suggestion will be great.
I am not aware of a way to test an email address to see if it exists but you can validate the email address is in the correct format.
This will return true if the EmailAddressFieldName is in the correct format.
IsMatch( [EmailAddressFieldName], Email )
Thanks for your solutions, I am trying to get this action done but I dont have experience, this is my first approach and what i need is, if the email is correct then go to the next stage but if email is incorrect i want send an email notification advising that email is incorrec. I have tried with "compose" and condition but I dont know where put or define the string "IsMatch( [EmailAddressFieldName], Email )" Will be great if you can give me a hand.. Thanks
You can use the IsMatch function on the OnSelect property of "Submit" or similar button that you might be using in the form.
As @Jeff_Thorpe said, it would only chekc if the email is in the correct format, it won't check if the e-mail itself exists or not. For example, if the user enters email@example.com , the IsMatch function will return true as the e-mail format is correct. However, if won't check if the e-mail exists or not.
Thanks @ThatAPIGuy for helping me, I was able to do this validation in my Power App form, however the form that is picking the info in this case is a Microsoft Form, once the Microsoft form is submitted the flow start, so what i need is inside the flow create a rule to validate the email or is there a possibility to validate in the Microsoft Form. I know that I am being anoyed probably I am going in the opossite direction.
Hi, Did you get a solution. I'm looking for the exact same thing.
I need a flow to validate if email exists in O365 when the MS form response is received.
This is a COVID-19 sign in form that has a text field for the employee email. The visitor (external) type the host's email (employee's email).
I found that MS form would work best in our case as I can share the link or QR code with the public. But the drop down functionality is very limited. Therefore, I do need a way to validate the email entered by the visitor.
If you found a solution, do you mind sharing it?
Thank you in advance
You can use the Microsoft 365 Users connector in the flow and lookup the user by the email address provided. Then use a condition to check the results and identify if the user exists in your directory.
Thank you for your prompt response!
It is running for the past 10 minutes I will cancel it. So I don't know if this works (pic above).
We have +800 employees + guest . Is there a expression or something I could use to read the emails of the employees only so that it will be faster?
I dunno if you have figured it out after 2 years, but what I did was to connect to Office365Users and add this condition:
If it returns false, it exists.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.