Hi All,
I have a created a share point list and from there I have created a default Power App.
That form contains some fields like "Signum", "First Name", "Last Name", "Line manager", "Email ID" etc....
Now I want as soon as user fill "Signum" details than rest of fields should auto filled by importing information from office 365 account.
can anybody help me out.
Hi @Negi1984 ,
Could you please share a bit more about the "Signum"? Could you please share a sample format about it?
Do you mean that the "Signum" is included in the email address of a user?
If the "Signum" is included in the email address of a user, and the "Signum" is unique for each user. Regarding the needs that you mentioned, I think the Office 365 Users connector could achieve your needs.
Within your Edit form, set the Default property of the First Name field Text Input Box to following:
First(
Split(
First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).DisplayName,
" "
)
).Result
Set the Default property of the Last Name field Text Input Box to following:
Last(
Split(
First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).DisplayName,
" "
)
).Result
Set the Default property of the Email field Text Input Box to following:
First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).Mail
Set the Default property of the Manager field Text Input box to following:
Office365Users.ManagerV2(First(Office365Users.SearchUserV2({searchTerm: SignumTextInputBox.Text, top:999}).value).Mail).displayName
Please try above solution, then check if the issue is solved.
Regards,
Hi Randy,
I am basic user of Power App. Could you please share some screen shot , which functions I need to use to autopopulate fields ?
"Signum" field is tagged to each email ID. suppose so if we search any user than we can use Signum in email or skype or Team chat.
You will need to change the Default property of the form fields you want to set.
However, the question is - how does signum relate to an Office365 User?
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2