web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Check if person is in ...

Power Apps

Answered

Check if person is in person column

(0) Share

Report

Report

Posted on by Field

339

Hello there,

I have added a Person/Group column to the sharepoint.

There is only one item on that list, and that column contains 2 people.

Jane Doe and John Doe (In the column they are "Jane DoeJohn Doe", they are not separated)

If I do an if statment like:
If(!IsBlank(Filter(ExampleList, "jowdijowiqjwd" in ColumnPerson.Email)); true; false)

It will always give me true, even if that email exists or not in that list.

I can put some random variable and it will always give me TRUE.

How can i fix this?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Field

You should use ISEMPTY instead of ISBLANK..

If(!IsEmpty(Filter(ExampleList; "jowdijowiqjwd" in ColumnPerson.Email)); true; false)

ISEMPTY checks if any records were returned in a table. ISBLANK checks if a text string or a number is null.

---

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."
Field 339 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx, that helped.

If i wanted to filter with other columns (per example text), it will bug out because im not using "IsBlank()"

Any ideia how to fix this?
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Field

I'm not really sure what you are asking here. Maybe post it as a new question and I'll take a look? If I can't answer it someone else will likely pick it up fast!

Join the conversation