Trying to set Visible based on User().Email and SharePoint list comparison.

(0) Share

Report

Posted on by StefanV

Good day.

I am new to PowerApps and would like some assistance.

I am trying to set the visibility of a container with the following:

If(ListName.Email = User().Email, false, true)

Where 'ListName' = the name of my SharePoint list with simple text emails.

But this does not work.

Any assistance would be appreciated. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @StefanV ,

Nearly there, try:

!Blank(LookUp(ListName, Email = User.Email))

You can leave out the If statement since the condition itself already returns a boolean.

Was this reply helpful? Yes No
StefanV 34 on at

Like (0)

Report
Thanks for your response @BCBuizer, but I was still not able to get it to work.
In the meantime I have created to collections, one with my User().Email and another from a list of Emails in SharePoint. Now i am trying to compare the two and if the User().Email is found in the other collection, I want to change the FormMode of a form.
If(UserEmail.Value = Users.Email, FormMode.View, FormMode.New)

Where UserEmail = email from the the logged in user and
User = Collection from Sharepoint list with email addresses
Now I cannot compare the two, even though they are both tables?
Please could you assist wit this?

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @StefanV ,

Can you please share what is not working for you on the original topic?

On the new question, there's two things:

1. Is UserEmail a record or a text? From your decription it looks like text, only containing the email address so the '.Value' should be dropped.

2. Users.Email is a table indeed, so it can't be compared against a text or record using the '=' operator. Rather the 'in' should be used:

If(UserEmail in Users.Email, FormMode.View, FormMode.New)

Was this reply helpful? Yes No
StefanV 34 on at

Like (1)

Report

Thank you @BCBuizer! That works perfectly...

I was still not able to compare the two tables in the original question, but this now solves my problem, thank you!

Was this reply helpful? Yes No