Check if Email exist in O365 in PowerApps

[Prateek9]

Hello PowerUsers,

I am new to PowerApps and I am building an app where user will enter the email address in text input field inside the Edit Form. I need to validate the entered email with Office 365 Users to check whether email exists or not. After checking whether email is correct OR it exists w.r.t Office 365 Users , there should be a message OR Icon which will show if the entered email is valid/invalid.

Can you please help me with it . This is my first time doing it and I could not find an appropriate answer for this.

UPDATE:  Though i have kept one message as solution but the entire conversation was what helped me to get the correct answer.

[WiZey]

Hello @Prateek9 ,

With the "Office 365 Users" connector, you can search for a user with an name or an email.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-office365-user...

IsEmpty(
  'Utilisateursd’Office365'.SearchUserV2({
    searchTerm:TextInput.Text
  }).value
)

"IsEmpty()" will return true if there are matching results.

[Prateek9]

Hello @WiZey ,

I am not searching for a user email , what I want is that i have entered an email id in "Text Input" and i want that email id to be validated whether it is correct or not using "Office365 User". 

Maybe i got it wrong . Can you please tell me where i should enter the code to achieve this.

Also , is there any icon I can use which will indicate that email is correct or not and what code to enter in it ?

[WiZey · Accepted solution]

The formula I gave you let you check if the name or email inputted exists in your office 365 base, but maybe a better method would be to use a combobox instead of a textinput to look for an existing email instead of checking their validity?

Combobox.Items: Office365Users.SearchUserV2({searchTerm:Self.SearchText}).value

With a combobox, you can enter any name and it will automatically look for every matching results which you can then select from the control. 

As for the icon, as it is purely visual, I guess any icon from Power Apps can do? However, if you want to check if the user selected an email from the combobox, you can use this:

IsBlank(ComboBox.Selected) //Single selection
or
IsEmpty(ComboBox.SelectedItems) //Multiple selections

[Prateek9]

Hello @WiZey ,

thanks for your suggestion , I inserted the Combobox inside the Data Card where earlier there was Text Input and I am able to search for email address directly . But now i am facing another problem. 

After inserting the Combobox in DataCard , when i am changing the "Update()"property to - Combobox.Selected , it is giving me the error "Expected Text Values".

Background

In my app , I have mutiple screens and this is one if them. At the end , i am submitting the data which gets saved in Sharepoint List and I want the full email address to be saved in SP list.

[WiZey]

That's because the combobox's items are users, which by definition are records with multiple columns.

By referencing "Combobox.Selected", it returns the whole record instead of just a single column.

Try with "Combobox.Selected.Email" if you want to get the selected's email.

[Prateek9]

thanks @WiZey  

Email is getting saved in SP List now . 😊
I know this is not the topic for which i have raised the issue but would be grateful if you can help me with it . When I am displaying the data in Gallery , i am able to do it but when i use the "View / Edit " functionality through icons , email field is coming as blank there 

Gallery data (Email address is getting displayed):

When clicking on View /Edit Button , Email field coming as blank :
View :

Edit:

Below is the code that i am using when I click on View /Edit icon :

View:

Edit:

Can you please check and help me with this.

[WiZey]

Check the "Default" property of your combobox. It must be blank or something.

Every control in your form has a "Default" property filled with the value of the item of the form. It must be something like "Parent" or "ThisItem", you'll have to check it.

As the "Items" property use "Office365User.SearchUserV2()" as a datasource, you must use the same function to populate "Default" property of your combobox.

ComboBox.Default: First(Office365Users.SearchUserV2({searchTerm:Parent.Email})).value

[Prateek9]

@WiZey 

You are correct , Default property was blank for my combobox control . But even when i am trying to enter the code that you shared above , it is giving me an error , not sure if I am doing anything wrong.

Default Property Blank

Error when entering the code (ComboBox1 is the name of the control)

[WiZey]

Don't put "ComboBox1.Default:" in the property, I wrote it only to make it more easy to understand.