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
Solved! Go to Solution.
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
)
doesn't recognize it 😞
When I put Office, I only get this
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
I already found the solution, thanks to @sajarac . Many thanks to the people who helped me. this was the solution.
Select the DataCardValue of the Email field
I had to go to the field and edit
I had that data blank. And that's why it doesn't bring me any data
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
User | Count |
---|---|
253 | |
113 | |
92 | |
48 | |
38 |