How to refer a field that is not added to any screen

(0) Share

Report

Posted on by Rohit4044041

286

Hello

This might be veyr simple, however i am not able to get this.

I have a sharepoint list form customized as powerapp. List has a field called DirectorEmail, which is not added to any screen in powerapp.

Now, I need to compare this directoremail feild agianst current loggedin user email. I tried to compare User.Email() and then when I am trying to access directoremail field, ido not get it.

Only if I use DirectorEmail datacard to the screen I cna access its value and compare.

May I know what am i missing? Is it must to add all feilds as datacard to access their values? (I do no want copare against whole list datasource and filter depending on item Id while i already have current item context.)

any thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,762 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rohit4044041 ,
As long as you have the list connected as a data source, you do not need to display it anywhere to refer to it. So to see if it contains the User's email, you could set a Variable called gblDirector at App OnStart

Set(varUserMail,User().Email); Set( gblDirector, !IsBlank( Lookup( wList, DirectorEmail=varUserMail ).DirectorEmail ) )

This will return true if the user's email is in the list (false if it is 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
WarrenBelz 155,762 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rohit4044041 ,

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