How to get value from table,[Object,object]

(0) Share

Report

Posted on by LazyLazy

as this picture, how can I get values from the other table?

any ideas,please.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report
Hi @LazyLazy

If you call the the Lookup function instead of Filter, that should resolve the problem for you. This will return the first record in Test_Requester where the title field matches the email address of the current user.

Lookup(Test_Requester, User().Email = Title).Req_Approver

Another comment I have is that you should consider saving the value of User().Email into a variable, and to use that in your condition. This will prevent a potential delegation problem.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @LazyLazy ,

That is a Delegation error as User().EMail is not Delegable.

Firstly, at App OnStart, do this

Set(varUserMail,User().Email)

then this should work

Filter( Test_Requester, Title=varUserMail ).Req_Approver

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report

Hi @LazyLazy ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No