Answered

Lookup & Displaymode

(0) Share

Report

Posted on by evanscona

Hello team, please can someone help me with the right function below? I keep getting errors. My goal is, I want to lookup from sharepoint for "admincredentials" to be able to give users a particular disploymode capabilities:

If(LookUp(Admincredentials, Title = User().Email), Parent.DisplayMode,DisplayMode.View ) Screen Shot 2021-05-22 at 10.02.14 AM.png

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @evanscona the first part of your return a table hence the error, try replacing it with IsBlank which will return a boolean

If(!IsBlank(LookUp(Admincredentials, Title = User().Email),Parent.DisplayMode,DisplayMode.View )

Hope this helps

Was this reply helpful? Yes No
evanscona 65 on at

Like (1)

Report
Copy link

Link copied!

Thanks @rubin_boer it worked. I added one more parenthesis to the User().Email)) and it worked.
Thanks Again!!!!

Was this reply helpful? Yes No