Answered

Using User Email for lookup

(0) Share

Report

Posted on by Community Power Pla...

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

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... on at

Like (0)

Report

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

@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

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... on at

Like (0)

Report

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.

Excel Table_User....

Capture.PNG

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

Like (0)

Report

Refresh your datasouce

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

Like (0)

Report

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

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

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
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... on at

Like (0)

Report

Not working...

Was this reply helpful? Yes No