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,
Solved! Go to 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,
@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."
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.
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,
User | Count |
---|---|
256 | |
106 | |
92 | |
47 | |
37 |