How to lookup and return user email property

[Anonymous]

Hi,

I am trying to disable the display properties of a datacard value within a form based on the value of a person field lookup from another datasource - I am trying to use something like: 

If(LookUp(CollectionName,ID = Value(RelatedID),Person.Email=MyEmailVariable),Edit,Disabled)

But it will not work due to the Person.Email properties returning a table -  It works fine if i am just returning a string value from another field. How can I format this correctly?

Thanks,

[mdevaney]

@Anonymous 

It looks like you placement of the right bracket is in the wrong place.

If(LookUp(CollectionName,ID = Value(RelatedID),Person.Email)=MyEmailVariable,Edit,Disabled)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[TiagoFreire]

Have you tried: 

If(MyEmailVariable in LookUp(CollectionName,ID = Value(RelatedID),Person.Email),Edit,Disabled)

?

The in operator can look for the value in a one column result set.

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about the "Person" field in your another SP List? Is it a Person type field with "Allow Multiple selections" enabled?

Based on the needs that you mentioned, I have made a test on my side, please consider take a try with the following formula:

If(
   MyEmailVariable in Concat(
                              LookUp(CollectionName, ID = Value(RelatedID)).Person, 
                              Email & ";"
                      ),
   Edit,
   Disabled
)

Note: I assume that the Person field in your another SP List is a Person type column, which enable "Allow Multiple selections" option

Please consider take a try with above solution, check if the issue is solved.

Best regards,