Answered

if(lookup hekp please

(0) Share

Report

Posted on by hstep

Hi all,

ive read all the articles i can find to no avail, its a simple one but i cant get it working.

i have a table called 'loginstatus' when somebody logs in to a record it records the record id and their name , when they come out it removes them from the list , i want to set an icon to icon.lock if the record id is in that list.

If(LookUp('Login status', 'Record id') = ThisItem.ID),icon.lock,icon.details)

If(LookUp('Login status', 'Record id' = ThisItem.ID),icon.lock,icon.details)

tried lots cant sus it out help please, this will work with just the look up but i need a true false scenario.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @hstep ,

With "IsBlank()", you can check if "LookUp()" has returned a result or not.

If( IsBlank(LookUp(...)), Icon.Details, //A record doesn't exist Icon.Lock //A record exists )

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(LookUp('Login status', 'Record id' = ThisItem.ID)), do this if doesnt exist in list, do this if does exist in list)

for icon.lock use Displaymode.Disabled
for icon.details use Displaymode.Edit

The formula will have to be in the DisplayMode property for the icons you want to use it on

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
If(!IsBlank(LookUp('Login status', 'Record id' = ThisItem.ID)),icon.lock,icon.details)

Assuming when you said it removes them from the list it is actually deleting the row, then you can use the above.

However if you are not deleting the row and instead setting the name to blank when they leave the records, then the following:

If(!IsBlank(LookUp('Login status', 'Record id' = ThisItem.ID).YourNameFieldGoesHere), icon.lock, icon.details)

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

still no luck :
If(IsBlank(LookUp('Login status','Record id'=ThisItem.ID, Icon.Lock),Icon.DetailList))

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

hi , i am setting the record id to blank but the name field stays populated with our emails until we fully log out , i still get an error on both
If(!IsBlank(LookUp('Login status', 'Record id' = ThisItem.ID).'Record id'), icon.lock, icon.details)
If(!IsBlank(LookUp('Login status', 'Record id' = ThisItem.ID).Name), icon.lock, icon.details)

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the error?

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

sorted thanks

Was this reply helpful? Yes No