Unanswered

Autofill user data based on e-mail (datasource: excel table)

(0) Share

Report

Posted on by Elliago

Hi guys, I am creating a Contact Finder app for my company.

As a data source, I used a exel table (Online Excel for Business), where I have 2 "contact columns": "Contact person" and "E-mail".

In the detail page of my app, I would like not only to show (in a form) the data taken from the excel, but also other data (City, phone Number ect) , which should automatically be filled in though Office365Users using as searchterm the name or at least the e-mail address already displayed the other datacardvalues. How do I do this?

I tried with these formulas, but it does not work:

Office365Users.UserProfile(ThisItem.'E-Mail ').TelephoneNumber

Office365Users.SearchUser({searchTerm:Gallery1_1.Selected.'Contact Person'}).City

First(Office365Users.SearchUser({searchTerm:ComboBox1.SearchText})).City

Thanks!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Elliago ,

All of those formulas as valid if you have the user's email address in the relevant reference (I just tested them using this). When you say "does not work", are you getting an error or simply no result ?

Was this reply helpful? Yes No
Elliago 4 on at

Like
a
(0)

Report
Copy link

Link copied!

There is no error, I simply get no result. Do you know how I might solve this problem? Thanks in advance!

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Elliago ,

If you have a valid email address in any of those references and a Telephone Number / City in the user's record in Active Directory, then the formulas you posted should display that item - have you checked all of these elements exist ?

Was this reply helpful? Yes No
Elliago 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I checked. I also put myself on the contact list and tried the formulas. I know I have a Phone number, but it did not show anything at all. If I use User() it shows my Phone Number, but that´s not the formula I am looking for

Was this reply helpful? Yes No
WarrenBelz 156,432 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Elliago ,

Sorry, but that makes no sense to me presently - if you put these two items on Labels, do you see valid email addresses ?

ThisItem.'E-Mail '
Gallery1_1.Selected.'Contact Person'

The third item though does not need First() as you are searching on the SearchText, not the selected item.

Was this reply helpful? Yes No