Answered

Trouble with getting PowerApps to return correct information for a a boolean statement

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all.

I have the following statement in my powerapp but it is telling me that my email is not found in my data connection via sharepoint. My data connection is there so I'm not sure what's wrong.

IsBlank(LookUp(User_Access_3, Title = User().Email).Title)

My sharepoint site list is set up as user access with the column header title. the column includes my email address.

I don't know why it's telling me "true" when it should be finding my email as the user.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BrianS 2,407 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I would check to make sure the SP list has the exact same email - case matters.
Maybe this would be more reliable:
IsBlank(LookUp(User_Access_3, Lower(Title) = Lower(User().Email)).Title)
as it will ignore the case of both emails

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks! That did the trick!

Was this reply helpful? Yes No