Answered

How to lookup and return user email property

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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."

Was this reply helpful? Yes No
TiagoFreire 313 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No