Announcements
as this picture, how can I get values from the other table?
any ideas,please.
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.
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.
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 491
WarrenBelz 407 Most Valuable Professional
11manish 331
