cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Br4yan1931
Helper I
Helper I

"Como obtener el dato de un Email" - "How to get data from an email"

Hello everyone.

I need help, I have a SharePoint record and I'm making the form by Power Apps.
What I want to achieve is this:

There is a field that is "Email" and another field is "Name". When the "Email" is entered, I want the full name of that Email to be entered automatically in the "Name" field.

I will be attentive to your comments. Thank you very much


----------------------------------------------------------------------------------------------------------
Hola a todos.

Necesito ayuda, tengo un registro de SharePoint y estoy haciendo el formulario por Power Apps.
Lo que quiero lograr es esto:

Hay un campo que es el "Email" y otro campo "Name". Al momento de que se ponga el "Email" quiero que automáticamente en el campo de "Name" se ponga el nombre completo de ese Email.

Estaré atento a sus comentarios. Muchas gracias  


23 REPLIES 23
TheRobRush
Super User
Super User

Ok I see what I was missing now, I was on my cellphone at lunch so had a much smaller screen. I was answering your questions assuming the splist Column Email was a text column with an email stored in it. I see now that it is a people person column.

 

Try something like this instead. It will lookup that specific person, and if their email is not blank, will return their email address. Again due to our powerapps being in diff languages you may have to check punctuation.

 

LookUp(
       Office365Users.SearchUser(
                        {searchTerm:DataCardValue2.Selected.Email}
                                ),
                                 IsBlank(Mail)=false,
                                 Mail
       )

 

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

doesn't recognize it 😞
Br4yan1931_0-1646174349956.png

When I put Office, I only get this

Br4yan1931_2-1646174536122.png

 

TheRobRush
Super User
Super User

You may have to go to view, sources, and add office365users.

 

It is also a possibility that it is spelled different in spanish powerapps. But Office365Users is in all o365 accounts so maybe double check with @sajarac on the context in spanish

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!
Br4yan1931
Helper I
Helper I

I already found the solution, thanks to @sajarac . Many thanks to the people who helped me. this was the solution.

Br4yan1931_0-1646232902514.png

Select the DataCardValue of the Email field
I had to go to the field and edit

Br4yan1931_1-1646233137845.png

I had that data blank. And that's why it doesn't bring me any data

Br4yan1931_2-1646233399743.png
I go where my "name" field is, which would be DataCardValue4 and in default, I put this.

DataCardValue3.Selected.DisplayName

and my full name appears.

thanks a lot to everybody who help me.

Thank you very much, @TheRobRush , @sajarac , @Himanshu_90677 



Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,636)