Jun 20 2022 03:24 AM
Hi together,
I have a question regarding Sharepoint Power Apps:
I have a list consisting of the columns: Person, Email, Phone
What I want to achieve is that if I add a new item and type in the name of the person, the email and phone shall automatically be pulled from the person contact data.
I saw that this is possible to do with power apps but I only achieved to pull the data from the user that adds the new item (my own).
Do you know how I can solve my problem?
BR
Jun 21 2022 09:35 AM
@SetvarCurrentUserExis
One potential solution.
This is the list in question:
Within the Power App built from your list, add an additional data source
(Office 365 Users, to get the business phone details)
'OnVisible' of the Edit Screen set a context variable, which is intended to keep track of the result for the user search against the Officer 365 connector. The 'DataCardValue5' is in my case the Person column form field.
Copy and paste the same formula into the onChange property of the 'DataCardValue5'.
UpdateContext({SelectedPersonLookup : Office365Users.SearchUser({searchTerm:DataCardValue5.Selected.Email})})
The default value of the DataCardValue4 (my e-mail field) would then be
First(SelectedPersonLookup).Mail
and for the Phone number (which could included multiple numbers)
First(First(SelectedPersonLookup).BusinessPhones).Value
Additionally you could think about removing the option to manually alter the e-mail and phone number by changing the DisplayMode property of both form fields
Nevertheless you might need to adjust this solution furthermore, depending on your requirements.