Using User Email for lookup

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I want to use the User E-Mail to look in a connected excel table for another value, which I can use later to filter a ComboBox.

I tried it with a simple lookup:

LookUp(UserInfo, UserMail=User().Email, Country)

But it's not working.

Does anybody know why?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Can you give a little more information on your data, table name etc. Your formula looks fine.
LookUp(UserInfo, UserMail=User().Email, Country)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sure, sorry.
The table name is 'UserInfo', it has only two columns, one is named 'UserMail' and the other one 'Country'.

Was this reply helpful? Yes No
kbilakanti 315 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous Your forumula, looks fine, can you please add a screenshot of your excel data if that's okay with you. And can i know what is the error you are getting in that formula?

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (2)

Report
Copy link

Link copied!

As i said earlier your formula if fine. I have tested it at my end. Kindly look at data source in your UserMail if it corresponds to the User().Email.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Attached a screenshot of the excel table and the formula + what I get as value (false).
The E-mail address in the excel sheet corresponds to the User().Email.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Refresh your datasouce

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Already did this a couple of time and also deleted the connection and connected it again,

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

It will definitely be resolved. What about another textbox, or logout login

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi all,
I will throw my 20c worth in (probably all that it is worth).
This causes a delegation issue with SharePoint - not sure on Excel.
It might be worth trying
UpdateContext({vEmail:User().Email}); LookUp( UserInfo, UserMail=vEmail, Country )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Not working...

Was this reply helpful? Yes No