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
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!
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)
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?
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.
MS.Ragavendar
20
BCBuizer
10
Super User 2025 Season 1
LC-26081402-0
10