Visible: Check current user in multiple person column

(1) Share

Report

Posted on by nrd10

132

Hi,

I have Icon in the gallery, and then I want to check in the Icon Visible property, if the current user email is already in Vote Column (Multiple person type) then the visible is false,

Can anyone help me with this?

this is my code, but its not work

!IsBlank(Filter(Feedback, Office365Users.MyProfile().Mail in ThisItem.Vote.Email))

Feedback: my table
Vote: Multiple person Column

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @nrd10

Try this formula,

!IsBlank(LookUp(Feedback, Vote.Email = Office365Users.MyProfile().Mail, Vote))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
nrd10 132 on at

Like (0)

Report
Copy link

Link copied!

Hi,

i try this, and have this error

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
@nrd10 Try this

!IsBlank(LookUp(Feedback, Office365Users.MyProfile().Mail = ThisItem.Vote.Email))

Was this reply helpful? Yes No
Verified answer

LukeTahi 34 on at

Like (1)

Report
Copy link

Link copied!

This would be the best way to do it

assuming a collection is titled Feedback or a formula is titled Feedback

the column value we want to test if the user email is called Vote.Email

the user email is Office365Users.Profile().Mail
as opposed to User().Email

Countrows( Filter( Feedback, Office365Users.Profile().Mail exactin Vote.Email)) = 0

Was this reply helpful? Yes No
nrd10 132 on at

Like (0)

Report
Copy link

Link copied!
hi @Rajkumar_404 @LukeTahi

thankyou, i try to combine and its work

IsBlank(LookUp(Feedback, Office365Users.MyProfile().Mail exactin ThisItem.Vote.Email))

Was this reply helpful? Yes No