Get data with User().Email function

(0) Share

Report

Posted on by jaimeMtz07

159

Hi Team, I hope you are doing well and covid free 🙂

I am building a power apps App with a datasource in SP list, is a simple form that gets data and register data to the list of SPs.

but I need a formula that allows me to get the data from another column when the user using the app is in the list.

I have the following list of data in SP:

Datasource: PagosBDF

Name Email Cost

Jaime jaime.mtz07@.... 40

jose jose.mtz07@...... 80

Pedro pedro.mt07@.... 120

when the user jose.mtz07@.... is using the app I want to obtain in a TextInput the value of the Cost column (80), If the user who is using the application is Jaime.mtz07@... I want to obtain the value of the cost column (40).

I was using this formula Value(LookUp(PagosBDF, User().Email in PagosBDF.Email, Cost) but I only get the first value of the entire SP list, can you help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

rebeccas 2,591 on at

Like (3)

Report
Copy link

Link copied!

This should give you what you are needing as long as the "Email" is the actual name of the column on your SP list.

LookUp(PagosBDF, User().Email, Cost)

Here is just as a reference:

LookUp(SPList, SPColumnName = MyVariable, SPColumnIWant)

If you are going to use this in more than one place in the app I would suggest you set this as a variable at the apps OnStart and can refer to it where you need to instead of LookUps in multiple spots.

Rebecca

Was this reply helpful? Yes No
timl 36,634 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@jaimeMtz07

I'm pretty sure what @rebeccas intended to say is this - note the 'Email=' part of the condition.

LookUp(PagosBDF, Email=User().Email, Cost)

Was this reply helpful? Yes No
jaimeMtz07 159 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot Rebeccas

Was this reply helpful? Yes No
jaimeMtz07 159 on at

Like (0)

Report
Copy link

Link copied!

Thank a lot Timl, When I tried Rebecca's code I realized this, thank you very much I will still accept Rebecca's solution just because she answered first hehe

Was this reply helpful? Yes No